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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.