Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Intermediate
Mar 15, 2018

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


Finding All Currently Blocked Requests in SQL

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
Hannes du Preez
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

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