When was my SQL Server / Instance last restarted

When you query usage statistics of your SQL server the data is only valid since the last time the server or instance had been restarted.  To know when this was you can run the following on SQL 2005+:

SELECT 'Statistics since: ' + CAST(sqlserver_start_time AS VARCHAR) FROM sys.dm_os_sys_info;

Comments

Popular Posts