Networks

Ask something
Question Locked

SQL SERVER load balncing...

0 helpful
4 replies

by rabisahu3

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Does SQL Server 2005 supports Load Balancing?

How can it possible to do load balancing among many servers instead of single server while a client do request? I think it may be called as CPU Load Balancing.

Please you seniour and experience persons guide me here, how to do SQL Server Load Balancing.....

Thanks You
rabinarayan

4 replies

by rabisahu3

Yes,i have visited the page before time but still manythings to discuss/understand...
Please read the bellow statements...

1-Load Balancing and your Web applications: under this paragraph there are few comments as mentioned below.

If your SQL backend which all of your cluster nodes are accessing is maxed out, no amount of additional machines in the load balancing cluster will improve performance. The SQL backend is your weakest link and the only way to wring better performance out of it is to upgrade hardware or start splitting databases into separate servers.

So Dear Peconet, what I found in this link is , its doing load balancing in web application tier not in database tier.

But I want to know can NLB Clustering able to execute/run the client requested queries in separate servers insted of a single server to do CPU Load Balancing? Or for this CPU load balancing I have to do DISTRIBUTED PARTITIONED VIEWS in scal-out process???

Thanks YOu in Advance

by rabisahu3

Dear Poconet,

I have posted a written on SQL Server Load Balance. Now waiting for your reply. So could you please once more focus on my written and request here...

Thank You
Rabi narayan

This discussion is closed to new replies.