Network Management
LATCH_EX SQL Wait Type
This content will describe SQL Server wait type that can be encountered more or less commonly, which includes the description, steps that should be taken, and additional resources that could be used for troubleshooting.
First published date
11/3/2021 2:59 AM
Last published date
11/3/2021 2:59 AM
Overview
Description:
Latches are used to guarantee consistency of non-buffer pool memory structures. This wait type is for when the request requires exclusive access to an object. Note that high values in this wait do not always mean a problem (e.g. in the case of parallelism)
Latches are used to guarantee consistency of non-buffer pool memory structures. This wait type is for when the request requires exclusive access to an object. Note that high values in this wait do not always mean a problem (e.g. in the case of parallelism)
Product section
Network Performance Monitor
Resolution
Suggested Solution:
The content posted herein are provided as a suggestion or recommendation to you for your internal use. The information set forth herein may come from third party website or customers. SolarWinds is not liable for any downtime or any issue that may occur if you perform the following suggestions on the link provided. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.
- 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
The content posted herein are provided as a suggestion or recommendation to you for your internal use. The information set forth herein may come from third party website or customers. SolarWinds is not liable for any downtime or any issue that may occur if you perform the following suggestions on the link provided. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.