check_block.txt
| 1 |
SELECT |
|---|---|
| 2 |
R.session_id |
| 3 |
,DB_NAME(R.database_id) AS DatabaseName |
| 4 |
,S.original_login_name AS LoginName |
| 5 |
,S.host_name AS ClientMachine |
| 6 |
,S.program_name AS ApplicationName |
| 7 |
,R.start_time AS RequestStartTime |
| 8 |
,ST.text AS SQLQuery |
| 9 |
,QP.query_plan AS ExecutionPlan |
| 10 |
,R.cpu_time AS CPUTime |
| 11 |
,R.total_elapsed_time AS TotalTimeElapsed |
| 12 |
,R.open_transaction_count AS TotalTransactionsOpened |
| 13 |
,R.reads |
| 14 |
,R.logical_reads |
| 15 |
,R.writes AS TotalWrites |
| 16 |
,CASE |
| 17 |
WHEN R.wait_type IS NULL THEN 'Request Not Blocked' |
| 18 |
ELSE 'Request Blocked' |
| 19 |
END AS QueryBlockInfo |
| 20 |
,blocking_session_id AS RequestBlockedBy |
| 21 |
FROM sys.dm_exec_requests AS R |
| 22 |
INNER JOIN sys.dm_exec_sessions AS S |
| 23 |
ON R.session_id = S.session_id |
| 24 |
CROSS APPLY sys.dm_exec_sql_text(R.sql_handle) AS ST |
| 25 |
CROSS APPLY sys.dm_exec_query_plan (R.plan_handle) AS QP |
| 26 |
ORDER BY TotalTimeElapsed DESC |