Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Blocked Expand / Collapse
Author
Message
Posted Friday, July 19, 2013 4:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, September 15, 2013 10:58 PM
Points: 17, Visits: 49
Hi,

How to find out the total number of all blocked sessions by using T-SQL Statement

Post #1475372
Posted Friday, July 19, 2013 5:00 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 2,482, Visits: 3,025
select count(*) as blocked_actions
from master..sysprocesses
where blocked <> 0



** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1475375
Posted Friday, July 19, 2013 5:06 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 2,482, Visits: 3,025
Or to make use of the DMV's:
select count(*)
from sys.dm_exec_requests
where blocking_session_id <> 0



** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1475377
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse