The Multifunctioning DBA

May 26 2011   11:00PM GMT

SQL Server Clustering time on Node

Colin Smith Colin Smith Profile: Colin Smith

I was asked to find out when the last time my sql server instance had failed over on the cluster. I thought mm I should be able to get this from a dmv or something but I could not find out how. Looked at the cluster dmv’s and just did not find what I am looking for. Threw the question out on #sqlhelp and I got two answers and they are both simple and I did not even think of them. I was trying to hard to figure it out and did not think to look at the simple things. @sqlpoolboy had both answers for me.

1. Check the created date of Tempdb – So simple and it makes so much sense. Since tempdb is re-created everytime the instance starts that would tell me when.

2. Since I am running SQL Server 2008 he provided this query for me as well.

SELECT sqlserver_start_time FROM sys.dm_os_sys_info

Both are pretty simple but I never would have thought of option 2 but I am kicking myself for not getting option 1.

Thanks again

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: