Post reply

Blocked

  • July 19, 2013 at 4:48 am

    #275432

    Hi,

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

  • July 19, 2013 at 5:00 am

    #1633931

    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’! **

  • July 19, 2013 at 5:06 am

    #1633933

    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’! **

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply