SQL Server Performance

a/a and active/passive

Discussion in 'SQL Server 2005 Clustering' started by kumar99ms, Jul 18, 2008.

  1. kumar99ms New Member

    Hi Every body
    What are the differences between active/active and active/passive
  2. melvinlusk Member

    Hi Kumar:
    In an Active/Passive cluster, all of your databases reside on just one of the cluster nodes. The other node is there simply for redundancy...so if the primary node fails, the other server will take control of it's databases.
    In Active/Active, both nodes have live databases on them, and if one fails, the other will take control of the failed servers databases.
  3. ashish287 New Member

    Further to add... we should consider the server hardware configuration fact while configuring the A-A cluster. Because once there will be failure, the single server have to load balance both the instance of sql server
  4. satya Moderator

    One thing you need to make sure that Clustering is not for load balancing - http://sqlserver-qa.net/blogs/perftune/archive/2008/02/29/3576.aspx fyi.

Share This Page