———————————-查詢SQL SERVER 服務啟動時間

 

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 專用方法
select sqlserver_start_time,* from sys.dm_os_sys_info

 

 

今天在群裡面看見他們問這個問題，我就知道第三種，前面兩種是問的完美大叔，在這裡膜拜一下。