SQL Server Performance Forum – Threads Archive
SQL Cluster and NLB
HII am want to setup sql cluster with NBL
is it work if iam use MSCS and NBL
together for fail over and load balance
I can’t use active/active due to cross database performance
Thanks
Check: http://www.sql-server-performance.com/clustering_2000.asp HTH Luis Martin
Moderator
SQL-Server-Performance.com
… and this onehttp://www.sql-server-performance.com/clustering_resources.asp too. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
The website doesn’t have specific information on your exact question, although it has a lot of related info. I must ask what exactly do you want to accomplish? If your goal is just to save hardware, it will work for you, assuming that you are using these features independently. So give us some more details on what your goals are, and I will try to provide more specific advice. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com
SQL Server 2000 clustering does not provide load balancing; it provides failover clustering. To achieve load balancing between instances of SQL Server, you will need additional software. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
NLB is capable of running in mixed clusters with NT4.
NLB can be used to scale applications that manage session state spanning multiple connections, except in occasions that a server or network connection fails. Then a new logon may be required to re-authenticate the client and to reestablish session state. The performance impact of NLB can be measured in four areas: -CPU overhead required for analyzing and filtering the packets
-Response times to clients, which increases with the latency
-Throughput to clients, which increases with additional client traffic that the cluster can handle prior to saturating the hosts
-Switch occupancy As suggested above for NLB you need additional s/w which should be compatible with SQL clustering. May check SQL Server homepage for more information. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>