Latch Coupling in SQL Server

Years ago I blogged about Latches and why they are needed by SQL Server. In today’s blog post I want to concentrate a little bit more on the Buffer Latches (BUF), and how they are used by SQL Server during Index Seek Operations. Here you will learn a concept called Latch Coupling. Index Seek Operations …

Latch Coupling in SQL Server + read more