Blocked

Question

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

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

HanShi SSC-Dedicated Points: 33510 More actions · Answer 1

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

HanShi SSC-Dedicated Points: 33510 More actions · Answer 2

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

Cookies on SQLServerCentral