SQL Server 2000 Load balancing
Posted on 2006-07-15
We are starting with a new project that I'll describe here and I need your advice.
It is a web based application that will have a lot of hits (around 2000 per second). We plan to have one SQL Server 2000 machine and two web servers with hardware load balancer for those two web servers. That configuration should be enough for the first phase (when not that much hits will happen).
What we want is to be able to easily extend our configuration by adding additional SQL Servers. For example: when we notice that our system becomes slower then we would like to add one more server machine which would host another instance of SQL Server 2000.
I read a little about SQL Server clustering but I'm not sure if what I need is possible. I want to have two or more SQL Servers running at the same time where all SQL servers are primary servers - I mean, I don't want to have a failover clustering which would assure that in case of a problem with one server the other one can be used. I would like to have real load balanced SQL Servers.
Is that possible to do with SQL Server 2000? Should we have some additional hardware for that?
Thank you all in advance!