check-live-blocking
Use when queries hang right now: who is blocking, the head blocker, why a blocking DMV looks empty. Has tested queries and rules common answers miss, e.g. a sleeping head blocker is absent from sys.dm_exec_requests. For past blocking, use read-only blocking root-cause investigation using the host SQL tools.
Pinned to revision 3224561abf68, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/check-live-blocking/SKILL.md
- skills/check-live-blocking/references/azure-sql/guidance.md
- skills/check-live-blocking/references/azure-sql/references/blocking-visibility-and-deadlock-graphs.md
- skills/check-live-blocking/references/incident-evidence.md
Every link opens the file at its source, pinned to the revision this page describes.