dcsimg
 

Submitted by: Hannes du Preez(ojdupreez1978@gmail.com)

Thursday Mar 15th 2018 by Hannes du Preez

Language: SQL, Expertise: Intermediate - Check out this quick way to find 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
Home
Mobile Site | Full Site
Copyright 2018 © QuinStreet Inc. All Rights Reserved