MSSQL查询CPU 平均占用率最高的前 50 个 SQL 语句。​

SELECT TOP 50

total_worker_time/execution_count/1000000 AS [Avg CPU Time],

(SELECT text FROM sys.dm_exec_sql_text(sql_handle)) AS query_text, *

FROM sys.dm_exec_query_stats 

ORDER BY [Avg CPU Time] DESC