Abstract
SQL Server Wait Statistics are an important tool you can use to analyze performance-related problems or to optimize your SQL Server’s performance. They are, however, not that well known to many database administrators or developers. I believe this has to do with their relatively complex nature, the sheer volume of the different types of Wait Statistics, and the lack of documentation for many types of Wait Statistics. Wait Statistics are also directly related to the SQL Server you are analyzing them on, which means that it is impossible to compare the Wait Statistics of Server A to the Wait Statistics of Server B, even if they had an identical hardware and database configuration. Every configuration option, from the hardware firmware level to the configuration of the SQL Server Native Client on the client computers, will have an impact on the Wait Statistics!
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). Wait Statistics Internals. In: Pro SQL Server Wait Statistics. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1139-7_1
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1139-7_1
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