Technical FAQs

Ask a Question

How to find when SQL Server (service/instance) was last restarted

Issue
When troubleshooting database issues, gathering some basic information can be very helpful in leading to the resolution or to identifying the cause of problems.

Product Line
SQL Server 2005, SQL Server 2008 R2, SQL Server 2012

Environment
Struxureware Power Monitoring
Power Monitoring Expert
ION Enterprise
ION EEM

Cause
Database maintenance and troubleshooting possible database issues.

Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*

Listed below are three methods to find the last time SQL Server server/service was restarted.

Method 1
The first method uses the fact that 'tempdb' will be recreated with every restart. We can check the created date (crdate) from master..sysdatabases.
SELECT crdate FROM master..sysdatabases WHERE name ='tempdb'

Method 2
The second method checks the master..sysprocesses database and check for the minimum value in the 'login_time' column.
SELECT MIN(login_time) FROM master..sysprocesses

Method 3
Examine the Windows Event Viewer and search for the most recent event indicating that the SQL server service was started.
Was this helpful?
What can we do to improve the information ?