Pro SQL Server 2019 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server

© Enrico van de Laar 2019

Enrico van de LaarPro SQL Server 2019 Wait Statisticshttps://doi.org/10.1007/978-1-4842-4916-1_6

6. IO-Related Wait Types

Enrico van de Laar¹ 

(1)

Drachten, The Netherlands

 

In this chapter we will take a look at IO-related wait types in the broadest sense of the term. I selected wait types that are related to the storage, memory, or network components of your system. One could argue that the majority of wait types will fit this category, and that is probably right, but to prevent this chapter from covering 90% of all the wait types in this book, I had to choose carefully. I consider the wait types in this chapter to have a direct relation to storage, memory, or network but to not relate directly to a functionality or concept ...