本文提供了一段SQL查询代码，用于找出过去一天内CPU使用率最高的前50条查询语句。通过此查询，可以了解数据库中哪些查询消耗了最多的CPU资源。
SELECT
HIGHEST_CPU_QUERIES.PLAN_HANDLE,
HIGHEST_CPU_QUERIES.TOTAL_WORKER_TIME,
Q.DBID,
Q.OBJECTID,
Q.NUMBER,
Q.ENCRYPTED,
Q.[TEXT],max_WORKER_TIME,last_execution_time
FROM
(SELECT TOP 50
QS.PLAN_HANDLE,
QS.TOTAL_WORKER_TIME,
QS.execution_count,max_WORKER_TIME,last_execution_time
FROM
SYS.DM_EXEC_QUERY_STATS QS where datediff(d, last_execution_time,getdate())=0
ORDER BY QS.TOTAL_WORKER_TIME DESC) AS HIGHEST_CPU_QUERIES
CROSS APPLY SYS.DM_EXEC_SQL_TEXT(PLAN_HANDLE) AS Q
ORDER BY HIGHEST_CPU_QUERIES.TOTAL_WORKER_TIME DESC
扫一扫
789
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
