What precisely do you mean, "too many connections"?

I ask because you may have more going on with database design and
performance.


"mastiff" wrote in message
news:4a16f32a$0$1108$4fafbaefatreader4dotnews.tin.it...
>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
> bottleneck.
>
> 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 ?
> Thanx
>
> Massimo
>
> (Mastino)
>