Latches are lightweight synchronization primitives that are used by the SQL Server engine to guarantee consistency of in-memory structures including: index, data pages, and internal structures, such as non-leaf pages in a B-Tree. Latch contention occurs when multiple threads concurrently attempt to acquire incompatible latches to the same in-memory structure. Please refer to this doc to diagnose and resolve latch contention, which might be helpful.
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.