March 15, 2018

Here is a quick way to find all currently blocked requests in SQL: SELECTSESSION_ID,STATUS,BLOCKING_SESSION_ID,WAIT_TYPE,WAIT_TIME,WAIT_RESOURCE,TRANSACTION_IDFROM sys.dm_exec_requestsWHERE STATUS = N’suspended’;GO