Methods to Check the last Reboot of SQL Servers and Windows
Being a DBA can be really a thankless job, when everything works fine no one bothers about DBA’s but when things go wrong every one tries to pass the blame on DBA.
One of the ideal case is when SQL Server restarts, sysadmin & DBA starts blaming each other for the restart.
Below are few ways you can check when was SQL Server restarted last time and why it was restarted.
Different ways to find SQL Server Last Restart Time
Right click on the server name in SSMS and select Reports > Standard Reports > Server Dashboard and you will get a report similar to below report.
start -> run -> eventvwr Chose Windows log -> Application
Open filter and enter Event Sources (MSSQLSERVER) and Event Id (17163)
Here is the output of above filter.
Different ways to find Windows last rebooted time.
Start Task Manager->Performance
Screen below gives you total up time since last restart.
This method helps you to figure out root cause for the restart. start -> run -> eventvwr Choose: Windows Log – > System
Open filter and following Event Id’s 6005 to see when the Event Log service was started. It gives the message “The Event log service was started”. 6006 to see when there was a clean shutdown. It gives the message “The Event log service was stopped”. 6008 to see when there was a dirty shutdown. It gives the message “The previous system shutdown at time on date was unexpected”. 6009 is logged during every boot.