SQL'i en çok yoran sorgular

select top 100 substring
(
    b.text, (a.statement_start_offset/2) + 1,
    (
        (
            case statement_end_offset when -1 then datalength(b.text) else a.statement_end_offset end - a.statement_start_offset
        ) / 2
    ) + 1
) as statement_text,
c.query_plan,total_worker_time as cpu_time,execution_count,total_physical_reads,total_logical_reads,total_elapsed_time,last_elapsed_time,max_elapsed_time,min_elapsed_time
from sys.dm_exec_query_stats a
cross apply sys.dm_exec_sql_text (a.sql_handle) as b
cross apply sys.dm_exec_query_plan (a.plan_handle) as c
order by total_worker_time desc