Events captured: 214 | Issues detected: 3
| Category | Problem | Severity | Detail |
|---|---|---|---|
| Waits | High CXPACKET accumulation | Warning | 38% of total wait time over the capture window - review MAXDOP / cost threshold for parallelism. |
| Blocking | Lock escalation on Orders | Warning | Row-to-table escalation observed 6 times in 5 minutes during the nightly ETL_DailyLoad job. |
| Slow Queries | Missing index on Orders.CustomerId | Critical | Statement completed in 4.2s doing a full scan of 2.1M rows. |