Abstract
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 directly related to performance problems, they frequently have the highest wait time and will show up at the top of the wait time list when you query the top wait types ordered by wait time.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2019 Enrico van de Laar
About this chapter
Cite this chapter
van de Laar, E. (2019). Background and Miscellaneous Wait Types. In: Pro SQL Server 2019 Wait Statistics. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-4916-1_12
Download citation
DOI: https://doi.org/10.1007/978-1-4842-4916-1_12
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-4915-4
Online ISBN: 978-1-4842-4916-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books