Re: balancing connections - any idea ?
What precisely do you mean, "too many connections"?
I ask because you may have more going on with database design and
"mastiff" wrote in message
>I have 2 web server in load balancing configuration (NLB) and one database.
> We are going to add another web server.
> The problem is simple: too many connections on the database. It is a
> I know that microsoft did not create Real Application Cluster (like oracle
> ;-)) ), and I was testing 2 instance (one for each web server) with the
> peer to peer transactional replication splitting connections and
> replicating data to align databases.
> There are many problems with peer to peer replications (conflicts,
> identity iussues, ecc.), and I have so many tables.
> Do you have any other idea/solution to split/balance connections ?