查询目前运行状态-CPU等情况

时间:2014-08-18 14:25:42   收藏:0   阅读:297

对目前的数据库的运行状况有一个基本的了解

 

SELECT TOP ( 10 )
DB_NAME(a.dbid) AS dbname ,
loginame ,
spid ,
cpu ,
b.text ,
lastwaittype ,
waitresource ,
a.[status] ,
hostname AS WebServer ,
[program_name] AS AppName ,
[cmd] ,
cpu AS Type
--into #cpu
FROM master..sysprocesses AS a
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS b
INNER JOIN master..sysdatabases AS c ON a.dbid = c.dbid
AND a.status <> sleeping --and a.blocked>0 
ORDER BY cpu DESC

 

查询目前运行状态-CPU等情况,布布扣,bubuko.com

原文:http://www.cnblogs.com/dingqin0525/p/3919401.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!