Determine the Last Start Date for a SQL Server Instance

Timothy SQL, Syndicated, Tips and Tricks 3 Comments May 19, 2009

Today I had a friend on Facebook ask if I knew of a DMV or DMF that provided the date upon which the SQL Service was last started. What I use instead in any of my queries is the create date of the tempdb database. Why? Well simply put, tempdb is recreated each time the SQL Server service is started. Therefore, by querying sys.databases (or sys.sysdatabases) for the creation date of tempdb you can determine when the SQL Server service.

Either of the following queries work in SQL Server 2005 or 2008:

SQLAgentMan

Determine the Last Start Date for a SQL Server Instance

SELECT SD.[create_date] FROM sys.databases SD
WHERE SD.[name] = ‘tempdb’

SELECT SSD.[crdate] FROM sys.sysdatabases SSD
WHERE SSD.[name] = ‘tempdb’

Like this:

Determine the Last Start Date for a SQL Server Instance

SELECT SD.[create_date] FROM sys.databases SD WHERE SD.[name] = ‘tempdb’

SELECT SSD.[crdate] FROM sys.sysdatabases SSD WHERE SSD.[name] = ‘tempdb’

Share this:

Like this:

Profile cancel

SELECT SD.[create_date] FROM sys.databases SD
WHERE SD.[name] = ‘tempdb’

SELECT SSD.[crdate] FROM sys.sysdatabases SSD
WHERE SSD.[name] = ‘tempdb’