SQL Server Latches

/, SQL Server/SQL Server Latches
Sale!

SQL Server Latches

$15.00 $4.00

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

Categories: ,

Product Description

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.

Only logged in customers who have purchased this product may leave a review.