Search This Blog

Monday, March 7, 2011

SQL DBA - Look for blocking

SELECT tl.resource_type ,

tl.resource_database_id ,

tl.resource_associated_entity_id ,

tl.request_mode ,

tl.request_session_id ,

wt.blocking_session_id ,

wt.wait_type ,

wt.wait_duration_ms

FROM sys.dm_tran_locks AS tl

INNER JOIN sys.dm_os_waiting_tasks AS wt

ON tl.lock_owner_address = wt.resource_address

ORDER BY wait_duration_ms DESC ;

No comments: