| What do you mean by SQL Latch Contention and how we can avoid this?
When we say about SQL Latch Contention the SQL latch contention occurs when many of threads can try to acquire incompatible latches at same time. And this will happen when latches are in the same in-memory structure.
Here SQL engine decides when to use latches automatically and hence ensures memory consistency. When there is a latch contention, the SQL server tends the incompatible latch requests to wait in the queue until outstanding latch requests are completed. | | |