SQL Server Performance

Best Practices question with two node clustering

Discussion in 'SQL Server 2005 Clustering' started by Derrick, Nov 30, 2007.

  1. Derrick New Member

    On an article on this site, 'SQL Server 2005 Clustering Best Practices' the first Best Practice noted was "A two-node Active/Passive configuration is preferred over an Active/Active configuration"
    Can anyone elaborate on this? We are currently standing up our first cluster on two ia64 boxes with four databases on the cluster. My first reaction was to split this into two seperate instances and create an active /active cluster. Is this not the best approach?
    Thank you,
    Derrick
    Derrick, Nov 30, 2007
    #2

  2. satya Moderator

    Welcome to the forum!
    What kind of high availability option you want to have, is your application needs to such load balancing of having active/active, think about cost on setting up ACTIVE/ACTIVE than ACTIVE/PASSIVE.
    General recommendation is AP is best suited for any applicaiton, unless any special requirement you cna go to AA setup.
    satya, Dec 4, 2007
    #3

Share This Page