SELECT TOP 50
execution_count [执行次数] ,
total_elapsed_time / 1000 [总耗时(ms)] ,
( total_elapsed_time / execution_count ) / 1000 [平均耗时(ms)] ,
total_worker_time / 1000 [总消耗CPU 时间(ms)] ,
qs.total_worker_time / qs.execution_count / 1000 [平均消耗CPU 时间(ms)] ,
creation_time [首次编译时间] ,
last_execution_time [最后一次执行时间] ,
max_worker_time / 1000 [最大执行时间(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) [执行语句] ,
qt.text [完整语句] ,
total_logical_reads [逻辑读总数] ,
total_logical_reads / execution_count [每次逻辑读次数] ,
dbname = DB_NAME(qt.dbid)
FROM sys.dm_exec_query_stats qs WITH ( NOLOCK )
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt
WHERE execution_count > 1
ORDER BY [执行次数] DESC
sql server 执行效率分析
最新推荐文章于 2023-07-20 09:47:38 发布