SQL Server Waits

The Waits Types page has been updated on the T-SQL Wiki.

The wait type documentation works will with the Database Health Reports historic wait time monitoring (Free download).  Below is a screenshot of the Historic Waits Query Advisor in the Database Health Reports project.

Here is the current list of waits that have documentation available.

• ABR
• ASSEMBLY_LOAD
• ASYNC_DISKPOOL_LOCK
• ASYNC_IO_COMPLETION
• ASYNC_NETWORK_IO
• AUDIT_GROUPCACHE_LOCK
• AUDIT_LOGINCACHE_LOCK
• AUDIT_ON_DEMAND_TARGET_LOCK
• AUDIT_XE_SESSION_MGR
• BACKUP
• BACKUP_OPERATOR
• BACKUPBUFFER
• BACKUPIO
• BACKUPTHREAD
• BAD_PAGE_PROCESS
• BROKER_CONNECTION_RECEIVE_TASK
• BROKER_ENDPOINT_STATE_MUTEX
• BROKER_EVENTHANDLER
• BROKER_INIT
• BROKER_MASTERSTART
• BROKER_RECEIVE_WAITFOR
• BROKER_REGISTERALLENDPOINTS
• BROKER_SERVICE
• BROKER_SHUTDOWN
• BROKER_TASK_STOP
• BROKER_TO_FLUSH
• BROKER_TRANSMITTER
• BUILTIN_HASHKEY_MUTEX
• CHECK_PRINT_RECORD
• CHECKPOINT_QUEUE
• CHKPT
• CLEAR_DB
• CLR_AUTO_EVENT
• CLR_CRST
• CLR_JOIN
• CLR_MANUAL_EVENT
• CLR_MEMORY_SPY
• CLR_MONITOR
• CLR_RWLOCK_READER
• CLR_RWLOCK_WRITER
• CLR_SEMAPHORE
• CLR_TASK_START
• CLRHOST_STATE_ACCESS
• CMEMTHREAD
• CXPACKET
• CXROWSET_SYNC
• DAC_INIT
• DBMIRROR_DBM_EVENT
• DBMIRROR_DBM_MUTEX
• DBMIRROR_EVENTS_QUEUE
• DBMIRROR_SEND
• DBMIRROR_WORKER_QUEUE
• DBMIRRORING_CMD
• DEADLOCK_ENUM_MUTEX
• DEADLOCK_TASK_SEARCH
• DEBUG
• DISABLE_VERSIONING
• DISKIO_SUSPEND
• DISPATCHER_QUEUE_SEMAPHORE
• DLL_LOADING_MUTEX
• DROPTEMP
• DTC
• DTC_ABORT_REQUEST
• DTC_RESOLVE
• DTC_STATE
• DTC_TMDOWN_REQUEST
• DTC_WAITFOR_OUTCOME
• DUMP_LOG_COORDINATOR
• DUMPTRIGGER
• EC
• EE_PMOLOCK
• EE_SPECPROC_MAP_INIT
• ENABLE_VERSIONING
• ERROR_REPORTING_MANAGER
• EXCHANGE
• EXECSYNC
• EXECUTION_PIPE_EVENT_INTERNAL
• FAILPOINT
• FCB_REPLICA_READ
• FCB_REPLICA_WRITE
• FS_FC_RWLOCK
• FS_GARBAGE_COLLECTOR_SHUTDOWN
• FS_HEADER_RWLOCK
• FS_LOGTRUNC_RWLOCK
• FSA_FORCE_OWN_XACT
• FSAGENT
• FSTR_CONFIG_MUTEX
• FSTR_CONFIG_RWLOCK
• FT_METADATA_MUTEX
• FT_RESTART_CRAWL
• FULLTEXT GATHERER
• GUARDIAN
• HADR_AG_MUTEX
• HADR_AR_CRITICAL_SECTION_ENTRY
• HADR_AR_MANAGER_MUTEX
• HADR_ARCONTROLLER_NOTIFICATIONS_SUBSCRIBER_LIST
• HADR_BACKUP_BULK_LOCK
• HADR_BACKUP_QUEUE
• HADR_CLUSAPI_CALL
• HADR_COMPRESSED_CACHE_SYNC
• HADR_DATABASE_FLOW_CONTROL
• HADR_DATABASE_VERSIONING_STATE
• HADR_DATABASE_WAIT_FOR_RESTART
• HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING
• HADR_DB_COMMAND
• HADR_DB_OP_COMPLETION_SYNC
• HADR_DB_OP_START_SYNC
• HADR_DBR_SUBSCRIBER
• HADR_DBR_SUBSCRIBER_FILTER_LIST
• HADR_DBSTATECHANGE_SYNC
• HADR_FILESTREAM_BLOCK_FLUSH
• HADR_FILESTREAM_FILE_CLOSE
• HADR_FILESTREAM_FILE_REQUEST
• HADR_FILESTREAM_IOMGR
• HADR_FILESTREAM_IOMGR_IOCOMPLETION
• HADR_FILESTREAM_MANAGER
• HADR_GROUP_COMMIT
• HADR_LOGCAPTURE_SYNC
• HADR_LOGCAPTURE_WAIT
• HADR_LOGPROGRESS_SYNC
• HADR_NOTIFICATION_DEQUEUE
• HADR_NOTIFICATION_WORKER_EXCLUSIVE_ACCESS
• HADR_NOTIFICATION_WORKER_STARTUP_SYNC
• HADR_NOTIFICATION_WORKER_TERMINATION_SYNC
• HADR_PARTNER_SYNC
• HADR_READ_ALL_NETWORKS
• HADR_RECOVERY_WAIT_FOR_CONNECTION
• HADR_RECOVERY_WAIT_FOR_UNDO
• HADR_REPLICAINFO_SYNC
• HADR_SYNC_COMMIT
• HADR_SYNCHRONIZING_THROTTLE
• HADR_TDS_LISTENER_SYNC
• HADR_TDS_LISTENER_SYNC_PROCESSING
• HADR_TIMER_TASK
• HADR_TRANSPORT_DBRLIST
• HADR_TRANSPORT_FLOW_CONTROL
• HADR_TRANSPORT_SESSION
• HADR_WORK_POOL
• HADR_WORK_QUEUE
• HADR_XRF_STACK_ACCESS
• HTTP_ENUMERATION
• HTTP_START
• IMPPROV_IOWAIT
• INTERNAL_TESTING
• IO_AUDIT_MUTEX
• IO_COMPLETION
• IO_RETRY
• IOAFF_RANGE_QUEUE
• KSOURCE_WAKEUP
• KTM_ENLISTMENT
• KTM_RECOVERY_MANAGER
• KTM_RECOVERY_RESOLUTION
• LATCH_DT
• LATCH_EX
• LATCH_KP
• LATCH_NL
• LATCH_SH
• LATCH_UP
• LAZYWRITER_SLEEP
• LCK_M_BU
• LCK_M_IS
• LCK_M_IU
• LCK_M_IX
• LCK_M_RIn_NL
• LCK_M_RIn_S
• LCK_M_RIn_U
• LCK_M_RIn_X
• LCK_M_RS_S
• LCK_M_RS_U
• LCK_M_RX_S
• LCK_M_RX_U
• LCK_M_RX_X
• LCK_M_S
• LCK_M_SCH_M
• LCK_M_SCH_S
• LCK_M_SIU
• LCK_M_SIX
• LCK_M_U
• LCK_M_UIX
• LCK_M_X
• LOGBUFFER
• LOGGENERATION
• LOGMGR
• LOGMGR_FLUSH
• LOGMGR_QUEUE
• LOGMGR_RESERVE_APPEND
• LOWFAIL_MEMMGR_QUEUE
• MISCELLANEOUS
• MSQL_DQ
• MSQL_XACT_MGR_MUTEX
• MSQL_XACT_MUTEX
• MSQL_XP
• MSSEARCH
• NET_WAITFOR_PACKET
• OLEDB
• ONDEMAND_TASK_QUEUE
• PAGEIOLATCH_DT
• PAGEIOLATCH_EX
• PAGEIOLATCH_KP
• PAGEIOLATCH_NL
• PAGEIOLATCH_SH
• PAGEIOLATCH_UP
• PAGELATCH_DT
• PAGELATCH_EX
• PAGELATCH_KP
• PAGELATCH_NL
• PAGELATCH_SH
• PAGELATCH_UP
• PARALLEL_BACKUP_QUEUE
• PREEMPTIVE_ABR
• PREEMPTIVE_AUDIT_ACCESS_EVENTLOG
• PREEMPTIVE_AUDIT_ACCESS_SECLOG
• PREEMPTIVE_CLOSEBACKUPMEDIA
• PREEMPTIVE_CLOSEBACKUPTAPE
• PREEMPTIVE_CLOSEBACKUPVDIDEVICE
• PREEMPTIVE_CLUSAPI_CLUSTERRESOURCECONTROL
• PREEMPTIVE_COM_COCREATEINSTANCE
• PREEMPTIVE_HADR_LEASE_MECHANISM
• PREEMPTIVE_SOSTESTING
• PREEMPTIVE_STRESSDRIVER
• PREEMPTIVE_TESTING
• PREEMPTIVE_XETESTING
• PRINT_ROLLBACK_PROGRESS
• PWAIT_HADR_CHANGE_NOTIFIER_TERMINATION_SYNC
• PWAIT_HADR_CLUSTER_INTEGRATION
• PWAIT_HADR_OFFLINE_COMPLETED
• PWAIT_HADR_ONLINE_COMPLETED
• PWAIT_HADR_POST_ONLINE_COMPLETED
• PWAIT_HADR_WORKITEM_COMPLETED
• QPJOB_KILL
• QPJOB_WAITFOR_ABORT
• QRY_MEM_GRANT_INFO_MUTEX
• QUERY_ERRHDL_SERVICE_DONE
• QUERY_EXECUTION_INDEX_SORT_EVENT_OPEN
• QUERY_NOTIFICATION_MGR_MUTEX
• QUERY_NOTIFICATION_SUBSCRIPTION_MUTEX
• QUERY_NOTIFICATION_TABLE_MGR_MUTEX
• QUERY_NOTIFICATION_UNITTEST_MUTEX
• QUERY_OPTIMIZER_PRINT_MUTEX
• QUERY_TRACEOUT
• QUERY_WAIT_ERRHDL_SERVICE
• RECOVER_CHANGEDB
• REPL_CACHE_ACCESS
• REPL_SCHEMA_ACCESS
• REPLICA_WRITES
• REQUEST_DISPENSER_PAUSE
• REQUEST_FOR_DEADLOCK_SEARCH
• RESMGR_THROTTLED
• RESOURCE_QUEUE
• RESOURCE_SEMAPHORE
• RESOURCE_SEMAPHORE_MUTEX
• RESOURCE_SEMAPHORE_QUERY_COMPILE
• RESOURCE_SEMAPHORE_SMALL_QUERY
• SEC_DROP_TEMP_KEY
• SECURITY_MUTEX
• SEQUENTIAL_GUID
• SERVER_IDLE_CHECK
• SHUTDOWN
• SLEEP_BPOOL_FLUSH
• SLEEP_DBSTARTUP
• SLEEP_DCOMSTARTUP
• SLEEP_MSDBSTARTUP
• SLEEP_SYSTEMTASK
• SLEEP_TASK
• SLEEP_TEMPDBSTARTUP
• SNI_CRITICAL_SECTION
• SNI_HTTP_WAITFOR_0_DISCON
• SNI_LISTENER_ACCESS
• SNI_TASK_COMPLETION
• SOAP_READ
• SOAP_WRITE
• SOS_CALLBACK_REMOVAL
• SOS_DISPATCHER_MUTEX
• SOS_LOCALALLOCATORLIST
• SOS_MEMORY_USAGE_ADJUSTMENT
• SOS_OBJECT_STORE_DESTROY_MUTEX
• SOS_PROCESS_AFFINITY_MUTEX
• SOS_RESERVEDMEMBLOCKLIST
• SOS_SCHEDULER_YIELD
• SOS_SMALL_PAGE_ALLOC
• SOS_STACKSTORE_INIT_MUTEX
• SOS_SYNC_TASK_ENQUEUE_EVENT
• SOS_VIRTUALMEMORY_LOW
• SOSHOST_EVENT
• SOSHOST_INTERNAL
• SOSHOST_MUTEX
• SOSHOST_RWLOCK
• SOSHOST_SEMAPHORE
• SOSHOST_SLEEP
• SOSHOST_TRACELOCK
• SOSHOST_WAITFORDONE
• SQLCLR_APPDOMAIN
• SQLCLR_ASSEMBLY
• SQLCLR_DEADLOCK_DETECTION
• SQLCLR_QUANTUM_PUNISHMENT
• SQLSORT_NORMMUTEX
• SQLSORT_SORTMUTEX
• SQLTRACE_BUFFER_FLUSH
• SQLTRACE_LOCK
• SQLTRACE_SHUTDOWN
• SQLTRACE_WAIT_ENTRIES
• SRVPROC_SHUTDOWN
• TEMPOBJ
• THREADPOOL
• TIMEPRIV_TIMEPERIOD
• TRACEWRITE
• TRAN_MARKLATCH_DT
• TRAN_MARKLATCH_EX
• TRAN_MARKLATCH_KP
• TRAN_MARKLATCH_NL
• TRAN_MARKLATCH_SH
• TRAN_MARKLATCH_UP
• TRANSACTION_MUTEX
• UTIL_PAGE_ALLOC
• VIA_ACCEPT
• VIEW_DEFINITION_MUTEX
• WAIT_FOR_RESULTS
• WAITFOR
• WAITFOR_TASKSHUTDOWN
• WAITSTAT_MUTEX
• WCC
• WORKTBL_DROP
• WRITE_COMPLETION
• WRITELOG
• XACT_OWN_TRANSACTION
• XACT_RECLAIM_SESSION
• XACTLOCKINFO
• XACTWORKSPACE_MUTEX
• XE_BUFFERMGR_ALLPROCESSED_EVENT
• XE_BUFFERMGR_FREEBUF_EVENT
• XE_DISPATCHER_CONFIG_SESSION_LIST
• XE_DISPATCHER_JOIN
• XE_DISPATCHER_WAIT
• XE_MODULEMGR_SYNC
• XE_OLS_LOCK
• XE_PACKAGE_LOCK_BACKOFF
• FT_COMPROWSET_RWLOCK
• FT_IFTS_RWLOCK
• FT_IFTS_SCHEDULER_IDLE_WAIT
• FT_IFTSHC_MUTEX
• FT_IFTSISM_MUTEX
• FT_MASTER_MERGE

More from Stedman Solutions:

Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!