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.

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:

Share this item with your network: