April 22, 2006 at 8:53 am
Hello,
Our team will have to implement an application that will have about 1500 clients connected doing a lot of transactions(its a callcenter)
Is possible to do a load balance in SQL SERVER 2000 to work with 4 servers and distribute about 400 clients per server?
I was reading about NLB on Windows 2000 Data Center version, and it says that i will have to do a Transaction Replication do work with that
Anyone experienced this kind of situation?
Thanks
Cleber
April 24, 2006 at 1:37 am
Are you sure that you need to spread the load like this? 1500 users per se isn't that much. From the SQL Server point of view, it's not excessive. However, depending on your app, there may be performance issues. Those aren't SQL Server's fault though...
Have you done any loadtesting to confirm that balancing is the way to go?
In any case, load balancing lies 'outside' the server, it's something that you stick 'in between' so to speak. Though you usually still have a single database at the back end. The balancing is usually done on the 'services' not the data layer.
/Kenneth
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply