| WaitType | Category | WaitTimeSec | WaitTimePct | WaitingTasksCount | AvgWaitMs | MaxWaitMs | SignalWaitMs | SignalWaitPct | ResourceWaitMs | IsDelta | Recommendation |
|---|
| LCK_M_S | Locking | 118753.9 | 35 | 9138 | 12995.61 | 66027 | 4871 | 0 | 118749042 | False | Shared lock waits - consider enabling Read Committed Snapshot Isolation (RCSI). |
| SOS_SCHEDULER_YIELD | CPU | 51635.8 | 15.2 | 59881976 | 0.86 | 624 | 51600020 | 99.9 | 35736 | False | Inconspicuous: signal wait share of the instance is 19,1 %, below the 25 % threshold - no CPU pressure. |
| ASYNC_IO_COMPLETION | I/O | 24588.3 | 7.2 | 1231 | 19974.27 | 1641865 | 613 | 0 | 24587708 | False | Async I/O delay - Backup/Restore/DBCC running on slow storage. |
| BACKUPBUFFER | Other | 24314.4 | 7.2 | 12765181 | 1.90 | 316 | 3189841 | 13.1 | 21124549 | False | |
| ASYNC_NETWORK_IO | Network | 23800.1 | 7 | 9345088 | 2.55 | 6057 | 442349 | 1.9 | 23357755 | False | Inconspicuous: average wait 2,55 ms is below the 10 ms threshold - no action required. |
| CXPACKET | Parallelism | 20676.7 | 6.1 | 8803722 | 2.35 | 1881241 | 1324282 | 6.4 | 19352419 | False | Parallelism waits - tune MAXDOP and Cost Threshold for Parallelism. |
| BACKUPIO | Other | 17632.1 | 5.2 | 14753839 | 1.20 | 347 | 1177724 | 6.7 | 16454402 | False | |
| CXCONSUMER | Parallelism | 16419 | 4.8 | 7549086 | 2.17 | 34233 | 2424366 | 14.8 | 13994639 | False | Inconspicuous: only 4,8 % of the relevant wait time (threshold 5 %) - no action required. |
| BACKUPTHREAD | Other | 11300 | 3.3 | 41516 | 272.18 | 685219 | 8744 | 0.1 | 11291274 | False | |
| WRITELOG | I/O | 10928.6 | 3.2 | 12237786 | 0.89 | 2107 | 2112808 | 19.3 | 8815761 | False | Inconspicuous: average wait 0,89 ms is below the 5 ms threshold - no action required. |