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
今天在群里面看见他们问这个问题,我就知道第三种,前面两种是问的完美大叔,在这里膜拜一下。