LATCH_DT Description Latches are used to guarantee consistency of non-buffer pool memory structures. The latch processed will be in destruction mode, meaning the pages will transition from being allocated to being free. Note that high values in this wait do not always mean a problem (e.g. in the case of parallelism) Resolved by DBAs and Developers Suggested solutions If this wait is experienced further details will need to be retrieved from sys.dm_os_latch_stats If parallelism is a common latch wait consider optimizing heavy parallel queries via indexing Additional research Most common latch classes and what they mean Diagnosing and Resolving Latch Contention on SQL Server See more Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics ⇐ Back to index
