Hands-On-Lab: SQL Server Latches

Hello Friends,

Here is another popular lab from Hands-On-Lab library: SQL Server Latches.

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

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.