Background and Miscellaneous Wait Types
Enrico van de Laar · Apress eBooks · 2015
SQL Server has many different internal processes that can run into a wait that results in 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. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.