This wait type category includes all the waits that do not belong to the Memory, I/O, Lock, Transaction Log, Non-I/O Page Latch, Non-Page Latch, or Backup categories.

The following waits are associated with the Other category:

  • ABR
  • ASSEMBLY_LOAD
  • AUDIT_GROUPCACHE_LOCK
  • AUDIT_LOGINCACHE_LOCK
  • AUDIT_ON_DEMAND_TARGET_LOCK
  • AUDIT_XE_SESSION_MGR
  • BUILTIN_HASHKEY_MUTEX
  • CHECK_PRINT_RECORD
  • CLEAR_DB
  • CLR_AUTO_EVENT
  • CLR_CRST
  • CLR_JOIN
  • CLR_MANUAL_EVENT
  • CLR_MEMORY_SPY
  • CLR_MONITOR
  • CLR_RWLOCK_READER
  • CLR_RWLOCK_WRITER
  • CLR_TASK_START
  • CLRHOST_STATE_ACCESS
  • COMMIT_TABLE
  • CURSOR_ASYNC
  • CXROWSET_SYNC
  • DAC_INIT
  • DBMIRROR_DBM_EVENT
  • DBMIRROR_DBM_MUTEX
  • DBMIRROR_SEND
  • DBMIRROR_WORKER_QUEUE
  • DBMIRRORING_CMD
  • DBTABLE
  • DEADLOCK_ENUM_MUTEX
  • DEADLOCK_TASK_SEARCH
  • DEBUG
  • DISABLE_VERSIONING
  • DISPATCHER_QUEUE_SEMAPHORE
  • DLL_LOADING_MUTEX
  • DROPTEMP
  • DTC
  • DTC_ABORT_REQUEST
  • DTC_RESOLVE
  • DTC_STATE
  • DTC_TMDOWN_REQUEST
  • DTC_WAITFOR_OUTCOME
  • DUMP_LOG_COORDINATOR
  • DUMP_LOG_COORDINATOR_QUEUE
  • DUMPTRIGGER
  • EC
  • EE_PMOLOCK
  • EE_SPECPROC_MAP_INIT
  • ENABLE_VERSIONING
  • ERROR_REPORTING_MANAGER
  • EXECSYNC
  • EXECUTION_PIPE_EVENT_INTERNAL
  • FAILPOINT
  • FCB_REPLICA_READ
  • FCB_REPLICA_START
  • 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_COMPROWSET_RWLOCK
  • FT_IFTS_RWLOCK
  • FT_IFTSHC_MUTEX
  • FT_IFTSISM_MUTEX
  • FT_MASTER_MERGE
  • FT_METADATA_MUTEX
  • FT_RESTART_CRAWL
  • FT_RESUME_CRAWL
  • FULLTEXT GATHERER
  • GUARDIAN
  • HTTP_ENDPOINT_COLLCREATE
  • HTTP_ENUMERATION
  • HTTP_START
  • IMP_IMPORT_MUTEX
  • IMPPROV_IOWAIT
  • INDEX_USAGE_STATS_MUTEX
  • INTERNAL_TESTING
  • IO_AUDIT_MUTEX
  • IO_RETRY
  • IOAFF_RANGE_QUEUE
  • KTM_ENLISTMENT
  • KTM_RECOVERY_MANAGER
  • KTM_RECOVERY_RESOLUTION
  • LOGGENERATION
  • LOGMGR
  • LOGMGR_FLUSH
  • LOGMGR_QUEUE
  • LOGMGR_RESERVE_APPEND
  • LOWFAIL_MEMMGR_QUEUE
  • METADATA_LAZYCACHE_RWLOCK
  • MIRROR_SEND_MESSAGE
  • MSQL_DQ
  • MSQL_SYNC_PIPE
  • MSQL_XACT_MGR_MUTEX
  • MSQL_XACT_MUTEX
  • MSQL_XP
  • MSSEARCH
  • NET_WAITFOR_PACKET
  • NODE_CACHE_MUTEX
  • OLEDB
  • PARALLEL_BACKUP_QUEUE
  • PERFORMANCE_COUNTERS_RWLOCK
  • PLACEHOLDER1
  • PLACEHOLDER2
  • PRINT_ROLLBACK_PROGRESS
  • QNMANAGER_ACQUIRE
  • 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_HISTORYCACHE_ACCESS
  • REPL_SCHEMA_ACCESS
  • REPL_TRANHASHTABLE_ACCESS
  • REPLICA_WRITES
  • REQUEST_DISPENSER_PAUSE
  • RESMGR_THROTTLED
  • RFS_MSGPUMP
  • RFS_NOTIFYTHREAD
  • RFS_STARTUP
  • RG_RECONFIG
  • SEC_DROP_TEMP_KEY
  • SECURITY_MUTEX
  • SEQUENTIAL_GUID
  • SERVER_IDLE_CHECK
  • SHUTDOWN
  • SNI_CRITICAL_SECTION
  • SNI_HTTP_ACCEPT
  • 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_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_LOCK
  • SQLTRACE_SHUTDOWN
  • SQLTRACE_WAIT_ENTRIES
  • SRVPROC_SHUTDOWN
  • TIMEPRIV_TIMEPERIOD
  • TRACE_EVTNOTIF
  • TRACEWRITE
  • TRANSACTION_MUTEX
  • UTIL_PAGE_ALLOC
  • VIA_ACCEPT
  • VIEW_DEFINITION_MUTEX
  • WAIT_FOR_RESULTS
  • WAITFOR
  • WAITFOR_TASKSHUTDOWN
  • WAITSTAT_MUTEX
  • WCC
  • WORKTBL_DROP
  • WRITE_COMPLETION
  • XACT_OWN_TRANSACTION
  • XACT_RECLAIM_SESSION
  • XACTLOCKINFO
  • XACTWORKSPACE_MUTEX

 

SQL  Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
  • No labels