© 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 Laar1 
(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 ...

Get Pro SQL Server 2019 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.