SQL Server Wait Types Library

(Companion SQL Server Latch Classes Library)

This site lists all wait types in SQL Server 2005 onward and gives detailed information about where they occur inside SQL Server. All waits have an infographic showing how prevalent that wait is, based on the previous month’s aggregated monitoring data from man thousands of SentryOne-monitored instances. I created this site to be a comprehensive resource for the SQL Server community as this information is not available anywhere else. I hope it helps you with SQL Server performance tuning and understanding SQL Server in more depth.

Usage: you may link to/use this information any way you want, except you may not include this information in a commercial product/website, or republish information from this library in any form without *first* getting permission from me.

For info on how to help gathering data for this site, and to submit general feedback (or even just to let me know that you found it useful and/or tell me how you used it), please send me email.

Thanks!

Paul

People who have helped/are helping gather data for the wait types library: Greg Gonzalez and the SentryOne team, Arun Sirpal (top contributor!), Jonathan Kehayias, Erin Stellato, Tim Radney, Anthony Nocentino, Tim Chapman (MSFT), Steve Stedman

SQL Server Wait Types

Wait types covered: 898 with detailed information on 303 (updated 5/10/17)

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

A

ABR
AM_INDBUILD_ALLOCATION
AM_SCHEMAMGR_UNSHARED_CACHE
ASSEMBLY_FILTER_HASHTABLE
ASSEMBLY_LOAD
ASYNC_DISKPOOL_LOCK
ASYNC_IO_COMPLETION
ASYNC_NETWORK_IO
ASYNC_OP_COMPLETION
ASYNC_OP_CONTEXT_READ
ASYNC_OP_CONTEXT_WRITE
ASYNC_SOCKETDUP_IO
AUDIT_GROUPCACHE_LOCK
AUDIT_LOGINCACHE_LOCK
AUDIT_ON_DEMAND_TARGET_LOCK
AUDIT_XE_SESSION_MGR

B

(Back to top)
BACKUP
BACKUP_CLIENTLOCK
BACKUP_OPERATOR
BACKUPBUFFER
BACKUPIO
BACKUPTHREAD
BAD_PAGE_PROCESS
BLOB_METADATA
BMPALLOCATION
BMPBUILD
BMPREPARTITION
BMPREPLICATION
BPSORT
BROKER_CONNECTION_RECEIVE_TASK
BROKER_DISPATCHER
BROKER_ENDPOINT_STATE_MUTEX
BROKER_EVENTHANDLER
BROKER_FORWARDER
BROKER_INIT
BROKER_MASTERSTART
BROKER_RECEIVE_WAITFOR
BROKER_REGISTERALLENDPOINTS
BROKER_SERVICE
BROKER_SHUTDOWN
BROKER_START
BROKER_TASK_SHUTDOWN
BROKER_TASK_STOP
BROKER_TASK_SUBMIT
BROKER_TO_FLUSH
BROKER_TRANSMISSION_OBJECT
BROKER_TRANSMISSION_TABLE
BROKER_TRANSMISSION_WORK
BROKER_TRANSMITTER
BUILTIN_HASHKEY_MUTEX

C

(Back to top)
CHANGE_TRACKING_WAITFORCHANGES
CHECK_PRINT_RECORD
CHECK_SCANNER_MUTEX
CHECK_TABLES_INITIALIZATION
CHECK_TABLES_SINGLE_SCAN
CHECK_TABLES_THREAD_BARRIER
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
CMEMPARTITIONED
CMEMTHREAD
COLUMNSTORE_BUILD_THROTTLE
COLUMNSTORE_COLUMNDATASET_SESSION_LIST
COMMIT_TABLE
CONNECTION_ENDPOINT_LOCK
COUNTRECOVERYMGR
CREATE_DATINISERVICE
CURSOR
CURSOR_ASYNC
CXPACKET
CXROWSET_SYNC

D

(Back to top)
DAC_INIT
DBCC_SCALE_OUT_EXPR_CACHE
DBMIRROR_DBM_EVENT
DBMIRROR_DBM_MUTEX
DBMIRROR_EVENTS_QUEUE
DBMIRROR_SEND
DBMIRROR_WORKER_QUEUE
DBMIRRORING_CMD
DBSEEDING_FLOWCONTROL
DBSEEDING_OPERATION
DBSTATE
DBTABLE
DEADLOCK_ENUM_MUTEX
DEADLOCK_TASK_SEARCH
DEBUG
DIRECTLOGCONSUMER_LIST
DIRTY_PAGE_POLL
DIRTY_PAGE_SYNC
DIRTY_PAGE_TABLE_LOCK
DISABLE_VERSIONING
DISKIO_SUSPEND
DISPATCHER_PRIORITY_QUEUE_SEMAPHORE
DISPATCHER_QUEUE_SEMAPHORE
DLL_LOADING_MUTEX
DPT_ENTRY_LOCK
DROP_DATABASE_TIMER_TASK
DROPTEMP
DTC
DTC_ABORT_REQUEST
DTC_RESOLVE
DTC_STATE
DTC_TMDOWN_REQUEST
DTC_WAITFOR_OUTCOME
DTCNEW_ENLIST
DTCNEW_PREPARE
DTCNEW_RECOVERY
DTCNEW_TM
DTCNEW_TRANSACTION_ENLISTMENT
DTCPNTSYNC
DUMP_LOG_COORDINATOR
DUMP_LOG_COORDINATOR_QUEUE
DUMPTRIGGER

E

(Back to top)
EC
EE_PMOLOCK
EE_SPECPROC_MAP_INIT
ENABLE_EMPTY_VERSIONING
ENABLE_VERSIONING
ERROR_REPORTING_MANAGER
EXCHANGE
EXECSYNC
EXECUTION_PIPE_EVENT_INTERNAL
EXTERNAL_RG_UPDATE
EXTERNAL_SCRIPT_PREPARE_SERVICE
EXTERNAL_SCRIPT_SHUTDOWN
EXTERNAL_WAIT_ON_LAUNCHER

F

(Back to top)
FABRIC_HADR_TRANSPORT_CONNECTION
FABRIC_REPLICA_CONTROLLER_LIST
FABRIC_REPLICA_CONTROLLER_STATE_AND_CONFIG
FABRIC_REPLICA_PUBLISHER_EVENT_PUBLISH
FABRIC_REPLICA_PUBLISHER_SUBSCRIBER_LIST
FABRIC_WAIT_FOR_BUILD_REPLICA_EVENT_PROCESSING
FAILPOINT
FCB_REPLICA_READ
FCB_REPLICA_WRITE
FEATURE_SWITCHES_UPDATE
FFT_NSO_DB_KILL_FLAG
FFT_NSO_DB_LIST
FFT_NSO_FCB
FFT_NSO_FCB_FIND
FFT_NSO_FCB_PARENT
FFT_NSO_FCB_RELEASE_CACHED_ENTRIES
FFT_NSO_FCB_STATE
FFT_NSO_FILEOBJECT
FFT_NSO_TABLE_LIST
FFT_NTFS_STORE
FFT_RECOVERY
FFT_RSFX_COMM
FFT_RSFX_WAIT_FOR_MEMORY
FFT_STARTUP_SHUTDOWN
FFT_STORE_DB
FFT_STORE_ROWSET_LIST
FFT_STORE_TABLE
FILE_VALIDATION_THREADS
FILESTREAM_CACHE
FILESTREAM_CHUNKER
FILESTREAM_CHUNKER_INIT
FILESTREAM_FCB
FILESTREAM_FILE_OBJECT
FILESTREAM_WORKITEM_QUEUE
FILETABLE_SHUTDOWN
FORWARDER_TRANSITION
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_COMPROWSET_RWLOCK
FT_IFTS_RWLOCK
FT_IFTS_SCHEDULER_IDLE_WAIT
FT_IFTSHC_MUTEX
FT_IFTSISM_MUTEX
FT_MASTER_MERGE
FT_MASTER_MERGE_COORDINATOR
FT_METADATA_MUTEX
FT_PROPERTYLIST_CACHE
FT_RESTART_CRAWL
FT_RESUME_CRAWL
FULLTEXT GATHERER

G

(Back to top)
GDMA_GET_RESOURCE_OWNER
GHOSTCLEANUPSYNCMGR
GLOBAL_QUERY_CLOSE
GLOBAL_TRAN_CREATE
GLOBAL_TRAN_UCS_SESSION
GUARDIAN

H

(Back to top)
HADR_AG_MUTEX
HADR_AR_CRITICAL_SECTION_ENTRY
HADR_AR_MANAGER_MUTEX
HADR_AR_UNLOAD_COMPLETED
HADR_ARCONTROLLER_NOTIFICATIONS_SUBSCRIBER_LIST
HADR_BACKUP_BULK_LOCK
HADR_BACKUP_QUEUE
HADR_CLUSAPI_CALL
HADR_COMPRESSED_CACHE_SYNC
HADR_CONNECTIVITY_INFO
HADR_DBSEEDING
HADR_DBSEEDING_LIST
HADR_DATABASE_FLOW_CONTROL
HADR_DATABASE_VERSIONING_STATE
HADR_DATABASE_WAIT_FOR_RECOVERY
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_FABRIC_CALLBACK
HADR_FILESTREAM_BLOCK_FLUSH
HADR_FILESTREAM_FILE_CLOSE
HADR_FILESTREAM_FILE_REQUEST
HADR_FILESTREAM_IOMGR
HADR_FILESTREAM_IOMGR_IOCOMPLETION
HADR_FILESTREAM_MANAGER
HADR_FILESTREAM_PREPROC
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_SEEDING_CANCELLATION
HADR_SEEDING_FILE_LIST
HADR_SEEDING_LIMIT_BACKUPS
HADR_SEEDING_SYNC_COMPLETION
HADR_SEEDING_TIMEOUT_TASK
HADR_SEEDING_WAIT_FOR_COMPLETION
HADR_SYNC_COMMIT
HADR_SYNCHRONIZING_THROTTLE
HADR_TDS_LISTENER_SYNC
HADR_TDS_LISTENER_SYNC_PROCESSING
HADR_THROTTLE_LOG_RATE_GOVERNOR
HADR_TIMER_TASK
HADR_TRANSPORT_DBRLIST
HADR_TRANSPORT_FLOW_CONTROL
HADR_TRANSPORT_SESSION
HADR_WORK_POOL
HADR_WORK_QUEUE
HADR_XRF_STACK_ACCESS
HCCO_CACHE
HK_RESTORE_FILEMAP
HKCS_PARALLEL_MIGRATION
HKCS_PARALLEL_RECOVERY
HTBUILD
HTDELETE
HTMEMO
HTREINIT
HTREPARTITION
HTTP_ENDPOINT_COLLCREATE
HTTP_ENUMERATION
HTTP_START
HTTP_STORAGE_CONNECTION

I

(Back to top)
IMP_IMPORT_MUTEX
IMPPROV_IOWAIT
INSTANCE_LOG_RATE_GOVERNOR
INDEX_USAGE_STATS_MUTEX
INTERNAL_TESTING
IO_AUDIT_MUTEX
IO_COMPLETION
IO_QUEUE_LIMIT
IO_RETRY
IOAFF_RANGE_QUEUE

J

(Back to top)

K

(Back to top)
KSOURCE_WAKEUP
KTM_ENLISTMENT
KTM_RECOVERY_MANAGER
KTM_RECOVERY_RESOLUTION

L

(Back to top)
LATCH_DT
LATCH_EX
LATCH_KP
LATCH_NL
LATCH_SH
LATCH_UP
LAZYWRITER_SLEEP
LCK_M_BU
LCK_M_BU_ABORT_BLOCKERS
LCK_M_BU_LOW_PRIORITY
LCK_M_IS
LCK_M_IS_ABORT_BLOCKERS
LCK_M_IS_LOW_PRIORITY
LCK_M_IU
LCK_M_IU_ABORT_BLOCKERS
LCK_M_IU_LOW_PRIORITY
LCK_M_IX
LCK_M_IX_ABORT_BLOCKERS
LCK_M_IX_LOW_PRIORITY
LCK_M_RIn_NL
LCK_M_RIn_NL_ABORT_BLOCKERS
LCK_M_RIn_NL_LOW_PRIORITY
LCK_M_RIn_S
LCK_M_RIn_S_ABORT_BLOCKERS
LCK_M_RIn_S_LOW_PRIORITY
LCK_M_RIn_U
LCK_M_RIn_U_ABORT_BLOCKERS
LCK_M_RIn_U_LOW_PRIORITY
LCK_M_RIn_X
LCK_M_RIn_X_ABORT_BLOCKERS
LCK_M_RIn_X_LOW_PRIORITY
LCK_M_RS_S
LCK_M_RS_S_ABORT_BLOCKERS
LCK_M_RS_S_LOW_PRIORITY
LCK_M_RS_U
LCK_M_RS_U_ABORT_BLOCKERS
LCK_M_RS_U_LOW_PRIORITY
LCK_M_RX_S
LCK_M_RX_S_ABORT_BLOCKERS
LCK_M_RX_S_LOW_PRIORITY
LCK_M_RX_U
LCK_M_RX_U_ABORT_BLOCKERS
LCK_M_RX_U_LOW_PRIORITY
LCK_M_RX_X
LCK_M_RX_X_ABORT_BLOCKERS
LCK_M_RX_X_LOW_PRIORITY
LCK_M_S
LCK_M_S_ABORT_BLOCKERS
LCK_M_S_LOW_PRIORITY
LCK_M_SCH_M
LCK_M_SCH_M_ABORT_BLOCKERS
LCK_M_SCH_M_LOW_PRIORITY
LCK_M_SCH_S
LCK_M_SCH_S_ABORT_BLOCKERS
LCK_M_SCH_S_LOW_PRIORITY
LCK_M_SIU
LCK_M_SIU_ABORT_BLOCKERS
LCK_M_SIU_LOW_PRIORITY
LCK_M_SIX
LCK_M_SIX_ABORT_BLOCKERS
LCK_M_SIX_LOW_PRIORITY
LCK_M_U
LCK_M_U_ABORT_BLOCKERS
LCK_M_U_LOW_PRIORITY
LCK_M_UIX
LCK_M_UIX_ABORT_BLOCKERS
LCK_M_UIX_LOW_PRIORITY
LCK_M_X
LCK_M_X_ABORT_BLOCKERS
LCK_M_X_LOW_PRIORITY
LOG_POOL_SCAN
LOG_RATE_GOVERNOR
LOGBUFFER
LOGCAPTURE_LOGPOOLTRUNCPOINT
LOGGENERATION
LOGMGR
LOGMGR_FLUSH
LOGMGR_PMM_LOG
LOGMGR_QUEUE
LOGMGR_RESERVE_APPEND
LOGPOOL_CACHESIZE
LOGPOOL_CONSUMER
LOGPOOL_CONSUMERSET
LOGPOOL_FREEPOOLS
LOGPOOL_MGRSET
LOGPOOL_REPLACEMENTSET
LOGPOOLREFCOUNTEDOBJECT_REFDONE
LOWFAIL_MEMMGR_QUEUE

M

(Back to top)
MD_AGENT_YIELD
MD_LAZYCACHE_RWLOCK
MEMORY_ALLOCATION_EXT
METADATA_LAZYCACHE_RWLOCK
MIRROR_SEND_MESSAGE
MISCELLANEOUS
MSQL_DQ
MSQL_SYNC_PIPE
MSQL_XACT_MGR_MUTEX
MSQL_XACT_MUTEX
MSQL_XP
MSSEARCH

N

(Back to top)
NET_WAITFOR_PACKET
NETWORKSXMLMGRLOAD
NODE_CACHE_MUTEX

O

(Back to top)
OLEDB
ONDEMAND_TASK_QUEUE

P

(Back to top)
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
PARALLEL_REDO_DRAIN_WORKER
PARALLEL_REDO_FLOW_CONTROL
PARALLEL_REDO_LOG_CACHE
PARALLEL_REDO_TRAN_LIST
PARALLEL_REDO_TRAN_TURN
PARALLEL_REDO_WORKER_SYNC
PARALLEL_REDO_WORKER_WAIT_WORK
PERFORMANCE_COUNTERS_RWLOCK
PHYSICAL_SEEDING_DMV
POOL_LOG_RATE_GOVERNOR
PREEMPTIVE_ABR
PREEMPTIVE_AUDIT_ACCESS_EVENTLOG
PREEMPTIVE_AUDIT_ACCESS_SECLOG
PREEMPTIVE_CLOSEBACKUPMEDIA
PREEMPTIVE_CLOSEBACKUPTAPE
PREEMPTIVE_CLOSEBACKUPVDIDEVICE
PREEMPTIVE_CLUSAPI_CLUSTERRESOURCECONTROL
PREEMPTIVE_COM_COCREATEINSTANCE
PREEMPTIVE_COM_COGETCLASSOBJECT
PREEMPTIVE_COM_CREATEACCESSOR
PREEMPTIVE_COM_DELETEROWS
PREEMPTIVE_COM_GETCOMMANDTEXT
PREEMPTIVE_COM_GETDATA
PREEMPTIVE_COM_GETNEXTROWS
PREEMPTIVE_COM_GETRESULT
PREEMPTIVE_COM_GETROWSBYBOOKMARK
PREEMPTIVE_COM_LBFLUSH
PREEMPTIVE_COM_LBLOCKREGION
PREEMPTIVE_COM_LBREADAT
PREEMPTIVE_COM_LBSETSIZE
PREEMPTIVE_COM_LBSTAT
PREEMPTIVE_COM_LBUNLOCKREGION
PREEMPTIVE_COM_LBWRITEAT
PREEMPTIVE_COM_QUERYINTERFACE
PREEMPTIVE_COM_RELEASE
PREEMPTIVE_COM_RELEASEACCESSOR
PREEMPTIVE_COM_RELEASEROWS
PREEMPTIVE_COM_RELEASESESSION
PREEMPTIVE_COM_RESTARTPOSITION
PREEMPTIVE_COM_SEQSTRMREAD
PREEMPTIVE_COM_SEQSTRMREADANDWRITE
PREEMPTIVE_COM_SETDATAFAILURE
PREEMPTIVE_COM_SETPARAMETERINFO
PREEMPTIVE_COM_SETPARAMETERPROPERTIES
PREEMPTIVE_COM_STRMLOCKREGION
PREEMPTIVE_COM_STRMSEEKANDREAD
PREEMPTIVE_COM_STRMSEEKANDWRITE
PREEMPTIVE_COM_STRMSETSIZE
PREEMPTIVE_COM_STRMSTAT
PREEMPTIVE_COM_STRMUNLOCKREGION
PREEMPTIVE_CONSOLEWRITE
PREEMPTIVE_CREATEPARAM
PREEMPTIVE_DEBUG
PREEMPTIVE_DFSADDLINK
PREEMPTIVE_DFSLINKEXISTCHECK
PREEMPTIVE_DFSLINKHEALTHCHECK
PREEMPTIVE_DFSREMOVELINK
PREEMPTIVE_DFSREMOVEROOT
PREEMPTIVE_DFSROOTFOLDERCHECK
PREEMPTIVE_DFSROOTINIT
PREEMPTIVE_DFSROOTSHARECHECK
PREEMPTIVE_DTC_ABORT
PREEMPTIVE_DTC_ABORTREQUESTDONE
PREEMPTIVE_DTC_BEGINTRANSACTION
PREEMPTIVE_DTC_COMMITREQUESTDONE
PREEMPTIVE_DTC_ENLIST
PREEMPTIVE_DTC_PREPAREREQUESTDONE
PREEMPTIVE_FILESIZEGET
PREEMPTIVE_FSAOLEDB_ABORTTRANSACTION
PREEMPTIVE_FSAOLEDB_COMMITTRANSACTION
PREEMPTIVE_FSAOLEDB_STARTTRANSACTION
PREEMPTIVE_FSRECOVER_UNCONDITIONALUNDO
PREEMPTIVE_GETRMINFO
PREEMPTIVE_HADR_LEASE_MECHANISM
PREEMPTIVE_HTTP_EVENT_WAIT
PREEMPTIVE_HTTP_REQUEST
PREEMPTIVE_LOCKMONITOR
PREEMPTIVE_MSS_RELEASE
PREEMPTIVE_ODBCOPS
PREEMPTIVE_OLE_UNINIT
PREEMPTIVE_OLEDB_ABORTORCOMMITTRAN
PREEMPTIVE_OLEDB_ABORTTRAN
PREEMPTIVE_OLEDB_GETDATASOURCE
PREEMPTIVE_OLEDB_GETLITERALINFO
PREEMPTIVE_OLEDB_GETPROPERTIES
PREEMPTIVE_OLEDB_GETPROPERTYINFO
PREEMPTIVE_OLEDB_GETSCHEMALOCK
PREEMPTIVE_OLEDB_JOINTRANSACTION
PREEMPTIVE_OLEDB_RELEASE
PREEMPTIVE_OLEDB_SETPROPERTIES
PREEMPTIVE_OLEDBOPS
PREEMPTIVE_OS_ACCEPTSECURITYCONTEXT
PREEMPTIVE_OS_ACQUIRECREDENTIALSHANDLE
PREEMPTIVE_OS_AUTHENTICATIONOPS
PREEMPTIVE_OS_AUTHORIZATIONOPS
PREEMPTIVE_OS_AUTHZGETINFORMATIONFROMCONTEXT
PREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSID
PREEMPTIVE_OS_AUTHZINITIALIZERESOURCEMANAGER
PREEMPTIVE_OS_BACKUPREAD
PREEMPTIVE_OS_CLOSEHANDLE
PREEMPTIVE_OS_CLUSTEROPS
PREEMPTIVE_OS_COMOPS
PREEMPTIVE_OS_COMPLETEAUTHTOKEN
PREEMPTIVE_OS_COPYFILE
PREEMPTIVE_OS_CREATEDIRECTORY
PREEMPTIVE_OS_CREATEFILE
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT
PREEMPTIVE_OS_CRYPTIMPORTKEY
PREEMPTIVE_OS_CRYPTOPS
PREEMPTIVE_OS_DECRYPTMESSAGE
PREEMPTIVE_OS_DELETEFILE
PREEMPTIVE_OS_DELETESECURITYCONTEXT
PREEMPTIVE_OS_DEVICEIOCONTROL
PREEMPTIVE_OS_DEVICEOPS
PREEMPTIVE_OS_DIRSVC_NETWORKOPS
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE
PREEMPTIVE_OS_DOMAINSERVICESOPS
PREEMPTIVE_OS_DSGETDCNAME
PREEMPTIVE_OS_DTCOPS
PREEMPTIVE_OS_ENCRYPTMESSAGE
PREEMPTIVE_OS_FILEOPS
PREEMPTIVE_OS_FINDFILE
PREEMPTIVE_OS_FLUSHFILEBUFFERS
PREEMPTIVE_OS_FORMATMESSAGE
PREEMPTIVE_OS_FREECREDENTIALSHANDLE
PREEMPTIVE_OS_FREELIBRARY
PREEMPTIVE_OS_GENERICOPS
PREEMPTIVE_OS_GETADDRINFO
PREEMPTIVE_OS_GETCOMPRESSEDFILESIZE
PREEMPTIVE_OS_GETDISKFREESPACE
PREEMPTIVE_OS_GETFILEATTRIBUTES
PREEMPTIVE_OS_GETFILESIZE
PREEMPTIVE_OS_GETFINALFILEPATHBYHANDLE
PREEMPTIVE_OS_GETLONGPATHNAME
PREEMPTIVE_OS_GETPROCADDRESS
PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT
PREEMPTIVE_OS_GETVOLUMEPATHNAME
PREEMPTIVE_OS_INITIALIZESECURITYCONTEXT
PREEMPTIVE_OS_LIBRARYOPS
PREEMPTIVE_OS_LOADLIBRARY
PREEMPTIVE_OS_LOGONUSER
PREEMPTIVE_OS_LOOKUPACCOUNTSID
PREEMPTIVE_OS_MESSAGEQUEUEOPS
PREEMPTIVE_OS_MOVEFILE
PREEMPTIVE_OS_NETGROUPGETUSERS
PREEMPTIVE_OS_NETLOCALGROUPGETMEMBERS
PREEMPTIVE_OS_NETUSERGETGROUPS
PREEMPTIVE_OS_NETUSERGETLOCALGROUPS
PREEMPTIVE_OS_NETUSERMODALSGET
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE
PREEMPTIVE_OS_OPENDIRECTORY
PREEMPTIVE_OS_PDH_WMI_INIT
PREEMPTIVE_OS_PIPEOPS
PREEMPTIVE_OS_PROCESSOPS
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES
PREEMPTIVE_OS_QUERYREGISTRY
PREEMPTIVE_OS_QUERYSECURITYCONTEXTTOKEN
PREEMPTIVE_OS_REMOVEDIRECTORY
PREEMPTIVE_OS_REPORTEVENT
PREEMPTIVE_OS_REVERTTOSELF
PREEMPTIVE_OS_RSFXDEVICEOPS
PREEMPTIVE_OS_SECURITYOPS
PREEMPTIVE_OS_SERVICEOPS
PREEMPTIVE_OS_SETENDOFFILE
PREEMPTIVE_OS_SETFILEPOINTER
PREEMPTIVE_OS_SETFILEVALIDDATA
PREEMPTIVE_OS_SETNAMEDSECURITYINFO
PREEMPTIVE_OS_SQLCLROPS
PREEMPTIVE_OS_SQMLAUNCH
PREEMPTIVE_OS_VERIFYSIGNATURE
PREEMPTIVE_OS_VERIFYTRUST
PREEMPTIVE_OS_VSSOPS
PREEMPTIVE_OS_WAITFORSINGLEOBJECT
PREEMPTIVE_OS_WINSOCKOPS
PREEMPTIVE_OS_WRITEFILE
PREEMPTIVE_OS_WRITEFILEGATHER
PREEMPTIVE_OS_WSASETLASTERROR
PREEMPTIVE_REENLIST
PREEMPTIVE_RESIZELOG
PREEMPTIVE_ROLLFORWARDREDO
PREEMPTIVE_ROLLFORWARDUNDO
PREEMPTIVE_SB_STOPENDPOINT
PREEMPTIVE_SERVER_STARTUP
PREEMPTIVE_SETRMINFO
PREEMPTIVE_SHAREDMEM_GETDATA
PREEMPTIVE_SNIOPEN
PREEMPTIVE_SOSHOST
PREEMPTIVE_SOSTESTING
PREEMPTIVE_SP_SERVER_DIAGNOSTICS
PREEMPTIVE_STARTRM
PREEMPTIVE_STREAMFCB_CHECKPOINT
PREEMPTIVE_STREAMFCB_RECOVER
PREEMPTIVE_STRESSDRIVER
PREEMPTIVE_TESTING
PREEMPTIVE_TRANSIMPORT
PREEMPTIVE_UNMARSHALPROPAGATIONTOKEN
PREEMPTIVE_VSS_CREATESNAPSHOT
PREEMPTIVE_VSS_CREATEVOLUMESNAPSHOT
PREEMPTIVE_XE_CALLBACKEXECUTE
PREEMPTIVE_XE_CX_FILE_OPEN
PREEMPTIVE_XE_CX_HTTP_CALL
PREEMPTIVE_XE_DISPATCHER
PREEMPTIVE_XE_ENGINEINIT
PREEMPTIVE_XE_GETTARGETSTATE
PREEMPTIVE_XE_SESSIONCOMMIT
PREEMPTIVE_XE_TARGETFINALIZE
PREEMPTIVE_XE_TARGETINIT
PREEMPTIVE_XE_TIMERRUN
PREEMPTIVE_XETESTING
PRINT_ROLLBACK_PROGRESS
PRU_ROLLBACK_DEFERRED
PWAIT_ALL_COMPONENTS_INITIALIZED
PWAIT_COOP_SCAN
PWAIT_DIRECTLOGCONSUMER_GETNEXT
PWAIT_EVENT_SESSION_INIT_MUTEX
PWAIT_FABRIC_REPLICA_CONTROLLER_DATA_LOSS
PWAIT_HADR_ACTION_COMPLETED
PWAIT_HADR_CHANGE_NOTIFIER_TERMINATION_SYNC
PWAIT_HADR_CLUSTER_INTEGRATION
PWAIT_HADR_FAILOVER_COMPLETED
PWAIT_HADR_JOIN
PWAIT_HADR_OFFLINE_COMPLETED
PWAIT_HADR_ONLINE_COMPLETED
PWAIT_HADR_POST_ONLINE_COMPLETED
PWAIT_HADR_SERVER_READY_CONNECTIONS
PWAIT_HADR_WORKITEM_COMPLETED
PWAIT_HADRSIM
PWAIT_LOG_CONSOLIDATION_IO
PWAIT_LOG_CONSOLIDATION_POLL
PWAIT_MD_LOGIN_STATS
PWAIT_MD_RELATION_CACHE
PWAIT_MD_SERVER_CACHE
PWAIT_MD_UPGRADE_CONFIG
PWAIT_PREEMPTIVE_AUDIT_ACCESS_WINDOWSLOG
PWAIT_QRY_BPMEMORY
PWAIT_REPLICA_ONLINE_INIT_MUTEX
PWAIT_RESOURCE_SEMAPHORE_FT_PARALLEL_QUERY_SYNC
PWAIT_SECURITY_CACHE_INVALIDATION
PWAIT_XTP_FSSTORAGE_MAINTENANCE
PWAIT_XTP_HOST_STORAGE_WAIT

Q

(Back to top)
QDS_ASYNC_CHECK_CONSISTENCY_TASK
QDS_ASYNC_PERSIST_TASK
QDS_ASYNC_PERSIST_TASK_START
QDS_ASYNC_QUEUE
QDS_BCKG_TASK
QDS_BLOOM_FILTER
QDS_CLEANUP_STALE_QUERIES_TASK_MAIN_LOOP_SLEEP
QDS_CTXS
QDS_DB_DISK
QDS_DYN_VECTOR
QDS_EXCLUSIVE_ACCESS
QDS_LOADDB
QDS_PERSIST_TASK_MAIN_LOOP_SLEEP
QDS_QDS_CAPTURE_INIT
QDS_SHUTDOWN_QUEUE
QDS_STMT
QDS_STMT_DISK
QDS_TASK_SHUTDOWN
QDS_TASK_START
QE_WARN_LIST_SYNC
QNMANAGER_ACQUIRE
QPJOB_KILL
QPJOB_WAITFOR_ABORT
QRY_MEM_GRANT_INFO_MUTEX
QRY_PARALLEL_THREAD_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_TASK_ENQUEUE_MUTEX
QUERY_TRACEOUT
QUERY_WAIT_ERRHDL_SERVICE

R

(Back to top)
RECOVER_CHANGEDB
RECOVERY_MGR_LOCK
REDO_THREAD_PENDING_WORK
REDO_THREAD_SYNC
REMOTE_DATA_ARCHIVE_MIGRATION_DMV
REMOTE_DATA_ARCHIVE_SCHEMA_DMV
REMOTE_DATA_ARCHIVE_SCHEMA_TASK_QUEUE
REPL_CACHE_ACCESS
REPL_HISTORYCACHE_ACCESS
REPL_SCHEMA_ACCESS
REPL_TRANFSINFO_ACCESS
REPL_TRANHASHTABLE_ACCESS
REPL_TRANTEXTINFO_ACCESS
REPLICA_WRITES
REQUEST_DISPENSER_PAUSE
REQUEST_FOR_DEADLOCK_SEARCH
RESERVED_MEMORY_ALLOCATION_EXT
RESMGR_THROTTLED
RESOURCE_GOVERNOR_IDLE
RESOURCE_QUEUE
RESOURCE_SEMAPHORE
RESOURCE_SEMAPHORE_MUTEX
RESOURCE_SEMAPHORE_QUERY_COMPILE
RESOURCE_SEMAPHORE_SMALL_QUERY
RG_RECONFIG
ROWGROUP_OP_STATS
ROWGROUP_VERSION
RTDATA_LIST

S

(Back to top)
SATELLITE_CARGO
SATELLITE_SERVICE_SETUP
SATELLITE_TASK
SCAN_CHAR_HASH_ARRAY_INITIALIZATION
SEC_DROP_TEMP_KEY
SECURITY_CRYPTO_CONTEXT_MUTEX
SECURITY_DBE_STATE_MUTEX
SECURITY_KEYRING_RWLOCK
SECURITY_MUTEX
SECURITY_RULETABLE_MUTEX
SEMPLAT_DSI_BUILD
SEQUENCE_GENERATION
SEQUENTIAL_GUID
SERVER_IDLE_CHECK
SERVER_RECONFIGURE
SESSION_WAIT_STATS_CHILDREN
SHARED_DELTASTORE_CREATION
SHUTDOWN
SLEEP_BPOOL_FLUSH
SLEEP_BUFFERPOOL_HELPLW
SLEEP_DBSTARTUP
SLEEP_DCOMSTARTUP
SLEEP_MASTERDBREADY
SLEEP_MASTERMDREADY
SLEEP_MASTERUPGRADED
SLEEP_MEMORYPOOL_ALLOCATEPAGES
SLEEP_MSDBSTARTUP
SLEEP_RETRY_VIRTUALALLOC
SLEEP_SYSTEMTASK
SLEEP_TASK
SLEEP_TEMPDBSTARTUP
SLEEP_WORKSPACE_ALLOCATEPAGE
SLO_UPDATE
SMSYNC
SNI_CONN_DUP
SNI_CRITICAL_SECTION
SNI_HTTP_ACCEPT
SNI_HTTP_WAITFOR_0_DISCON
SNI_LISTENER_ACCESS
SNI_TASK_COMPLETION
SOAP_READ
SOAP_WRITE
SOCKETDUPLICATEQUEUE_CLEANUP
SOS_CALLBACK_REMOVAL
SOS_DISPATCHER_MUTEX
SOS_LOCALALLOCATORLIST
SOS_MEMORY_TOPLEVELBLOCKALLOCATOR
SOS_MEMORY_USAGE_ADJUSTMENT
SOS_OBJECT_STORE_DESTROY_MUTEX
SOS_PHYS_PAGE_CACHE
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
SP_PREEMPTIVE_SERVER_DIAGNOSTICS_SLEEP
SP_SERVER_DIAGNOSTICS_BUFFER_ACCESS
SP_SERVER_DIAGNOSTICS_INIT_MUTEX
SP_SERVER_DIAGNOSTICS_SLEEP
SQLCLR_APPDOMAIN
SQLCLR_ASSEMBLY
SQLCLR_DEADLOCK_DETECTION
SQLCLR_QUANTUM_PUNISHMENT
SQLSORT_NORMMUTEX
SQLSORT_SORTMUTEX
SQLTRACE_BUFFER_FLUSH
SQLTRACE_FILE_BUFFER
SQLTRACE_FILE_READ_IO_COMPLETION
SQLTRACE_FILE_WRITE_IO_COMPLETION
SQLTRACE_INCREMENTAL_FLUSH_SLEEP
SQLTRACE_LOCK
SQLTRACE_PENDING_BUFFER_WRITERS
SQLTRACE_SHUTDOWN
SQLTRACE_WAIT_ENTRIES
SRVPROC_SHUTDOWN
STARTUP_DEPENDENCY_MANAGER

T

(Back to top)
TDS_BANDWIDTH_STATE
TDS_INIT
TDS_PROXY_CONTAINER
TEMPOBJ
TERMINATE_LISTENER
THREADPOOL
TIMEPRIV_TIMEPERIOD
TRACE_EVTNOTIF
TRACEWRITE
TRAN_MARKLATCH_DT
TRAN_MARKLATCH_EX
TRAN_MARKLATCH_KP
TRAN_MARKLATCH_NL
TRAN_MARKLATCH_SH
TRAN_MARKLATCH_UP
TRANSACTION_MUTEX

U

(Back to top)
UCS_ENDPOINT_CHANGE
UCS_MANAGER
UCS_MEMORY_NOTIFICATION
UCS_SESSION_REGISTRATION
UCS_TRANSPORT
UCS_TRANSPORT_STREAM_CHANGE
UTIL_PAGE_ALLOC

V

(Back to top)
VDI_CLIENT_COMPLETECOMMAND
VDI_CLIENT_GETCOMMAND
VDI_CLIENT_OPERATION
VDI_CLIENT_OTHER
VERSIONING_COMMITTING
VIA_ACCEPT
VIEW_DEFINITION_MUTEX

W

(Back to top)
WAIT_FOR_RESULTS
WAIT_SCRIPTDEPLOYMENT_REQUEST
WAIT_SCRIPTDEPLOYMENT_WORKER
WAIT_XTP_ASYNC_TX_COMPLETION
WAIT_XTP_CKPT_AGENT_WAKEUP
WAIT_XTP_CKPT_CLOSE
WAIT_XTP_CKPT_ENABLED
WAIT_XTP_CKPT_STATE_LOCK
WAIT_XTP_GUEST
WAIT_XTP_HOST_WAIT
WAIT_XTP_OFFLINE_CKPT_BEFORE_REDO
WAIT_XTP_OFFLINE_CKPT_LOG_IO
WAIT_XTP_OFFLINE_CKPT_NEW_LOG
WAIT_XTP_PROCEDURE_ENTRY
WAIT_XTP_RECOVERY
WAIT_XTP_SWITCH_TO_INACTIVE
WAIT_XTP_TASK_SHUTDOWN
WAIT_XTP_TRAN_COMMIT
WAIT_XTP_TRAN_DEPENDENCY
WAITFOR
WAITFOR_PER_QUEUE
WAITFOR_TASKSHUTDOWN
WAITSTAT_MUTEX
WCC
WINDOW_AGGREGATES_MULTIPASS
WINFAB_API_CALL
WINFAB_REPLICA_BUILD_OPERATION
WINFAB_REPORT_FAULT
WORKTBL_DROP
WRITE_COMPLETION
WRITELOG

X

(Back to top)
XACT_OWN_TRANSACTION
XACT_RECLAIM_SESSION
XACTLOCKINFO
XACTWORKSPACE_MUTEX
XDB_CONN_DUP_HASH
XDES_HISTORY
XDES_OUT_OF_ORDER_LIST
XDES_SNAPSHOT
XDESTSVERMGR
XE_BUFFERMGR_ALLPROCESSED_EVENT
XE_BUFFERMGR_FREEBUF_EVENT
XE_CALLBACK_LIST
XE_CX_FILE_READ
XE_DISPATCHER_CONFIG_SESSION_LIST
XE_DISPATCHER_JOIN
XE_DISPATCHER_WAIT
XE_FILE_TARGET_TVF
XE_LIVE_TARGET_TVF
XE_MODULEMGR_SYNC
XE_OLS_LOCK
XE_PACKAGE_LOCK_BACKOFF
XE_SERVICES_EVENTMANUAL
XE_SERVICES_MUTEX
XE_SERVICES_RWLOCK
XE_SESSION_CREATE_SYNC
XE_SESSION_FLUSH
XE_SESSION_SYNC
XE_STM_CREATE
XE_TIMER_EVENT
XE_TIMER_MUTEX
XE_TIMER_TASK_DONE
XIO_CREDENTIAL_MGR_RWLOCK
XIO_CREDENTIAL_RWLOCK
XIO_LEASE_RENEW_MGR_RWLOCK
XTP_HOST_DB_COLLECTION
XTP_HOST_LOG_ACTIVITY
XTP_HOST_PARALLEL_RECOVERY
XTP_PREEMPTIVE_TASK
XTP_TRUNCATION_LSN
XTPPROC_CACHE_ACCESS
XTPPROC_PARTITIONED_STACK_CREATE

Y

SQL Server Wait Types Library

标签：solution   cursor   event   bad   garbage   dwr   sas   lun   com