| generated_at | 2026-10-07T15:17:15 |
|---|---|
| trend_window_days | 7 |
| collected_at | 2026-10-07T15:15:52 |
| total_wait_types | 33 |
| total_waiting_tasks | 226515 |
| total_wait_time_ms | 6647 |
| total_signal_wait_ms | 680 |
| total_resource_wait_ms | 5969 |
| max_single_wait_ms | 975802 |
| signal_wait_percent | 10.23 |
| resource_wait_percent | 89.77 |
| profile | Wait Statistics Analysis |
|---|---|
| primary_bottleneck | PARALLELISM |
| priority | P2 |
| risk | MEDIUM |
| confidence | low |
| evidence_gaps | Query context, Plan XML, Plan insights |
| reason | Server-level wait analysis was selected using wait summary and trend evidence; query-level correlation is not attached. Deterministic bottleneck: PARALLELISM. |
| Category | Wait Time (ms) |
|---|---|
| CPU | 5441 |
| I/O | 387 |
| Lock | 11 |
| Latch | 163 |
| Memory | 372 |
| Network | 89 |
| Buffer | 0 |
| CLR | 0 |
| Other | 184 |
| Wait Type | Category | Wait Time (ms) | Wait Percent | Cumulative Percent | Waiting Tasks | Signal Wait (ms) | Resource Wait (ms) |
|---|---|---|---|---|---|---|---|
| CXPACKET | CPU | 4385 | 65.97 | 65.97 | 11240 | 267 | 4118 |
| CXCONSUMER | CPU | 760 | 11.43 | 77.4 | 713 | 36 | 724 |
| RESERVED_MEMORY_ALLOCATION_EXT | Memory | 369 | 5.55 | 82.95 | 206033 | 0 | 369 |
| SOS_SCHEDULER_YIELD | CPU | 296 | 4.45 | 87.41 | 6912 | 281 | 15 |
| WRITELOG | I/O | 287 | 4.32 | 91.73 | 405 | 50 | 237 |
| LATCH_EX | Latch | 143 | 2.15 | 93.88 | 30 | 2 | 141 |
| ASYNC_NETWORK_IO | Network | 89 | 1.34 | 95.22 | 534 | 11 | 78 |
| HTDELETE | Other | 80 | 1.2 | 96.42 | 56 | 1 | 79 |
| PAGEIOLATCH_SH | I/O | 77 | 1.16 | 97.58 | 196 | 6 | 71 |
| HTBUILD | Other | 56 | 0.84 | 98.42 | 42 | 1 | 55 |
| Title | Confidence | Dominant Category | Recommendation |
|---|---|---|---|
| CPU Pressure | 0.95 | CPU | Review runnable queue, high-CPU queries, and parallelism settings. |
| I/O Bottleneck | 0.3 | I/O | Validate storage latency, file layout, and heavy read/write query patterns. |
| Latch Contention | 0.3 | Latch | Check hot pages (TempDB/object allocation) and reduce page-level contention. |
| Network Throughput Pressure | 0.3 | Network | Inspect client fetch behavior, packet latency, and large result-set consumers. |
| Date | Total Wait (ms) | Dominant Category | Dominant Wait (ms) |
|---|---|---|---|
| 2026-09-30 | 110 | CPU | 107 |
| 2026-10-01 | 186467 | CPU | 122933 |
| 2026-10-02 | 721036 | CPU | 530871 |
| 2026-10-03 | 749473 | CPU | 524106 |
| 2026-10-04 | 1601592 | Lock | 709027 |
| 2026-10-05 | 809218 | CPU | 595965 |
| 2026-10-06 | 677937 | CPU | 502627 |
| 2026-10-07 | 1545416 | CPU | 685593 |
| baseline_available | False |
|---|---|
| baseline_captured_at | None |
| baseline_age_hours | 0.0 |
| delta_total_wait_ms | 0 |
| delta_signal_wait_percent | 0.0 |
| delta_resource_wait_percent | 0.0 |
| status | no-baseline |
| summary | No baseline configured. |
| before_available | False |
|---|---|
| after_available | False |
| before_captured_at | None |
| after_captured_at | None |
| delta_total_wait_ms | 0 |
| delta_signal_wait_percent | 0.0 |
| delta_resource_wait_percent | 0.0 |
| status | insufficient-data |
| summary | Capture both BEFORE and AFTER snapshots to compare change impact. |
| summary | No active blocking chains. |
|---|---|
| chain_count | 0 |
| total_blocked_sessions | 0 |
| total_blocking_sessions | 0 |
| max_chain_depth | 0 |
| root_blockers |
| total_wait_time_ms | 2000000 |
|---|---|
| total_wait_rate_ms_per_second | 1000.0 |
| lock_wait_percent | 15.0 |
| io_wait_percent | 30.0 |
| blocked_sessions | 3 |
| chain_depth | 3 |
| single_wait_ms | 60000 |
| alert_cooldown_minutes | 15 |
| query_id | 0 |
|---|---|
| plan_available | False |
| dominant_wait_categories | |
| confidence | 0.0 |
| plan_summary |
{"database_name": "", "application_name": "", "time_window_days": 7, "min_wait_time_ms": 0}