Abstract
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 in SQL Server. For instance, the PAGEIOLATCH_xx Wait Types are frequently related to storage, but they are not included in this chapter. The reason for this is because they are also a latch Wait Type, and I believe latch Wait Types deserve a separate chapter because of their function in SQL Server.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Electronic Supplementary Material
Below is the link to the electronic supplementary material.
Rights and permissions
Copyright information
© 2015 Enrico van de Laar
About this chapter
Cite this chapter
van de Laar, E. (2015). IO-Related Wait Types. In: Pro SQL Server Wait Statistics. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1139-7_5
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1139-7_5
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1140-3
Online ISBN: 978-1-4842-1139-7
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books