Time to Check Your Servers

Posted by fatherjack on Simple Talk See other posts from Simple Talk or by fatherjack
Published on Thu, 24 Nov 2011 08:20:00 GMT Indexed on 2011/11/24 18:09 UTC
Read the original article Hit count: 415

Filed under:
Do you know how to find the time that your SQL Server started? Since SQL Server 2008 you can use: SELECT sqlserver_start_timeFROM sys.dm_os_sys_info On one of my servers this gives me: This is great, and can be used in lots of ways. I happened across the [sys].[dm_exec_requests]view the other day and out of curiosity ran the query SELECT MIN(start_time) AS [start time]FROM [sys].[dm_exec_requests] AS der And I was surprised to see the result as: Almost exactly an hour different. Now as...(read more)

© Simple Talk or respective owner

Related posts about administration