Skip to content
fatherjack edited this page Oct 1, 2017 · 5 revisions

Benign Wait Types

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.

Clone this wiki locally