Post reply

Cluster Question

  • April 11, 2014 at 11:23 pm

    #292270

    Windows 2008 cluster and windows 2008 r2 cluster

    SQL 2008

    For the above configuration, is there a way or query to find if the Cluster is active/active or active/passive or active/active/passive etc

    and how to find if it is a server reboot or cluster failover

    Summarizing..

    1.Find cluster configuration .A/P or A/A or A/A/P etc

    2.Is it server reboot or Cluster failover from one node to another or node restarted in same node

  • April 14, 2014 at 8:15 am

    #1705771

    Nobody ever came across this info? 🙁

  • April 14, 2014 at 9:42 am

    #1705799

    balasach82 (4/11/2014)

    Windows 2008 cluster and windows 2008 r2 cluster

    SQL 2008

    For the above configuration, is there a way or query to find if the Cluster is active/active or active/passive or active/active/passive etc

    and how to find if it is a server reboot or cluster failover

    Summarizing..

    1.Find cluster configuration .A/P or A/A or A/A/P etc

    2.Is it server reboot or Cluster failover from one node to another or node restarted in same node

    1. There is no direct way to do this.

    2. You need read the log file to distinguish it. Use xp_ReadErrorLog.

    --

    SQLBuddy

  • April 14, 2014 at 2:08 pm

    #1705921

    balasach82 (4/11/2014)

    Windows 2008 cluster and windows 2008 r2 cluster

    SQL 2008

    For the above configuration, is there a way or query to find if the Cluster is active/active or active/passive or active/active/passive etc

    and how to find if it is a server reboot or cluster failover

    Summarizing..

    1.Find cluster configuration .A/P or A/A or A/A/P etc

    You can track the active node for an instance using SELECT SERVERPROPERTY('ComputernamePhysicalNetbios').

    balasach82 (4/11/2014)

    2.Is it server reboot or Cluster failover from one node to another or node restarted in same node

    The easiest way to find out if a server reboot occurred, is to track the stopping and starting of the windows eventlog service through the windows system eventlog

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply