3 incident(s) in the retained Extended Events buffer (sqm_BlockedProcessMonitor session, last 24h).
| Time | Wait | Database | Blocked SPID | Blocking SPID | Blocked Login | Blocking Login | Blocked Statement | Blocking Statement |
|---|---|---|---|---|---|---|---|---|
| 2026-07-19 08:41:12 | 72s | SalesDB | 112 | 87 | app_svc | etl_svc | UPDATE Orders SET Status = 'Shipped' WHERE OrderId = @id | MERGE Orders AS tgt USING #StageOrders AS src ON tgt.OrderId = src.OrderId ... |
| 2026-07-19 08:15:03 | 14s | SalesDB | 94 | 87 | app_svc | etl_svc | SELECT * FROM Orders WITH (UPDLOCK) WHERE CustomerId = @cid | MERGE Orders AS tgt USING #StageOrders AS src ON tgt.OrderId = src.OrderId ... |
| 2026-07-19 07:58:41 | 4s | ReportingDB | 63 | 58 | rpt_ro | rpt_etl | SELECT SUM(Amount) FROM FactSales WHERE PeriodId = @p | INSERT INTO FactSales SELECT * FROM #StageSales |
Severity thresholds: >= 60s critical, >= 10s warning, below that informational. Head-blocker statement is truncated to 200 characters in the report.