select top 5
(total_logical_reads/execution_count) as avg_logical_reads,
(total_logical_writes/execution_count) as avg_logical_writes,
(total_physical_reads/execution_count) as avg_phys_reads,
Execution_count,
statement_start_offset as stmt_start_offset,
sql_handle,
plan_handle
from sys.dm_exec_query_stats
order by (total_logical_reads + total_logical_writes) Desc
阻塞
運行下面的查詢可確定阻塞的會話。
view plaincopy to clipboardprint?
select blocking_session_id, wait_duration_ms, session_id from
sys.dm_os_waiting_tasks
where blocking_session_id is not null
select blocking_session_id, wait_duration_ms, session_id from
sys.dm_os_waiting_tasks
where blocking_session_id is not null
使用此調用可找出 blocking_session_id 所返回的 SQL。例如，如果 blocking_session_id 是 87，則運行此查詢可獲得相應的 SQL。
view plaincopy to clipboardprint?
文章來源于領測軟件測試網 http://www.kjueaiud.com/
