SELECT TOP 30
total_worker_time/1000 AS [CPU總耗時(ms)], 
execution_count [運行次數(shù)], 
qs.total_worker_time/qs.execution_count/1000 AS [CPU平均耗時(ms)], 
last_execution_time AS [最后執(zhí)行時間], 
max_worker_time/1000 AS [最大執(zhí)行耗時(ms)], 
SUBSTRING(qt.text,qs.statement_start_offset/2+1, 
 (CASE WHEN qs.statement_end_offset = -1 
 THEN DATALENGTH(qt.text) 
 ELSE qs.statement_end_offset 
 END -qs.statement_start_offset)/2 + 1) AS [SQL語句]
FROM sys.dm_exec_query_stats qs WITH(nolock)
CROSS apply sys.dm_exec_sql_text(qs.sql_handle) AS qt
WHERE execution_count > 1
ORDER BY max_worker_time DESC