Latches are light-weight synchronization constructs that are designed to protect the physical integrity of a data and not data pages in MEMORY in a similar way to how locks protect the logical consistency of rows. But can cause three type of common waits and can a performance issue.
Lets have a close look, what are these three types of Latch waits and how to resolve them.

свернуть