| WaitType | Category | WaitTimeSec | WaitTimePct | WaitingTasksCount | AvgWaitMs | MaxWaitMs | SignalWaitMs | SignalWaitPct | ResourceWaitMs | IsDelta | Recommendation |
|---|
| PREEMPTIVE_OS_QUERYREGISTRY | Other | 68,5 | 38 | 650963 | 0,11 | 19 | 0 | 0 | 68453 | False | |
| WRITELOG | I/O | 27,4 | 15,2 | 7355 | 3,73 | 2836 | 253 | 0,9 | 27184 | False | Inconspicuous: average wait 3,73 ms is below the 5 ms threshold - no action required. |
| MSQL_XP | Other | 20 | 11,1 | 19338 | 1,03 | 197 | 0 | 0 | 19973 | False | |
| BACKUPIO | Other | 8 | 4,4 | 12147 | 0,66 | 12 | 52 | 0,7 | 7912 | False | |
| BACKUPTHREAD | Other | 7,4 | 4,1 | 1368 | 5,44 | 305 | 33 | 0,4 | 7404 | False | |
| ASYNC_NETWORK_IO | Network | 6,7 | 3,7 | 98881 | 0,07 | 43 | 1170 | 17,5 | 5530 | False | Inconspicuous: average wait 0,07 ms is below the 10 ms threshold - no action required. |
| ASYNC_IO_COMPLETION | I/O | 5,6 | 3,1 | 133 | 42,05 | 1462 | 3 | 0,1 | 5589 | False | Inconspicuous: average wait 42,05 ms is below the 1000 ms threshold - no action required. |
| PREEMPTIVE_OS_FILEOPS | Other | 4,7 | 2,6 | 5126 | 0,91 | 10 | 0 | 0 | 4657 | False | |
| PREEMPTIVE_OS_AUTHENTICATIONOPS | Other | 4,2 | 2,3 | 11319 | 0,37 | 13 | 0 | 0 | 4182 | False | |
| PREEMPTIVE_OS_WRITEFILEGATHER | Other | 3,9 | 2,2 | 127 | 30,96 | 223 | 0 | 0 | 3932 | False | |
| PREEMPTIVE_OS_LOADLIBRARY | Other | 3,4 | 1,9 | 34 | 100,32 | 217 | 0 | 0 | 3411 | False | |
| PRINT_ROLLBACK_PROGRESS | Other | 3 | 1,7 | 1 | 3015,00 | 3015 | 0 | 0 | 3015 | False | |
| PAGEIOLATCH_SH | I/O | 2,1 | 1,1 | 4256 | 0,49 | 4 | 35 | 1,7 | 2033 | False | Inconspicuous: average wait 0,49 ms is below the 10 ms threshold - no action required. |
| LCK_M_S | Locking | 1,6 | 0,9 | 75 | 20,87 | 337 | 2 | 0,1 | 1563 | False | Inconspicuous: average wait 20,87 ms is below the 500 ms threshold - no action required. |
| SOS_SCHEDULER_YIELD | CPU | 1,5 | 0,8 | 52300 | 0,03 | 11 | 1427 | 95,7 | 64 | False | Inconspicuous: signal wait share of the instance is 1,7 %, below the 25 % threshold - no CPU pressure. |
| PREEMPTIVE_OS_CRYPTACQUIRECONTEXT | Other | 1,2 | 0,7 | 2551 | 0,48 | 0 | 0 | 0 | 1220 | False | |
| BACKUPBUFFER | Other | 1,1 | 0,6 | 1202 | 0,93 | 11 | 23 | 2,1 | 1089 | False | |
| IO_COMPLETION | I/O | 1,1 | 0,6 | 1912 | 0,57 | 3 | 4 | 0,4 | 1090 | False | Inconspicuous: average wait 0,57 ms is below the 10 ms threshold - no action required. |
| PREEMPTIVE_OS_CREATEFILE | Other | 1 | 0,6 | 1806 | 0,55 | 48 | 0 | 0 | 1001 | False | |
| PREEMPTIVE_OS_WRITEFILE | Other | 1 | 0,5 | 13458 | 0,07 | 14 | 0 | 0 | 986 | False | |
| PREEMPTIVE_OS_VERIFYTRUST | Other | 0,9 | 0,5 | 24 | 38,17 | 68 | 0 | 0 | 916 | False | |
| PREEMPTIVE_OS_CRYPTOPS | Other | 0,8 | 0,5 | 6918 | 0,12 | 479 | 0 | 0 | 826 | False | |
| WAIT_ON_SYNC_STATISTICS_REFRESH | Other | 0,6 | 0,3 | 269 | 2,32 | 11 | 0 | 0 | 624 | False | |
| PREEMPTIVE_OS_AUTHORIZATIONOPS | Other | 0,6 | 0,3 | 3963 | 0,15 | 1 | 0 | 0 | 609 | False | |
| SLEEP_PHYSMASTERDBREADY | Other | 0,6 | 0,3 | 1 | 590,00 | 590 | 0 | 0 | 590 | False | |