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. As a latch is an internal control mechanism; the SQL engine automatically determines when to user them. Because the behavior of latches is deterministic, application decisions including schema design can affect this behavior. This lab is divided into three exercises explaining when PAGEIOLATCH, PAGELATCH and Non-Buffer latch wait types occurs.

Subscribe to Download

File Size673.90 KB
Create DateSeptember 7, 2016
Last UpdatedSeptember 12, 2016