Whenever SQL Server runs queries, it tracks the bottlenecks it’s waiting on.
This data is tracked in wait statistics, also known as wait stats, and it’s viewable in several different spots in SQL Server.
In this class, you’ll learn:
- How to measure your SQL Server
- What the most common wait types are
- Whether a wait can be fixed with query tuning, index tuning, or hardware