Wait Statistics - SQLPROD01

Erstellt: 2026-11-11 08:23:13 - Zeigerposition auf WaitType fuer Erklaerung
Quelle: www.powershelldba.de | sqmSQLTool v1.9.224.0
WaitTypeCategoryWaitTimeSecWaitTimePctWaitingTasksCountAvgWaitMsMaxWaitMsSignalWaitMsSignalWaitPctResourceWaitMsIsDeltaRecommendation
LCK_M_SLocking118753.935913812995.616602748710118749042FalseShared lock waits - consider enabling Read Committed Snapshot Isolation (RCSI).
SOS_SCHEDULER_YIELDCPU51635.815.2598819760.866245160002099.935736FalseInconspicuous: signal wait share of the instance is 19,1 %, below the 25 % threshold - no CPU pressure.
ASYNC_IO_COMPLETIONI/O24588.37.2123119974.271641865613024587708FalseAsync I/O delay - Backup/Restore/DBCC running on slow storage.
BACKUPBUFFEROther24314.47.2127651811.90316318984113.121124549False
ASYNC_NETWORK_IONetwork23800.1793450882.5560574423491.923357755FalseInconspicuous: average wait 2,55 ms is below the 10 ms threshold - no action required.
CXPACKETParallelism20676.76.188037222.35188124113242826.419352419FalseParallelism waits - tune MAXDOP and Cost Threshold for Parallelism.
BACKUPIOOther17632.15.2147538391.2034711777246.716454402False
CXCONSUMERParallelism164194.875490862.1734233242436614.813994639FalseInconspicuous: only 4,8 % of the relevant wait time (threshold 5 %) - no action required.
BACKUPTHREADOther113003.341516272.1868521987440.111291274False
WRITELOGI/O10928.63.2122377860.892107211280819.38815761FalseInconspicuous: average wait 0,89 ms is below the 5 ms threshold - no action required.