| WaitType | Category | WaitTimeSec | WaitTimePct | WaitingTasksCount | AvgWaitMs | MaxWaitMs | SignalWaitMs | SignalWaitPct | ResourceWaitMs | IsDelta | Recommendation |
|---|
| BACKUPTHREAD | Other | 202998.8 | 29.7 | 63300 | 3206.93 | 194906560 | 1097 | 0 | 202997683 | False | |
| MSQL_XP | Other | 194951.4 | 28.5 | 10554 | 18471.81 | 194906762 | 0 | 0 | 194951434 | False | |
| BACKUPIO | Other | 194924.9 | 28.5 | 90212 | 2160.74 | 194906555 | 642 | 0 | 194924258 | False | |
| PREEMPTIVE_OS_FILEOPS | Other | 82402.7 | 12.1 | 49231 | 1673.80 | 82366748 | 0 | 0 | 82402733 | False | |
| CXCONSUMER | Parallelism | 7060 | 1 | 865 | 8161.79 | 587735 | 170 | 0 | 7059782 | False | Inconspicuous: only 1 % of the relevant wait time (threshold 5 %) - no action required. |
| LCK_M_U | Locking | 592.1 | 0.1 | 60 | 9868.72 | 587732 | 8 | 0 | 592115 | False | Update lock waits - optimize queries and improve index coverage. |
| CXSYNC_PORT | Parallelism | 588.4 | 0.1 | 187 | 3146.36 | 587731 | 7 | 0 | 588362 | False | Inconspicuous: only 0,1 % of the relevant wait time (threshold 5 %) - no action required. |
| WRITELOG | I/O | 71.3 | 0 | 32324 | 2.21 | 2784 | 1182 | 1.7 | 70121 | False | Inconspicuous: average wait 2,21 ms is below the 5 ms threshold - no action required. |
| PREEMPTIVE_OS_QUERYREGISTRY | Other | 67.8 | 0 | 917876 | 0.07 | 52 | 0 | 0 | 67817 | False | |
| PAGEIOLATCH_SH | I/O | 27 | 0 | 3024 | 8.92 | 2184 | 238 | 0.9 | 26731 | False | Inconspicuous: average wait 8,92 ms is below the 10 ms threshold - no action required. |
| LATCH_EX | Latch | 14.1 | 0 | 3063 | 4.61 | 77 | 202 | 1.4 | 13917 | False | Inconspicuous: average wait 4,61 ms is below the 10 ms threshold - no action required. |
| ASYNC_IO_COMPLETION | I/O | 8.6 | 0 | 332 | 25.81 | 866 | 32 | 0.4 | 8537 | False | Inconspicuous: average wait 25,81 ms is below the 1000 ms threshold - no action required. |
| XE_FILE_TARGET_TVF | Other | 8.3 | 0 | 336297 | 0.02 | 348 | 0 | 0 | 8289 | False | |
| ASYNC_NETWORK_IO | Network | 8.3 | 0 | 134979 | 0.06 | 111 | 1514 | 18.3 | 6772 | False | Inconspicuous: average wait 0,06 ms is below the 10 ms threshold - no action required. |
| PREEMPTIVE_OS_AUTHENTICATIONOPS | Other | 7.5 | 0 | 28218 | 0.27 | 11 | 0 | 0 | 7528 | False | |
| BACKUPBUFFER | Other | 7.2 | 0 | 10487 | 0.69 | 14 | 218 | 3 | 6968 | False | |
| PRINT_ROLLBACK_PROGRESS | Other | 6 | 0 | 2 | 3004.50 | 3008 | 0 | 0 | 6009 | False | |
| PREEMPTIVE_OS_GETFILEATTRIBUTES | Other | 3.5 | 0 | 68309 | 0.05 | 3 | 0 | 0 | 3471 | False | |
| PREEMPTIVE_OS_GETVOLUMEPATHNAME | Other | 3.3 | 0 | 5740 | 0.58 | 2 | 0 | 0 | 3322 | False | |
| PAGELATCH_EX | Latch | 1.9 | 0 | 103250 | 0.02 | 78 | 573 | 29.5 | 1371 | False | Inconspicuous: average wait 0,02 ms is below the 5 ms threshold - no action required. |
| COLUMNSTORE_BUILD_THROTTLE | Other | 1.9 | 0 | 2 | 938.00 | 946 | 0 | 0 | 1876 | False | |
| LCK_M_S | Locking | 1.5 | 0 | 38 | 39.79 | 292 | 3 | 0.2 | 1509 | False | Inconspicuous: average wait 39,79 ms is below the 500 ms threshold - no action required. |
| SOS_SCHEDULER_YIELD | CPU | 1.5 | 0 | 61966 | 0.02 | 225 | 1438 | 95.4 | 69 | False | Inconspicuous: signal wait share of the instance is 0 %, below the 25 % threshold - no CPU pressure. |
| PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT | Other | 1.4 | 0 | 11468 | 0.12 | 3 | 0 | 0 | 1422 | False | |
| PAGEIOLATCH_UP | I/O | 1.3 | 0 | 11986 | 0.11 | 13 | 26 | 2 | 1294 | False | Inconspicuous: average wait 0,11 ms is below the 10 ms threshold - no action required. |