27,579
社区成员
发帖
与我相关
我的任务
分享
SELECT TOP 10
DB_NAME(qp.dbid) AS dbname ,
SUM(qs.total_worker_time) AS total_cpu_time ,
SUM(qs.execution_count) AS total_execution_count ,
COUNT(*) AS number_of_statements ,
qt.text ,
qs.sql_handle
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) AS qp
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS qt
INNER JOIN sys.dm_exec_requests AS rq ON rq.sql_handle=qs.sql_handle
INNER JOIN master.sys.sysprocesses AS pc ON pc.spid=rq.session_id
--WHERE last_execution_time between @dtBeginDate and @dtEndDate
GROUP BY qt.text ,
DB_NAME(qp.dbid) ,
qs.sql_handle
ORDER BY SUM(qs.total_worker_time) DESC;