View Blocking Transactions

You can identify blocking transactions by querying the sys.dm_tran_locks dynamic management view.

SELECT * FROM sys.dm_tran_locks WHERE request_session_id IN 
(SELECT session_id FROM sys.dm_exec_requests WHERE blocking_session_id <> 0);