Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

T. LaRock, E. van de LaarPro SQL Server 2022 Wait Statisticshttps://doi.org/10.1007/978-1-4842-8771-2_9

9. Latch-Related Wait Types

Thomas LaRock¹   and Enrico van de Laar²

(1)

East Longmeadow, MA, USA

(2)

Drachten, The Netherlands

 

In Chapter 8, “Lock-Related Wait Types,” we reviewed locking and blocking inside SQL Server, together with different wait types which indicate blocking is occurring. Latches look a lot like the locks we discussed earlier; in some cases, they appear to use the same modes as the locks discussed in Chapter 8. Make no mistake though; latches are different from locks, even though they seem to share some features. While locks are used to ...