ShowBlocks

Table of Contents



Shows which process is blocking each blocked process, optionally for a single process.

ShowBlocks(Numeric processId = null)

Permissions

Requires an account that is a member of an administrator role.


Process Id and Blocked By.

round-pushpin Shows all blocks.
EXEC ShowBlocks

round-pushpin Shows the blocks for process 1.
EXEC ShowBlocks(1)