Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 DB load balancing

Author  Topic 

tommypa
Starting Member

19 Posts

Posted - 2008-09-10 : 13:55:31
Hi I currently have a DB server, SQL2005 and I am beginning to see some performance issue due to our clientele growing so rapidly. I have another SQL server and would like to setup load balancing so the DB1server doesn't get hit so hard. I'd like to have the traffic segregated onto two servers instead of one.

I am using Microsoft load balancing in my web environment and it works great can I do the same with my SQL db servers?

Tommy
   

- Advertisement -