dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Finding All Currently Blocked Requests in SQL

Check out this quick way to find all currently blocked requests in SQL.


advertisement

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

 

Visit the DevX Tip Bank

 



   
Thanks for your registration, follow us on our social networks to keep up-to-date