SQL Server Wait Types
Every SQL Server performance investigation starts with wait statistics. Browse 970 wait types with diagnostic queries, root cause analysis, and proven fix scripts.
Always On(69)
HADR_AG_MUTEXmediumHADR_AR_CRITICAL_SECTION_ENTRYmediumHADR_BACKUP_BULK_LOCKmediumHADR_BACKUP_QUEUEmediumHADR_COMPRESSED_CACHE_SYNCmediumHADR_DATABASE_FLOW_CONTROLmediumHADR_DATABASE_VERSIONING_STATEmediumHADR_DATABASE_WAIT_FOR_RESTARTmediumHADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONINGmediumHADR_DB_COMMANDmediumHADR_DB_OP_COMPLETION_SYNCmediumHADR_DB_OP_START_SYNCmediumHADR_DBSTATECHANGE_SYNCmediumHADR_FILESTREAM_BLOCK_FLUSHmediumHADR_FILESTREAM_FILE_CLOSEmediumHADR_FILESTREAM_FILE_REQUESTmediumHADR_FILESTREAM_IOMGRmediumHADR_FILESTREAM_MANAGERmediumHADR_GROUP_COMMITmediumHADR_LOGCAPTURE_SYNCmediumHADR_LOGCAPTURE_WAITlowHADR_LOGPROGRESS_SYNCmediumHADR_PARTNER_SYNCmediumHADR_RECOVERY_WAIT_FOR_CONNECTIONmediumHADR_RECOVERY_WAIT_FOR_UNDOmediumHADR_REPLICAINFO_SYNCmediumHADR_SYNC_COMMITmediumHADR_SYNCHRONIZING_THROTTLEmediumHADR_TDS_LISTENER_SYNC_PROCESSINGmediumHADR_TIMER_TASKlowHADR_TRANSPORT_DBRLISTmediumHADR_TRANSPORT_FLOW_CONTROLmediumHADR_TRANSPORT_SESSIONmediumHADR_WORK_POOLmediumHADR_WORK_QUEUElowHADR_XRF_STACK_ACCESSmediumHADR_THROTTLE_LOG_RATE_MISMATCHED_SLOmediumPWAIT_HADR_OFFLINE_COMPLETEDmediumPWAIT_HADR_ONLINE_COMPLETEDmediumPWAIT_HADR_POST_ONLINE_COMPLETEDmediumHADR_AR_MANAGER_MUTEXlowHADR_AR_UNLOAD_COMPLETEDlowHADR_ARCONTROLLER_NOTIFICATIONS_SUBSCRIBER_LISTlowHADR_CLUSAPI_CALLlowHADR_CONNECTIVITY_INFOlowHADR_DATABASE_WAIT_FOR_RECOVERYlowHADR_DBR_SUBSCRIBERlowHADR_DBR_SUBSCRIBER_FILTER_LISTlowHADR_DBSEEDINGlowHADR_DBSEEDING_LISTlowHADR_FABRIC_CALLBACKlowHADR_FILESTREAM_IOMGR_IOCOMPLETIONlowHADR_FILESTREAM_PREPROClowHADR_NOTIFICATION_DEQUEUElowHADR_NOTIFICATION_WORKER_EXCLUSIVE_ACCESSlowHADR_NOTIFICATION_WORKER_STARTUP_SYNClowHADR_NOTIFICATION_WORKER_TERMINATION_SYNClowHADR_READ_ALL_NETWORKSlowHADR_SEEDING_CANCELLATIONlowHADR_SEEDING_FILE_LISTlowHADR_SEEDING_LIMIT_BACKUPSlowHADR_SEEDING_SYNC_COMPLETIONlowHADR_SEEDING_TIMEOUT_TASKlowHADR_SEEDING_WAIT_FOR_COMPLETIONlowHADR_TDS_LISTENER_SYNClowHADR_THROTTLE_LOG_RATE_GOVERNORlowHADR_THROTTLE_LOG_RATE_LOG_SIZElowHADR_THROTTLE_LOG_RATE_SEEDINGlowHADR_THROTTLE_LOG_RATE_SEND_RECV_QUEUE_SIZElow
Background(14)
SLEEP_TASKlowSLEEP_BPOOL_FLUSHlowSLEEP_BUFFERPOOL_HELPLWlowSLEEP_DBSTARTUPmediumSLEEP_DCOMSTARTUPmediumSLEEP_MASTERDBREADYlowSLEEP_MASTERMDREADYlowSLEEP_MASTERUPGRADEDlowSLEEP_MEMORYPOOL_ALLOCATEPAGESlowSLEEP_MSDBSTARTUPmediumSLEEP_RETRY_VIRTUALALLOClowSLEEP_SYSTEMTASKlowSLEEP_TEMPDBSTARTUPmediumSLEEP_WORKSPACE_ALLOCATEPAGElow
Backup(8)
CLR(10)
CPU(1)
Database Mirroring(6)
Distributed Transactions(12)
Extended Events(22)
XE_BUFFERMGR_ALLPROCESSED_EVENTmediumXE_BUFFERMGR_FREEBUF_EVENTmediumXE_CALLBACK_LISTlowXE_CX_FILE_READlowXE_DISPATCHER_CONFIG_SESSION_LISTmediumXE_DISPATCHER_JOINmediumXE_DISPATCHER_WAITlowXE_FILE_TARGET_TVFlowXE_LIVE_TARGET_TVFlowXE_MODULEMGR_SYNClowXE_OLS_LOCKlowXE_PACKAGE_LOCK_BACKOFFlowXE_SERVICES_EVENTMANUALlowXE_SERVICES_MUTEXlowXE_SERVICES_RWLOCKlowXE_SESSION_CREATE_SYNClowXE_SESSION_FLUSHlowXE_SESSION_SYNClowXE_STM_CREATElowXE_TIMER_EVENTlowXE_TIMER_MUTEXlowXE_TIMER_TASK_DONElow
Full-Text(44)
MSSEARCHmediumFT_RESTART_CRAWLmediumFULLTEXTGATHERERmediumFT_COMPROWSET_RWLOCKlowFT_IFTS_ASYNC_WRITE_PIPElowFT_IFTS_BLOB_HASHlowFT_IFTS_CATEALOG_SOURCElowFT_IFTS_CHUNK_BUFFER_CLIENT_MANAGERlowFT_IFTS_CHUNK_BUFFER_PROTO_WORD_LISTlowFT_IFTS_COMP_DESC_MANAGERlowFT_IFTS_CONSUMER_PLUGINlowFT_IFTS_CRAWL_BATCH_LISTlowFT_IFTS_CRAWL_CHILDRENlowFT_IFTS_DOCID_INTERFACE_LISTlowFT_IFTS_DOCID_LISTlowFT_IFTS_FP_INFO_LISTlowFT_IFTS_HOST_CONTROLLERlowFT_IFTS_MASTER_MERGE_TASK_LISTlowFT_IFTS_MEMREGPOOLlowFT_IFTS_MERGE_FRAGMENT_SYNClowFT_IFTS_NOISE_WORDS_COLLECTION_CACHElowFT_IFTS_NOISE_WORDS_RESOURCElowFT_IFTS_OCCURRENCE_BUFFER_POOLlowFT_IFTS_PIPELINElowFT_IFTS_PIPELINE_LISTlowFT_IFTS_PIPELINE_MANAGERlowFT_IFTS_PROJECT_FD_INFO_MAPlowFT_IFTS_RWLOCKlowFT_IFTS_SCHEDULERlowFT_IFTS_SCHEDULER_IDLE_WAITlowFT_IFTS_SHARED_MEMORYlowFT_IFTS_SHUTDOWN_PIPElowFT_IFTS_SRCH_FD_MANAGERlowFT_IFTS_SRCH_FD_SERVICElowFT_IFTS_STOPLIST_CACHE_MANAGERlowFT_IFTS_THESAURUSlowFT_IFTS_VERSION_MANAGERlowFT_IFTS_WORK_QUEUElowFT_IFTSHC_MUTEXlowFT_IFTSISM_MUTEXlowFT_MASTER_MERGElowFT_MASTER_MERGE_COORDINATORlowFT_METADATA_MUTEXlowFT_PROPERTYLIST_CACHElow
I/O(14)
Internal(226)
AM_INDBUILD_ALLOCATIONlowAM_SCHEMAMGR_UNSHARED_CACHElowASSEMBLY_FILTER_HASHTABLElowASYNC_OP_COMPLETIONlowASYNC_OP_CONTEXT_READlowASYNC_OP_CONTEXT_WRITElowASYNC_SOCKETDUP_IOlowBLOB_METADATAlowCHANGE_TRACKING_WAITFORCHANGESlowCHECK_SCANNER_MUTEXlowCHECK_TABLES_INITIALIZATIONlowCHECK_TABLES_SINGLE_SCANlowCHECK_TABLES_THREAD_BARRIERlowCMEMPARTITIONEDlowCOMMIT_TABLElowCONNECTION_ENDPOINT_LOCKlowCOUNTRECOVERYMGRlowCREATE_DATINISERVICElowDBCC_SCALE_OUT_EXPR_CACHElowDBSEEDING_FLOWCONTROLlowDBSEEDING_OPERATIONlowDIRECTLOGCONSUMER_LISTlowDIRTY_PAGE_POLLlowDIRTY_PAGE_SYNClowDIRTY_PAGE_TABLE_LOCKlowDISPATCHER_PRIORITY_QUEUE_SEMAPHORElowDPT_ENTRY_LOCKlowDROP_DATABASE_TIMER_TASKlowDUMP_LOG_COORDINATOR_QUEUElowENABLE_EMPTY_VERSIONINGlowEXTERNAL_RG_UPDATElowEXTERNAL_SCRIPT_NETWORK_IOlowEXTERNAL_SCRIPT_PREPARE_SERVICElowEXTERNAL_SCRIPT_SHUTDOWNlowFABRIC_HADR_TRANSPORT_CONNECTIONlowFABRIC_REPLICA_CONTROLLER_LISTlowFABRIC_REPLICA_CONTROLLER_STATE_AND_CONFIGlowFABRIC_REPLICA_PUBLISHER_EVENT_PUBLISHlowFABRIC_REPLICA_PUBLISHER_SUBSCRIBER_LISTlowFABRIC_WAIT_FOR_BUILD_REPLICA_EVENT_PROCESSINGlowFEATURE_SWITCHES_UPDATElowFFT_NSO_DB_KILL_FLAGlowFFT_NSO_DB_LISTlowFFT_NSO_FCBlowFFT_NSO_FCB_FINDlowFFT_NSO_FCB_PARENTlowFFT_NSO_FCB_RELEASE_CACHED_ENTRIESlowFFT_NSO_FCB_STATElowFFT_NSO_FILEOBJECTlowFFT_NSO_TABLE_LISTlowFFT_NTFS_STORElowFFT_RECOVERYlowFFT_RSFX_COMMlowFFT_RSFX_WAIT_FOR_MEMORYlowFFT_STARTUP_SHUTDOWNlowFFT_STORE_DBlowFFT_STORE_ROWSET_LISTlowFFT_STORE_TABLElowFILE_VALIDATION_THREADSlowFILESTREAM_CACHElowFILESTREAM_CHUNKERlowFILESTREAM_CHUNKER_INITlowFILESTREAM_FCBlowFILESTREAM_FILE_OBJECTlowFILESTREAM_WORKITEM_QUEUElowFILETABLE_SHUTDOWNlowFOREIGN_REDOlowFORWARDER_TRANSITIONlowGDMA_GET_RESOURCE_OWNERlowGHOSTCLEANUP_UPDATE_STATSlowGHOSTCLEANUPSYNCMGRlowGLOBAL_QUERY_CANCELlowGLOBAL_QUERY_CLOSElowGLOBAL_QUERY_CONSUMERlowGLOBAL_QUERY_PRODUCERlowGLOBAL_TRAN_CREATElowGLOBAL_TRAN_UCS_SESSIONlowHCCO_CACHElowHK_RESTORE_FILEMAPlowHKCS_PARALLEL_MIGRATIONlowHKCS_PARALLEL_RECOVERYlowHTTP_STORAGE_CONNECTIONlowINSTANCE_LOG_RATE_GOVERNORlowIO_QUEUE_LIMITlowLOG_POOL_SCANlowLOG_RATE_GOVERNORlowLOGCAPTURE_LOGPOOLTRUNCPOINTlowLOGPOOL_CACHESIZElowLOGPOOL_CONSUMERlowLOGPOOL_CONSUMERSETlowLOGPOOL_FREEPOOLSlowLOGPOOL_MGRSETlowLOGPOOL_REPLACEMENTSETlowLOGPOOLREFCOUNTEDOBJECT_REFDONElowMD_AGENT_YIELDlowMD_LAZYCACHE_RWLOCKlowMETADATA_LAZYCACHE_RWLOCKlowMIGRATIONBUFFERlowNETWORKSXMLMGRLOADlowNODE_CACHE_MUTEXlowPERFORMANCE_COUNTERS_RWLOCKlowPHYSICAL_SEEDING_DMVlowPOOL_LOG_RATE_GOVERNORlowPRU_ROLLBACK_DEFERREDlowPWAIT_ALL_COMPONENTS_INITIALIZEDlowPWAIT_COOP_SCANlowPWAIT_DIRECTLOGCONSUMER_GETNEXTlowPWAIT_EVENT_SESSION_INIT_MUTEXlowPWAIT_FABRIC_REPLICA_CONTROLLER_DATA_LOSSlowPWAIT_HADR_ACTION_COMPLETEDlowPWAIT_HADR_FAILOVER_COMPLETEDlowPWAIT_HADR_JOINlowPWAIT_HADR_SERVER_READY_CONNECTIONSlowPWAIT_HADRSIMlowPWAIT_LOG_CONSOLIDATION_IOlowPWAIT_LOG_CONSOLIDATION_POLLlowPWAIT_PREEMPTIVE_APP_USAGE_TIMERlowPWAIT_PREEMPTIVE_AUDIT_ACCESS_WINDOWSLOGlowPWAIT_QRY_BPMEMORYlowPWAIT_REPLICA_ONLINE_INIT_MUTEXlowPWAIT_RESOURCE_SEMAPHORE_FT_PARALLEL_QUERY_SYNClowPWAIT_SBS_FILE_OPERATIONlowPWAIT_XTP_FSSTORAGE_MAINTENANCElowPWAIT_XTP_HOST_STORAGE_WAITlowQE_WARN_LIST_SYNClowQRY_PARALLEL_THREAD_MUTEXlowQRY_PROFILE_LIST_MUTEXlowQUERY_TASK_ENQUEUE_MUTEXlowRBIO_WAIT_VLFlowRECOVERY_MGR_LOCKlowREDO_THREAD_PENDING_WORKlowREDO_THREAD_SYNClowREMOTE_BLOCK_IOlowREMOTE_DATA_ARCHIVE_MIGRATION_DMVlowREMOTE_DATA_ARCHIVE_SCHEMA_DMVlowREMOTE_DATA_ARCHIVE_SCHEMA_TASK_QUEUElowRESERVED_MEMORY_ALLOCATION_EXTlowRESOURCE_GOVERNOR_IDLElowRESTORE_FILEHANDLECACHE_ENTRYLOCKlowRESTORE_FILEHANDLECACHE_LOCKlowRG_RECONFIGlowROWGROUP_OP_STATSlowROWGROUP_VERSIONlowRTDATA_LISTlowSATELLITE_CARGOlowSATELLITE_SERVICE_SETUPlowSATELLITE_TASKlowSBS_DISPATCHlowSBS_RECEIVE_TRANSPORTlowSBS_TRANSPORTlowSCAN_CHAR_HASH_ARRAY_INITIALIZATIONlowSECURITY_CNG_PROVIDER_MUTEXlowSECURITY_CRYPTO_CONTEXT_MUTEXlowSECURITY_DBE_STATE_MUTEXlowSECURITY_KEYRING_RWLOCKlowSECURITY_RULETABLE_MUTEXlowSEMPLAT_DSI_BUILDlowSEQUENCE_GENERATIONlowSERVER_RECONFIGURElowSESSION_WAIT_STATS_CHILDRENlowSHARED_DELTASTORE_CREATIONlowSLO_UPDATElowSMSYNClowSNI_CONN_DUPlowSNI_WRITE_ASYNClowSOCKETDUPLICATEQUEUE_CLEANUPlowSOS_MEMORY_TOPLEVELBLOCKALLOCATORlowSOS_WORK_DISPATCHERlowSP_PREEMPTIVE_SERVER_DIAGNOSTICS_SLEEPlowSP_SERVER_DIAGNOSTICS_BUFFER_ACCESSlowSP_SERVER_DIAGNOSTICS_INIT_MUTEXlowSP_SERVER_DIAGNOSTICS_SLEEPlowSQLTRACE_FILE_READ_IO_COMPLETIONlowSQLTRACE_FILE_WRITE_IO_COMPLETIONlowSQLTRACE_INCREMENTAL_FLUSH_SLEEPlowSQLTRACE_LOCKlowSQLTRACE_PENDING_BUFFER_WRITERSlowSTARTUP_DEPENDENCY_MANAGERlowTDS_BANDWIDTH_STATElowTDS_INITlowTDS_PROXY_CONTAINERlowTEMPORAL_BACKGROUND_PROCEED_CLEANUPlowTERMINATE_LISTENERlowTRACE_EVTNOTIFlowUCS_ENDPOINT_CHANGElowUCS_MANAGERlowUCS_MEMORY_NOTIFICATIONlowUCS_SESSION_REGISTRATIONlowUCS_TRANSPORTlowUCS_TRANSPORT_STREAM_CHANGElowVDI_CLIENT_COMPLETECOMMANDlowVDI_CLIENT_GETCOMMANDlowVDI_CLIENT_OPERATIONlowVDI_CLIENT_OTHERlowVERSIONING_COMMITTINGlowWAIT_SCRIPTDEPLOYMENT_REQUESTlowWAIT_SCRIPTDEPLOYMENT_WORKERlowWAIT_XLOGREAD_SIGNALlowWAIT_XTP_ASYNC_TX_COMPLETIONlowWAIT_XTP_CKPT_AGENT_WAKEUPlowWAIT_XTP_COMPILE_WAITlowWAIT_XTP_OFFLINE_CKPT_BEFORE_REDOlowWAIT_XTP_SERIAL_RECOVERYlowWAIT_XTP_SWITCH_TO_INACTIVElowWAITFOR_PER_QUEUElowWINDOW_AGGREGATES_MULTIPASSlowWINFAB_API_CALLlowWINFAB_REPLICA_BUILD_OPERATIONlowWINFAB_REPORT_FAULTlowXDB_CONN_DUP_HASHlowXDES_HISTORYlowXDES_OUT_OF_ORDER_LISTlowXDES_SNAPSHOTlowXDESTSVERMGRlowXIO_CREDENTIAL_MGR_RWLOCKlowXIO_CREDENTIAL_RWLOCKlowXIO_EDS_MGR_RWLOCKlowXIO_EDS_RWLOCKlowXIO_IOSTATS_BLOBLIST_RWLOCKlowXIO_IOSTATS_FCBLIST_RWLOCKlowXIO_LEASE_RENEW_MGR_RWLOCKlowXTP_HOST_DB_COLLECTIONlowXTP_HOST_LOG_ACTIVITYlowXTP_HOST_PARALLEL_RECOVERYlowXTP_PREEMPTIVE_TASKlowXTP_TRUNCATION_LSNlow
Latches(12)
Linked Server(1)
Locking(72)
LCK_M_BUmediumLCK_M_BU_ABORT_BLOCKERSmediumLCK_M_BU_LOW_PRIORITYmediumLCK_M_ISmediumLCK_M_IS_ABORT_BLOCKERSmediumLCK_M_IS_LOW_PRIORITYmediumLCK_M_IUmediumLCK_M_IU_ABORT_BLOCKERSmediumLCK_M_IU_LOW_PRIORITYmediumLCK_M_IXhighLCK_M_IX_ABORT_BLOCKERSmediumLCK_M_IX_LOW_PRIORITYmediumLCK_M_RIN_NLmediumLCK_M_RIN_NL_ABORT_BLOCKERSmediumLCK_M_RIN_NL_LOW_PRIORITYmediumLCK_M_RIN_SmediumLCK_M_RIN_S_ABORT_BLOCKERSmediumLCK_M_RIN_S_LOW_PRIORITYmediumLCK_M_RIN_UmediumLCK_M_RIN_U_ABORT_BLOCKERSmediumLCK_M_RIN_U_LOW_PRIORITYmediumLCK_M_RIN_XmediumLCK_M_RIN_X_ABORT_BLOCKERSmediumLCK_M_RIN_X_LOW_PRIORITYmediumLCK_M_RS_SmediumLCK_M_RS_S_ABORT_BLOCKERSmediumLCK_M_RS_S_LOW_PRIORITYmediumLCK_M_RS_UmediumLCK_M_RS_U_ABORT_BLOCKERSmediumLCK_M_RS_U_LOW_PRIORITYmediumLCK_M_RX_SmediumLCK_M_RX_S_ABORT_BLOCKERSmediumLCK_M_RX_S_LOW_PRIORITYmediumLCK_M_RX_UmediumLCK_M_RX_U_ABORT_BLOCKERSmediumLCK_M_RX_U_LOW_PRIORITYmediumLCK_M_RX_XmediumLCK_M_RX_X_ABORT_BLOCKERSmediumLCK_M_RX_X_LOW_PRIORITYmediumLCK_M_SmediumLCK_M_S_ABORT_BLOCKERSmediumLCK_M_S_LOW_PRIORITYmediumLCK_M_SCH_MmediumLCK_M_SCH_M_ABORT_BLOCKERSmediumLCK_M_SCH_M_LOW_PRIORITYmediumLCK_M_SCH_SmediumLCK_M_SCH_S_ABORT_BLOCKERSmediumLCK_M_SCH_S_LOW_PRIORITYmediumLCK_M_SIUmediumLCK_M_SIU_ABORT_BLOCKERSmediumLCK_M_SIU_LOW_PRIORITYmediumLCK_M_SIXmediumLCK_M_SIX_ABORT_BLOCKERSmediumLCK_M_SIX_LOW_PRIORITYmediumLCK_M_UmediumLCK_M_U_ABORT_BLOCKERSmediumLCK_M_U_LOW_PRIORITYmediumLCK_M_UIXmediumLCK_M_UIX_ABORT_BLOCKERSmediumLCK_M_UIX_LOW_PRIORITYmediumLCK_M_XhighLCK_M_X_ABORT_BLOCKERSmediumLCK_M_X_LOW_PRIORITYmediumXACTLOCKINFOmediumAUDIT_GROUPCACHE_LOCKmediumAUDIT_LOGINCACHE_LOCKmediumAUDIT_ON_DEMAND_TARGET_LOCKmediumAUDIT_XE_SESSION_MGRmediumLCK_M_S_XACTmediumLCK_M_S_XACT_MODIFYmediumLCK_M_S_XACT_READmediumPVS_CLEANUP_LOCKmedium
Memory(26)
CMEMTHREADmediumLOGBUFFERmediumRESOURCE_SEMAPHOREcriticalRESOURCE_SEMAPHORE_MUTEXmediumRESOURCE_SEMAPHORE_QUERY_COMPILEmediumTRACEWRITEmediumBUFFERPOOL_SCANmediumEE_PMOLOCKmediumLOWFAIL_MEMMGR_QUEUEmediumMEMORY_ALLOCATION_EXTmediumQRY_MEM_GRANT_INFO_MUTEXmediumRESOURCE_SEMAPHORE_SMALL_QUERYmediumSNI_LISTENER_ACCESSmediumSOS_LOCALALLOCATORLISTmediumSOS_MEMORY_USAGE_ADJUSTMENTmediumSOS_OBJECT_STORE_DESTROY_MUTEXmediumSOS_PHYS_PAGE_CACHEmediumSOS_RESERVEDMEMBLOCKLISTmediumSOS_SMALL_PAGE_ALLOCmediumSOS_VIRTUALMEMORY_LOWmediumSOSHOST_INTERNALmediumUTIL_PAGE_ALLOCmediumWAIT_XTP_GUESTmediumWAIT_XTP_RECOVERYmediumWAIT_XTP_TASK_SHUTDOWNmediumMEMORY_GRANT_UPDATElow
Network(5)
Other(135)
COMMIT_ACTmediumDAC_INITmediumDEADLOCK_ENUM_MUTEXmediumDEADLOCK_TASK_SEARCHmediumDLL_LOADING_MUTEXmediumFCB_REPLICA_READmediumFCB_REPLICA_WRITEmediumGDPRmediumLAZYWRITER_SLEEPlowMSQL_DQmediumMSSQL_XPmediumPRIVACYmediumREQUEST_FOR_DEADLOCK_SEARCHlowRESOURCE_QUEUEmediumSQLSHACKmediumSQLTRACE_FILE_BUFFERmediumSQLTRACE_SHUTDOWNmediumTEMPOBJmediumWAITFORlowWRITE_COMPLETIONmediumXACT_OWN_TRANSACTIONmediumASSEMBLY_LOADmediumBAD_PAGE_PROCESSmediumBUILTIN_HASHKEY_MUTEXmediumCHKPTmediumCLEAR_DBmediumCLRHOST_STATE_ACCESSmediumDEBUGmediumDISABLE_VERSIONINGmediumDROPTEMPmediumDUMP_LOG_COORDINATORmediumEE_SPECPROC_MAP_INITmediumENABLE_VERSIONINGmediumERROR_REPORTING_MANAGERmediumEXECUTION_PIPE_EVENT_INTERNALmediumFS_GARBAGE_COLLECTOR_SHUTDOWNmediumFS_HEADER_RWLOCKmediumFSTR_CONFIG_MUTEXmediumFSTR_CONFIG_RWLOCKmediumHTTP_ENUMERATIONmediumHTTP_STARTmediumIO_AUDIT_MUTEXmediumKSOURCE_WAKEUPmediumMSQL_XACT_MGR_MUTEXmediumMSQL_XACT_MUTEXmediumMSQL_XPmediumPRINT_ROLLBACK_PROGRESSmediumPWAIT_HADR_CHANGE_NOTIFIER_TERMINATION_SYNCmediumPWAIT_HADR_WORKITEM_COMPLETEDmediumPWAIT_MD_LOGIN_STATSmediumPWAIT_MD_RELATION_CACHEmediumPWAIT_MD_SERVER_CACHEmediumPWAIT_MD_UPGRADE_CONFIGmediumQPJOB_KILLmediumQPJOB_WAITFOR_ABORTmediumQUERY_NOTIFICATION_MGR_MUTEXmediumQUERY_NOTIFICATION_SUBSCRIPTION_MUTEXmediumQUERY_NOTIFICATION_TABLE_MGR_MUTEXmediumQUERY_OPTIMIZER_PRINT_MUTEXmediumRBIO_RG_DESTAGEmediumRBIO_RG_LOCALDESTAGEmediumRBIO_RG_REPLICAmediumRBIO_RG_STORAGEmediumRECOVER_CHANGEDBmediumRESMGR_THROTTLEDmediumSEC_DROP_TEMP_KEYmediumSECURITY_MUTEXmediumSEQUENTIAL_GUIDmediumSERVER_IDLE_CHECKmediumSHUTDOWNmediumSNI_CRITICAL_SECTIONmediumSNI_HTTP_WAITFOR_0_DISCONmediumSNI_TASK_COMPLETIONmediumSOS_CALLBACK_REMOVALmediumSOS_DISPATCHER_MUTEXmediumSOS_PROCESS_AFFINITY_MUTEXmediumSOS_STACKSTORE_INIT_MUTEXmediumSOS_SYNC_TASK_ENQUEUE_EVENTmediumSOSHOST_EVENTmediumSOSHOST_MUTEXmediumSOSHOST_RWLOCKmediumSOSHOST_SEMAPHOREmediumSOSHOST_SLEEPmediumSOSHOST_TRACELOCKmediumSOSHOST_WAITFORDONEmediumSPINLOCK_EXTmediumSQLCLR_APPDOMAINmediumSQLCLR_ASSEMBLYmediumSQLCLR_DEADLOCK_DETECTIONmediumSQLCLR_QUANTUM_PUNISHMENTmediumSQLSORT_NORMMUTEXmediumSQLSORT_SORTMUTEXmediumSRVPROC_SHUTDOWNmediumTIMEPRIV_TIMEPERIODmediumTRANSACTION_MUTEXmediumVIA_ACCEPTmediumVIEW_DEFINITION_MUTEXmediumWAIT_FOR_RESULTSmediumWAIT_ON_SYNC_STATISTICS_REFRESHmediumWAIT_XTP_CKPT_ENABLEDmediumWAIT_XTP_CKPT_STATE_LOCKmediumWAIT_XTP_PROCEDURE_ENTRYmediumWAIT_XTP_TRAN_DEPENDENCYmediumWAITSTAT_MUTEXmediumWORKTBL_DROPmediumXACT_RECLAIM_SESSIONmediumXACTWORKSPACE_MUTEXmediumXTPPROC_CACHE_ACCESSmediumXTPPROC_PARTITIONED_STACK_CREATEmediumABRlowCHECK_PRINT_RECORDlowCHECKPOINT_QUEUElowDISPATCHER_QUEUE_SEMAPHORElowDUMPTRIGGERlowFAILPOINTlowGUARDIANlowINTERNAL_TESTINGlowIOAFF_RANGE_QUEUElowKTM_ENLISTMENTlowKTM_RECOVERY_MANAGERlowKTM_RECOVERY_RESOLUTIONlowLOGGENERATIONlowMISCELLANEOUSlowONDEMAND_TASK_QUEUElowQUERY_ERRHDL_SERVICE_DONElowQUERY_NOTIFICATION_UNITTEST_MUTEXlowQUERY_TRACEOUTlowQUERY_WAIT_ERRHDL_SERVICElowSQLTRACE_WAIT_ENTRIESmediumWAIT_XTP_CKPT_CLOSElowWAIT_XTP_HOST_WAITlowWAIT_XTP_OFFLINE_CKPT_LOG_IOmediumWAIT_XTP_OFFLINE_CKPT_NEW_LOGlowWAITFOR_TASKSHUTDOWNlowWCClow
Parallelism(31)
ASYNC_DISKPOOL_LOCKmediumCXPACKEThighEXCHANGEmediumEXECSYNCmediumBMPALLOCATIONmediumBMPBUILDmediumBMPREPARTITIONmediumBMPREPLICATIONmediumBPSORTmediumCXCONSUMERmediumCXROWSET_SYNCmediumCXSYNC_CONSUMERmediumCXSYNC_PORTmediumHTBUILDmediumHTBUILD_AGGmediumHTBUILD_JOINmediumHTDELETEmediumHTDELETE_AGGmediumHTDELETE_JOINmediumHTMEMOmediumHTREINITmediumHTREPARTITIONmediumPARALLEL_BACKUP_QUEUEmediumQUERY_EXECUTION_INDEX_SORT_EVENT_OPENmediumPARALLEL_REDO_DRAIN_WORKERlowPARALLEL_REDO_FLOW_CONTROLlowPARALLEL_REDO_LOG_CACHElowPARALLEL_REDO_TRAN_LISTlowPARALLEL_REDO_TRAN_TURNlowPARALLEL_REDO_WORKER_SYNClowPARALLEL_REDO_WORKER_WAIT_WORKlow
Preemptive(200)
PREEMPTIVE_AUDIT_ACCESS_EVENTLOGmediumPREEMPTIVE_AUDIT_ACCESS_SECLOGmediumPREEMPTIVE_CLOSEBACKUPMEDIAmediumPREEMPTIVE_CLOSEBACKUPTAPEmediumPREEMPTIVE_CLOSEBACKUPVDIDEVICEmediumPREEMPTIVE_CLUSAPI_CLUSTERRESOURCECONTROLmediumPREEMPTIVE_COM_COCREATEINSTANCEmediumPREEMPTIVE_HADR_LEASE_MECHANISMmediumPREEMPTIVE_ABRlowPREEMPTIVE_COM_COGETCLASSOBJECTlowPREEMPTIVE_COM_CREATEACCESSORlowPREEMPTIVE_COM_DELETEROWSlowPREEMPTIVE_COM_GETCOMMANDTEXTlowPREEMPTIVE_COM_GETDATAlowPREEMPTIVE_COM_GETNEXTROWSlowPREEMPTIVE_COM_GETRESULTlowPREEMPTIVE_COM_GETROWSBYBOOKMARKlowPREEMPTIVE_COM_LBFLUSHlowPREEMPTIVE_COM_LBLOCKREGIONlowPREEMPTIVE_COM_LBREADATlowPREEMPTIVE_COM_LBSETSIZElowPREEMPTIVE_COM_LBSTATlowPREEMPTIVE_COM_LBUNLOCKREGIONlowPREEMPTIVE_COM_LBWRITEATlowPREEMPTIVE_COM_QUERYINTERFACElowPREEMPTIVE_COM_RELEASElowPREEMPTIVE_COM_RELEASEACCESSORlowPREEMPTIVE_COM_RELEASEROWSlowPREEMPTIVE_COM_RELEASESESSIONlowPREEMPTIVE_COM_RESTARTPOSITIONlowPREEMPTIVE_COM_SEQSTRMREADlowPREEMPTIVE_COM_SEQSTRMREADANDWRITElowPREEMPTIVE_COM_SETDATAFAILURElowPREEMPTIVE_COM_SETPARAMETERINFOlowPREEMPTIVE_COM_SETPARAMETERPROPERTIESlowPREEMPTIVE_COM_STRMLOCKREGIONlowPREEMPTIVE_COM_STRMSEEKANDREADlowPREEMPTIVE_COM_STRMSEEKANDWRITElowPREEMPTIVE_COM_STRMSETSIZElowPREEMPTIVE_COM_STRMSTATlowPREEMPTIVE_COM_STRMUNLOCKREGIONlowPREEMPTIVE_CONSOLEWRITElowPREEMPTIVE_CREATEPARAMlowPREEMPTIVE_DEBUGlowPREEMPTIVE_DFSADDLINKlowPREEMPTIVE_DFSLINKEXISTCHECKlowPREEMPTIVE_DFSLINKHEALTHCHECKlowPREEMPTIVE_DFSREMOVELINKlowPREEMPTIVE_DFSREMOVEROOTlowPREEMPTIVE_DFSROOTFOLDERCHECKlowPREEMPTIVE_DFSROOTINITlowPREEMPTIVE_DFSROOTSHARECHECKlowPREEMPTIVE_DTC_ABORTlowPREEMPTIVE_DTC_ABORTREQUESTDONElowPREEMPTIVE_DTC_BEGINTRANSACTIONlowPREEMPTIVE_DTC_COMMITREQUESTDONElowPREEMPTIVE_DTC_ENLISTlowPREEMPTIVE_DTC_PREPAREREQUESTDONElowPREEMPTIVE_FILESIZEGETlowPREEMPTIVE_FSAOLEDB_ABORTTRANSACTIONlowPREEMPTIVE_FSAOLEDB_COMMITTRANSACTIONlowPREEMPTIVE_FSAOLEDB_STARTTRANSACTIONlowPREEMPTIVE_FSRECOVER_UNCONDITIONALUNDOlowPREEMPTIVE_GETRMINFOlowPREEMPTIVE_HTTP_EVENT_WAITlowPREEMPTIVE_HTTP_REQUESTlowPREEMPTIVE_LOCKMONITORlowPREEMPTIVE_MSS_RELEASElowPREEMPTIVE_ODBCOPSlowPREEMPTIVE_OLE_UNINITlowPREEMPTIVE_OLEDB_ABORTORCOMMITTRANlowPREEMPTIVE_OLEDB_ABORTTRANlowPREEMPTIVE_OLEDB_GETDATASOURCElowPREEMPTIVE_OLEDB_GETLITERALINFOlowPREEMPTIVE_OLEDB_GETPROPERTIESlowPREEMPTIVE_OLEDB_GETPROPERTYINFOlowPREEMPTIVE_OLEDB_GETSCHEMALOCKlowPREEMPTIVE_OLEDB_JOINTRANSACTIONlowPREEMPTIVE_OLEDB_RELEASElowPREEMPTIVE_OLEDB_SETPROPERTIESlowPREEMPTIVE_OLEDBOPSlowPREEMPTIVE_OS_ACCEPTSECURITYCONTEXTlowPREEMPTIVE_OS_ACQUIRECREDENTIALSHANDLElowPREEMPTIVE_OS_AUTHENTICATIONOPSlowPREEMPTIVE_OS_AUTHORIZATIONOPSlowPREEMPTIVE_OS_AUTHZGETINFORMATIONFROMCONTEXTlowPREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSIDlowPREEMPTIVE_OS_AUTHZINITIALIZERESOURCEMANAGERlowPREEMPTIVE_OS_BACKUPREADlowPREEMPTIVE_OS_CLOSEHANDLElowPREEMPTIVE_OS_CLUSTEROPSlowPREEMPTIVE_OS_COMOPSlowPREEMPTIVE_OS_COMPLETEAUTHTOKENlowPREEMPTIVE_OS_COPYFILElowPREEMPTIVE_OS_CREATEDIRECTORYlowPREEMPTIVE_OS_CREATEFILElowPREEMPTIVE_OS_CRYPTACQUIRECONTEXTlowPREEMPTIVE_OS_CRYPTIMPORTKEYlowPREEMPTIVE_OS_CRYPTOPSlowPREEMPTIVE_OS_DECRYPTMESSAGElowPREEMPTIVE_OS_DELETEFILElowPREEMPTIVE_OS_DELETESECURITYCONTEXTlowPREEMPTIVE_OS_DEVICEIOCONTROLlowPREEMPTIVE_OS_DEVICEOPSlowPREEMPTIVE_OS_DIRSVC_NETWORKOPSlowPREEMPTIVE_OS_DISCONNECTNAMEDPIPElowPREEMPTIVE_OS_DOMAINSERVICESOPSlowPREEMPTIVE_OS_DSGETDCNAMElowPREEMPTIVE_OS_DTCOPSlowPREEMPTIVE_OS_ENCRYPTMESSAGElowPREEMPTIVE_OS_FILEOPSlowPREEMPTIVE_OS_FINDFILElowPREEMPTIVE_OS_FLUSHFILEBUFFERSlowPREEMPTIVE_OS_FORMATMESSAGElowPREEMPTIVE_OS_FREECREDENTIALSHANDLElowPREEMPTIVE_OS_FREELIBRARYlowPREEMPTIVE_OS_GENERICOPSlowPREEMPTIVE_OS_GETADDRINFOlowPREEMPTIVE_OS_GETCOMPRESSEDFILESIZElowPREEMPTIVE_OS_GETDISKFREESPACElowPREEMPTIVE_OS_GETFILEATTRIBUTESlowPREEMPTIVE_OS_GETFILESIZElowPREEMPTIVE_OS_GETFINALFILEPATHBYHANDLElowPREEMPTIVE_OS_GETLONGPATHNAMElowPREEMPTIVE_OS_GETPROCADDRESSlowPREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINTlowPREEMPTIVE_OS_GETVOLUMEPATHNAMElowPREEMPTIVE_OS_INITIALIZESECURITYCONTEXTlowPREEMPTIVE_OS_LIBRARYOPSlowPREEMPTIVE_OS_LOADLIBRARYlowPREEMPTIVE_OS_LOGONUSERlowPREEMPTIVE_OS_LOOKUPACCOUNTSIDlowPREEMPTIVE_OS_MESSAGEQUEUEOPSlowPREEMPTIVE_OS_MOVEFILElowPREEMPTIVE_OS_NETGROUPGETUSERSlowPREEMPTIVE_OS_NETLOCALGROUPGETMEMBERSlowPREEMPTIVE_OS_NETUSERGETGROUPSlowPREEMPTIVE_OS_NETUSERGETLOCALGROUPSlowPREEMPTIVE_OS_NETUSERMODALSGETlowPREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYlowPREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREElowPREEMPTIVE_OS_OPENDIRECTORYlowPREEMPTIVE_OS_PDH_WMI_INITlowPREEMPTIVE_OS_PIPEOPSlowPREEMPTIVE_OS_PROCESSOPSlowPREEMPTIVE_OS_QUERYCONTEXTATTRIBUTESlowPREEMPTIVE_OS_QUERYREGISTRYlowPREEMPTIVE_OS_QUERYSECURITYCONTEXTTOKENlowPREEMPTIVE_OS_REMOVEDIRECTORYlowPREEMPTIVE_OS_REPORTEVENTlowPREEMPTIVE_OS_REVERTTOSELFlowPREEMPTIVE_OS_RSFXDEVICEOPSlowPREEMPTIVE_OS_SECURITYOPSlowPREEMPTIVE_OS_SERVICEOPSlowPREEMPTIVE_OS_SETENDOFFILElowPREEMPTIVE_OS_SETFILEPOINTERlowPREEMPTIVE_OS_SETFILEVALIDDATAlowPREEMPTIVE_OS_SETNAMEDSECURITYINFOlowPREEMPTIVE_OS_SQLCLROPSlowPREEMPTIVE_OS_SQMLAUNCHlowPREEMPTIVE_OS_VERIFYSIGNATURElowPREEMPTIVE_OS_VERIFYTRUSTlowPREEMPTIVE_OS_VSSOPSlowPREEMPTIVE_OS_WAITFORSINGLEOBJECTlowPREEMPTIVE_OS_WINSOCKOPSlowPREEMPTIVE_OS_WRITEFILElowPREEMPTIVE_OS_WRITEFILEGATHERlowPREEMPTIVE_OS_WSASETLASTERRORlowPREEMPTIVE_REENLISTlowPREEMPTIVE_RESIZELOGlowPREEMPTIVE_ROLLFORWARDREDOlowPREEMPTIVE_ROLLFORWARDUNDOlowPREEMPTIVE_SB_STOPENDPOINTlowPREEMPTIVE_SERVER_STARTUPlowPREEMPTIVE_SETRMINFOlowPREEMPTIVE_SHAREDMEM_GETDATAlowPREEMPTIVE_SNIOPENlowPREEMPTIVE_SOSHOSTlowPREEMPTIVE_SOSTESTINGlowPREEMPTIVE_SP_SERVER_DIAGNOSTICSlowPREEMPTIVE_STARTRMlowPREEMPTIVE_STREAMFCB_CHECKPOINTlowPREEMPTIVE_STREAMFCB_RECOVERlowPREEMPTIVE_STRESSDRIVERlowPREEMPTIVE_TESTINGlowPREEMPTIVE_TRANSIMPORTlowPREEMPTIVE_UNMARSHALPROPAGATIONTOKENlowPREEMPTIVE_VSS_CREATESNAPSHOTlowPREEMPTIVE_VSS_CREATEVOLUMESNAPSHOTlowPREEMPTIVE_XE_CALLBACKEXECUTElowPREEMPTIVE_XE_CX_FILE_OPENlowPREEMPTIVE_XE_CX_HTTP_CALLlowPREEMPTIVE_XE_DISPATCHERlowPREEMPTIVE_XE_ENGINEINITlowPREEMPTIVE_XE_GETTARGETSTATElowPREEMPTIVE_XE_SESSIONCOMMITlowPREEMPTIVE_XE_TARGETFINALIZElowPREEMPTIVE_XE_TARGETINITlowPREEMPTIVE_XE_TIMERRUNlowPREEMPTIVE_XETESTINGlow
Query Store(20)
QDS_ASYNC_CHECK_CONSISTENCY_TASKlowQDS_ASYNC_PERSIST_TASKlowQDS_ASYNC_PERSIST_TASK_STARTlowQDS_ASYNC_QUEUElowQDS_BCKG_TASKlowQDS_BLOOM_FILTERlowQDS_CLEANUP_STALE_QUERIES_TASK_MAIN_LOOP_SLEEPlowQDS_CTXSlowQDS_DB_DISKlowQDS_DYN_VECTORlowQDS_EXCLUSIVE_ACCESSlowQDS_HOST_INITlowQDS_LOADDBlowQDS_PERSIST_TASK_MAIN_LOOP_SLEEPlowQDS_QDS_CAPTURE_INITlowQDS_SHUTDOWN_QUEUElowQDS_STMTlowQDS_STMT_DISKlowQDS_TASK_SHUTDOWNlowQDS_TASK_STARTlow
Replication(7)
Service Broker(20)
BROKER_CONNECTION_RECEIVE_TASKmediumBROKER_ENDPOINT_STATE_MUTEXmediumBROKER_EVENTHANDLERlowBROKER_INITmediumBROKER_MASTERSTARTmediumBROKER_RECEIVE_WAITFORlowBROKER_REGISTERALLENDPOINTSmediumBROKER_SERVICEmediumBROKER_SHUTDOWNmediumBROKER_TASK_STOPlowBROKER_TRANSMITTERlowBROKER_TO_FLUSHmediumBROKER_DISPATCHERlowBROKER_FORWARDERlowBROKER_STARTlowBROKER_TASK_SHUTDOWNlowBROKER_TASK_SUBMITlowBROKER_TRANSMISSION_OBJECTlowBROKER_TRANSMISSION_TABLElowBROKER_TRANSMISSION_WORKlow