balancing connections - any idea ?

Giganews Newsgroups
Subject: balancing connections - any idea ?
Posted by:  mastiff (gol…@trevize.com)
Date: Fri, 22 May 2009

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)

Replies