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_12

12. Background and Miscellaneous Wait Types

Thomas LaRock¹   and Enrico van de Laar²

(1)

East Longmeadow, MA, USA

(2)

Drachten, The Netherlands

 

SQL Server has different internal processes, and so far we have discussed quite a few of them. Some of these internal processes are constantly running inside SQL Server, waiting until there is work for them to do. While these processes, frequently called background processes, are waiting for work to arrive, SQL Server will record the time they are waiting for work as specific wait types related to these background ...