SQL Server Performance

SQL Server cluster Failover History.

Discussion in 'SQL Server 2005 Clustering' started by gangulyarindam, Jun 21, 2007.

  1. Hi,

    I am currently working in a 2 - Node Active/Passive Cluster where we have 8 instances. More surprisingly, both the nodes are having only 3.75 GB RAM (with AWE option disabled). I have seen that this Cluster has a propensity to fail over for a Number of time.

    To establish the basic reason behind such failover I do need to find out the Number of time that the Failover occured on the Cluster.

    Is there any Script (even a VB/Winshell Script) that will be able to find out the history details of such event occurence.

    Eagerly waiting for a solution.

    Arindam Ganguly
  2. techbabu303 New Member

Share This Page