-- 查询编译以来 cpu 耗时总量最多的前 50 条 (Total_woker_time) 第一种查询
- select
- 'total_worker_time(ms)'=(total_worker_time/1000),
- q.[text], --DB_NAME(dbid),OBJECT_NAME(objectid),
- execution_count,
- 'max_worker_time(ms)'=(max_worker_time/1000),
- 'last_worker_time(ms)'=(last_worker_time/1000),
- 'min_worker_time(ms)'=(min_worker_time/1000),
- 'max_elapsed_time(ms)'=(max_elapsed_time/1000),
- 'min_elapsed_time(ms)'=(min_elapsed_time/1000),
- 'last_elapsed_time(ms)'=(last_elapsed_time/1000),
- total_physical_reads,
- last_physical_reads,
- min_physical_reads,
- max_physical_reads,
- total_logical_reads,
- last_logical_reads,
- max_logical_reads,
- creation_time,
- last_execution_time
- from
- (select top 50 qs.* from sys.dm_exec_query_stats qs order by qs.total_worker_time desc)
as highest_cpu_queries cross apply sys.dm_exec_sql_text(highest_cpu_queries.plan_handle) as q
order by highest_cpu_queries.total_worker_time DESC
来源: https://www.cnblogs.com/MrHSR/p/9340189.html