Fundamentals of Server Tuning with Wait Stats

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

When you’re done with this course, you’re ready for Mastering Server Tuning.

Your Progress So Far in This Class

This is driven by the mark-as-complete buttons in each module of the class. (Let’s be honest: you’re probably just going to mark them as complete because you’re that kind of student. I feel you.)