SQL 2008: A new method for finding the SQL instance start time


There are several methods you could use in SQL Server 2005 to determine when the SQL Server instance started up - however SQL Server 2008 introduces a quick and direct method by querying the sqlserver_start_time column from the sys.dm_os_sys_info DMV (example below):


SELECT sqlserver_start_time
FROM sys.dm_os_sys_info


Skip to main content