SQL Server Performance

SQL Cluster and NLB

Discussion in 'SQL Server Clustering' started by fphan, Feb 19, 2004.

  1. fphan New Member

    HI
    I 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
  2. Luis Martin Moderator

  3. satya Moderator

  4. bradmcgehee New Member

    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
  5. satya Moderator

    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.
  6. satya Moderator

    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.

Share This Page