T-SQL系列之查看各个数据库性能负载(MSSQL)

-- 查看各个数据库性能负载SELECTsubstring (a.name,0,20) as [数据库名],[连接数] = (SELECT COUNT(*)FROM master..sysprocesses bWHEREa.dbid = b.dbid),[阻塞进程] = (SELECT COUNT(*)FROM master..sysprocesses bWHEREa.dbid = b.dbid ANDblocked <> 0),[总内存] = ISNULL((SELECT SUM(memusage)FROMmaster..sysprocesses bWHEREa.dbid = b.dbid),0),[总IO] = ISNULL((SELECT SUM(physical_io)FROMmaster..sysprocesses bWHEREa.dbid = b.dbid),0),[总CPU] = ISNULL((SELECT SUM(cpu)FROMmaster..sysprocesses bWHEREa.dbid = b.dbid),0),[总等待时间] = ISNULL((SELECT SUM(waittime)FROMmaster..sysprocesses bWHEREa.dbid = b.dbid),0)FROM master.dbo.sysdatabases a WITH (nolock)WHERE DatabasePropertyEx(a.name,'Status') = 'ONLINE'ORDER BY [数据库名]go