SQL Server cluster Failover History. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server cluster Failover History.

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
Hi If you are looking for logs on failover please go over this intresting link.IAm not sure this applies to SQL server 2005 but worth a try. http://msdn2.microsoft.com/en-us/library/aa196696(sql.80).aspx http://www.sql-server-performance.com/bm_clustering_best_practices.asp Cheers