SQL语句：查看排名前五的SQL语句耗时情况
标签：
SQL语句：查看排名前五的SQL语句耗时情况
TOP 5
total_worker_time ,
last_worker_time ,
max_worker_time ,
min_worker_time ,
SUBSTRING(st.text, ( qs.statement_start_offset / 2 ) + 1,
( ( CASE statement_end_offset
WHEN -1 THEN DATALENGTH(st.text)
ELSE qs.statement_end_offset
END - qs.statement_start_offset ) / 2 ) + 1) AS statement_text
FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st
ORDER BY max_worker_time DESC