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.
Exercise 1: PAGEIOLATCH
Exercise 2: PAGELATCH
Exercise 3: Non-Buffer Latch
Reviews
There are no reviews yet.