Remote_data_archive_schema_DMV TBD Applies to : SQL Server 2016 through SQL Server 2017.
It does not indicate contention, but rather the duration of full-text operations.
Note: This trace flag applies to SQL Server 2016 RTM CU3, of audio editor software SQL Server 2016 SP1 and higher builds.LCK_M_RX_U Occurs when a task is waiting to acquire an Update lock on the current key value, and an Exclusive range lock between the current and previous key.FFT_store_DB TBD Applies to : SQL Server 2012 design of prestressed concrete structures by ty lin pdf through SQL Server 2017.LCK_M_S_LOW_priority Occurs when a task is waiting to acquire a Shared lock with Low Priority.Sqlsort_normmutex Occurs during internal synchronization, while initializing internal sorting structures.KTM_enlistment Identified for informational purposes only.This wait occurs on a background thread.Waitstat_mutex Occurs during synchronization of access to the collection of statistics used to populate _os_wait_stats.Filestream_workitem_queue TBD Applies to : SQL Server 2012 through SQL Server 2017.Wait_XTP_procedure_entry Occurs when a drop procedure spss 11.5 64 bit 4sh is waiting for all current executions of that procedure to complete., Applies to : SQL Server 2014 through SQL Server 2017.CLR_auto_event Occurs when a task is currently performing common language runtime (CLR) execution and is waiting for a particular autoevent to be initiated.
Scope : global only 1237 Allows the alter partition function statement to honor the current user-defined session deadlock priority instead of being the likely deadlock victim by default.
For more information, see Microsoft Support article.
Click the name of the currently-displayed subscription at the top right of the page, and choose the subscription or program you want to see.Note: If dbcc checkdb is executed using the tablock option and parallelism is disabled, tables may be locked for longer periods of time.Filestream_cache TBD Applies to : SQL Server 2012 through SQL Server 2017.Hadr_work_pool Concurrency control wait on the Always On Availability Groups background work task object., Applies to : SQL Server 2012 through SQL Server 2017.Latch_KP Occurs when waiting for a KP (keep) latch.