-
Notifications
You must be signed in to change notification settings - Fork 26
BenignWaits
fatherjack edited this page Oct 1, 2017
·
5 revisions
These are the waits that are not included in the OQS Wait Statistics Dashboard report. They are considered to be benign - relating to background processes that are not related to situations of poor performance.
- BROKER_EVENTHANDLER
- BROKER_RECEIVE_WAITFOR
- BROKER_TASK_STOP
- BROKER_TO_FLUSH
- BROKER_TRANSMITTER
- CHECKPOINT_QUEUECHKPT
- CLR_AUTO_EVENT
- CLR_MANUAL_EVENTCLR_SEMAPHORE
- DBMIRROR_DBM_EVENT
- DBMIRROR_EVENTS_QUEUE
- DBMIRROR_WORKER_QUEUE
- DBMIRRORING_CMD
- DIRTY_PAGE_POLL
- DISPATCHER_QUEUE_SEMAPHORE
- EXECSYNCFSAGENT
- FT_IFTS_SCHEDULER_IDLE_WAIT
- FT_IFTSHC_MUTEX
- HADR_CLUSAPI_CALL
- HADR_FILESTREAM_IOMGR_IOCOMPLETION
- HADR_LOGCAPTURE_WAIT
- HADR_NOTIFICATION_DEQUEUE
- HADR_TIMER_TASK
- HADR_WORK_QUEUEKSOURCE_WAKEUP
- LAZYWRITER_SLEEPLOGMGR_QUEUE
- MEMORY_ALLOCATION_EXT
- ONDEMAND_TASK_QUEUE
- PREEMPTIVE_XE_GETTARGETSTATE
- PWAIT_ALL_COMPONENTS_INITIALIZED
- PWAIT_DIRECTLOGCONSUMER_GETNEXT
- QDS_PERSIST_TASK_MAIN_LOOP_SLEEP
- QDS_ASYNC_QUEUE
- QDS_CLEANUP_STALE_QUERIES_TASK_MAIN_LOOP_SLEEP
- QDS_SHUTDOWN_QUEUE
- REDO_THREAD_PENDING_WORK
- REQUEST_FOR_DEADLOCK_SEARCH
- RESOURCE_QUEUE
- SERVER_IDLE_CHECK
- SLEEP_BPOOL_FLUSH
- SLEEP_DBSTARTUP
- SLEEP_DCOMSTARTUP
- SLEEP_MASTERDBREADY
- SLEEP_MASTERMDREADY
- SLEEP_MASTERUPGRADED
- SLEEP_MSDBSTARTUP
- SLEEP_SYSTEMTASKSLEEP_TASK
- SLEEP_TEMPDBSTARTUP
- SNI_HTTP_ACCEPT
- SP_SERVER_DIAGNOSTICS_SLEEP
- SQLTRACE_BUFFER_FLUSH
- SQLTRACE_INCREMENTAL_FLUSH_SLEEP
- SQLTRACE_WAIT_ENTRIES
- WAIT_FOR_RESULTSWAITFOR
- WAITFOR_TASKSHUTDOWN
- WAIT_XTP_RECOVERY
- WAIT_XTP_HOST_WAIT
- WAIT_XTP_OFFLINE_CKPT_NEW_LOG
- WAIT_XTP_CKPT_CLOSE
- XE_DISPATCHER_JOI
- XE_DISPATCHER_WAIT
- XE_TIMER_EVENT
If you are seeing other waits that you think are benign and should be masked from appearing in the wait stats output then please contact us.