Pro SQL Server Wait Statistics
- 4h 51m
- Enrico van de Laar
- Apress
- 2015
Pro SQL Server Wait Statistics is a practical guide for analyzing and troubleshooting SQL Server performance using wait statistics. Whether you are new to wait statistics, or already familiar with them, this book will help you gain a deeper understanding of how wait statistics are generated and what they can mean for your SQL Server’s performance.
Besides the most common wait types, Pro SQL Server Wait Statistics goes further into the more complex and performance threatening wait types. The different wait types are categorized by their area of impact, and include CPU, IO, Lock, and many more different wait type categories. Filled with clear examples, Pro SQL Server Wait Statistics helps you gain practical knowledge of why and how specific wait times increase or decrease, and how they impact your SQL Server’s performance.
What you’ll learn
- How wait Statistics are generated by SQL Server
- Script examples for analyzing and tuning wait statistics
- How to lower, or even eliminate, wait times that hurt performance
- How to query wait statistics information from Dynamic Management Views
- How to build reliable and solid wait statistics baselines from which to detect performance issues
About the Author
Enrico van de Laar is a database technology specialist with over a decade of experience with SQL Server. Enrico works for a Dutch IT company that specializes in building IT solutions for the Dutch healthcare sector, there he is responsible for maintaining and optimizing the databases of some of the largest hospitals in the Netherlands. Enrico is also the founder of DotNine SQL Server Training, a company that specializes in Microsoft SQL Server related training.
Enrico is a SQL Server MVP and his main specializations inside SQL Server are performance tuning and database architecture.
In this Book
-
Wait Statistics Internals
-
Querying SQL Server Wait Statistics
-
Building a Solid Baseline
-
CPU-Related Wait Types
-
IO-Related Wait Types
-
Backup-Related Wait Types
-
Lock-Related Wait Types
-
Latch-Related Wait Types
-
High-Availability and Disaster-Recovery Wait Types
-
Preemptive Wait Types
-
Background and Miscellaneous Wait Types
-
In-Memory OLTP–Related Wait Types
