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

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

  • Comments 1

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

Leave a Comment
  • Please add 6 and 2 and type the answer here:
  • Post