Here is a quick way to find all currently blocked requests in SQL:
SELECT SESSION_ID, STATUS, BLOCKING_SESSION_ID, WAIT_TYPE, WAIT_TIME, WAIT_RESOURCE, TRANSACTION_ID FROM sys.dm_exec_requests WHERE STATUS = N'suspended'; GO
