SQL Server Performance


Discussion in 'SQL Server 2005 Clustering' started by Rabani, Oct 21, 2008.

  1. Rabani New Member

    Can somebody please, let me know that how do we know exactly that a server has failed over to the secondary node. Also what does that effect the primary. Actually I am quite new in working in the clustered envirnoment.
    Thanks a lot
  2. Saurabh Srivastava New Member

  3. Elisabeth Redei New Member

    I guess it depends on how automated you want this to be but there should be messages in the eventlog indicating that the SQL Server service was shutdown on one of the nodes and another that it was started on the other node.
    Another way would be to start Cluster Administrator and look which node it is running, yet another to query the registry directly.

Share This Page