CHAPTER 11

image

Background and Miscellaneous Wait Types

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 ...

Get Pro SQL Server Wait Statistics now with O’Reilly online learning.

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