Blocking Queries

When blocking or deadlocks are encountered, the list of what is blocking and what is being blocked will show up on the Blocking Queries Page.  This is useful for tracking down blocking issues.

Blocking

The number in the Blocked By column is the spid of the query that is causing the block.

Under normal circumstances you should have little or no blocking. If you have blocking, you should investigate why blocking is occurring in order to improve performance.

 

See Also:


Enroll Today!
SteveStedman5
SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!

Leave a Reply

Your email address will not be published. Required fields are marked *

*

To prove you are not a robot: *