Xact_reclaim_session Occurs while waiting for the current owner of a session to release ownership of the session.
For more information, including details of lock type compatibility, see.
Hadr_filestream_block_flush The filestream Always On transport manager is waiting until processing of a log block is finished., Applies to : SQL Server 2012 through SQL Server 2017.
Preemptive_lockmonitor TBD preemptive_MSS_release TBD preemptive_odbcops TBD preemptive_OLE_uninit TBD TBD preemptive_oledb_aborttran TBD preemptive_oledb_getdatasource TBD TBD preemptive_oledb_getproperties TBD TBD preemptive_oledb_getschemalock TBD TBD preemptive_oledb_release TBD preemptive_oledb_setproperties TBD preemptive_oledbops TBD TBD TBD TBD preemptive_OS_authorizationops TBD TBD TBD TBD preemptive_OS_backupread TBD preemptive_OS_closehandle TBD preemptive_OS_clusterops TBD preemptive_OS_comops TBD TBD preemptive_OS_copyfile TBD.
Tran_marklatch_EX Occurs when waiting for an exclusive mode latch on a marked transaction.Wait_XTP_serial_recovery TBD applies TO : SQL Server 2017 through current.Dbmirror_events_queue Occurs when database mirroring waits for events to process.Waitfor Occurs as a result of a waitfor Transact-SQL statement.Request_FOR_deadlock_search Occurs while the deadlock monitor waits to start the next deadlock search.If this mutex is not released, all new memory-using queries will stop responding.IO_completion Occurs while waiting for I/O operations to complete.First, the worker will wait for the MS DTC recovery process to start.Therefore, other transactions, including those with X locks on a table, continue to run while a query is being compiled.Sqltrace_buffer_flush Occurs when a task speech communication human and machine pdf is waiting for a background task to flush trace buffers to disk every four seconds.
Http_storage_connection TBD Applies to : SQL Server 2014 through SQL Server 2017.
XE_package_lock_backoff Identified for informational purposes only.
Sqltrace_wait_entries Occurs while a SQL Trace event queue waits for packets to arrive on the queue.
Queries on top of _os_waiting_tasks use deadlock_enum_mutex.CLR_task_start Occurs while waiting for a CLR task to complete startup.QRY_profile_list_mutex TBD applies TO : SQL Server 2016 through SQL Server 2017.QDS_stmt TBD Applies to : SQL Server 2014 through SQL Server 2017.Hadr_AR_critical_section_entry Occurs when an Always On DDL statement or Windows Server Failover Clustering command is waiting for exclusive read/write access to the runtime state of the local replica of the associated availability group., Applies to : SQL Server 2012 through SQL Server 2017.LCK_M_U_LOW_priority Occurs when a task is waiting to acquire an Update lock with Low Priority.MD_agent_yield TBD Applies to : SQL Server 2012 through SQL Server 2017.A good value is less than one second.SOS_memory_usage_adjustment Occurs when memory usage is being adjusted among pools.