Wait Statistics Internals
Enrico van de Laar · Apress eBooks · 2015
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! These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.