November 29, 2015 at 10:25 am
Hello Experts
Can you please tell me how to find the exact time cluster took to failover to another node from existing?
What are the typical places other than eventviewer I can check to get the time recorded? Does cluster.log file help?
Please suggest.
Thanks in advance!!!
Thanks.
November 29, 2015 at 1:04 pm
You could create a database job that executes when SQL Server starts up. Create a step to fire a procedure, which could record the current date and time, send you an email or do whatever else you wanted to record the event.
November 30, 2015 at 5:18 am
SQL-DBA-01 (11/29/2015)
Hello ExpertsCan you please tell me how to find the exact time cluster took to failover to another node from existing?
What are the typical places other than eventviewer I can check to get the time recorded? Does cluster.log file help?
Please suggest.
Thanks in advance!!!
In Windows 2008 above the cluster.log does not exist, it can be created for support purposes with a static dump of the cluster events.
To monitor cluster events use the Applications and services logs viewer within the Event viewer console.
Event id 1201 for a cluster role coming online, event id 1204 for a role going offline.
This link has further info
https://technet.microsoft.com/en-gb/library/cc772342.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply