------------ Query the SQL Server service start time

Create Table # errorlog (logdate datetime, processinfo varchar (max), text nvarchar (max ))
Insert into # errorlog exec master .. xp_readerrorlog
Select logdate from # errorlog where text like '% SQL Server is starting %'
Drop table # errorlog

 

Select crdate time_restart, getdate () as time_now,
Datediff (MI, crdate, getdate () as minutes_since_restart,
@ Cpu_busy/15000.0 as minutes_cpu_busy,
@ Io_busy/15000.0 as minutes_io_busy,
@ Idle/15000.0 as minutes_idle,
(@ Cpu_busy + @ io_busy + @ idle)/15000.0 as minutes_since_restart2,
@ Connections as connections
From master.. sysdatabases
Where name = 'tempdb'

 

-- SQL Server 2008 special method
Select sqlserver_start_time, * From SYS. dm_ OS _sys_info

 

 

Today, I saw them asking this question in the group, and I knew the third one. The first two were perfect uncles who asked me to worship them here.