SQL Server Performance

3 active and 1 Passive Server Clustering

Discussion in 'SQL Server 2005 Clustering' started by sqlexpert, Oct 15, 2007.

  1. sqlexpert New Member

    Hi ,
    I am looking some information regarding scenario in SQL 2005 where project team wants 3 servers running as active and one extra server will work as passive or backup server so just wondering if that at all possible ? if yes any pointer will be great also just wondering if it is possible and two active nodes get down simulatenously then how it will be taken care of.
    Thanks...
  2. thomas New Member

    Yes it is possible. If 2 active nodes are down, you end up with 2 instances running on 1 node (which will be slower, but still better than complete downtime!).
  3. satya Moderator

    In this case you have to take action for such limited availability of nodes, moreover see whether application can work out or not.
  4. sqlexpert New Member

    Thanks Thomas and Sathya , also is there any special requirement or configuration i need to keep in mind for this type of clustering ? is there any supportive document link for this kind of scenerio?
    much appreciated.
  5. satya Moderator

Share This Page