Pro SQL Server 2019 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server

© Enrico van de Laar 2019

Enrico van de LaarPro SQL Server 2019 Wait Statisticshttps://doi.org/10.1007/978-1-4842-4916-1_12

12. Background and Miscellaneous Wait Types

Enrico van de Laar¹ 

(1)

Drachten, The Netherlands

 

SQL Server has many different internal processes that can run into a wait of a specific wait type, 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 wait time on specific wait types related to these background processes. While these background wait types are not ...