MARQUIE DATA SYSTEMS

Free diagnostic · runs in your browser

Blocking-chain explainer

Paste a live blocking snapshot. See the head blocker and who waits on whom — with waits, logins, and a SQL snippet. Point-in-time only. No email. Nothing uploaded.

1. Run this read-only query

Needs VIEW SERVER STATE (≤2019) or VIEW SERVER PERFORMANCE STATE (2022+). Capture while blocking is active. SSMS: Copy with Headers → paste below.

  

Diagnostic aid only — point-in-time snapshot. Idle lock holders may not appear if they have no request row. Processed entirely in your browser; nothing is uploaded.