Viewing and Interpreting Blocking Chains in SQL Monitor
Blocking is like a traffic pileup: when it occurs, it's helpful to find the "lead blocker" and then step through the chain of who blocked who. In this video we step through an example blocking chain and give tips on how to find useful information in SQL Monitor.
In this video:
00:00 Navigating directly to blocking processes
00:45 Viewing the head blocker
01:18 Getting more information from the query plan for the lead blocker
02:50 Stepping through who is blocking who in the chain
03:35 What to think about when resolving blocking situations (instead of NOLOCK)