----------------------------------查询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

 

 

今天在群里面看见他们问这个问题，我就知道第三种，前面两种是问的完美大叔，在这里膜拜一下。