Mastering Server Tuning

Is it a database problem? Query problem? Hardware problem? Find out and fix it.

Created by Brent Ozar

Mastering

Course Description

You’re the kind of DBA or senior database developer who’s constantly facing new performance challenges on different servers. Good news – I’ll teach you how in this 12-hour recorded class.

The class will take you longer to complete because it includes lab assignments that will take you hours to work through, and my students tell me they love doing these labs again and again. They're kinda like SQL Server video games! To follow along, you'll need to build your own SQL Server lab VM.

This is not a live class - if you want to attend live, check out my Live Class Season Pass.

Want to save a bundle? This class is included in my Recorded Class Season Pass: Mastering bundle.

Course Curriculum

  Before the Class
Available in days
days after you enroll
  How to Measure a SQL Server's Performance
Available in days
days after you enroll
  How to Fix PAGEIOLATCH Waits
Available in days
days after you enroll
  How to Fix SOS_SCHEDULER_YIELD Waits
Available in days
days after you enroll
  How to Fix Misleading Waits
Available in days
days after you enroll
  How to Fix LCK% Waits
Available in days
days after you enroll
  How to Fix Poison Waits
Available in days
days after you enroll
  The Architecture Lab
Available in days
days after you enroll
  Bonus: How to Triage Performance Emergencies
Available in days
days after you enroll
  Bonus: Off-Topic Storytelling Time
Available in days
days after you enroll