Mastering Parameter Sniffing

All the tools to help troubleshoot & fix sniffing issues for good.

Created by Brent Ozar

Mastering

Course Description

You’ve conquered Fundamentals of Parameter Sniffing, and now you need to master all the different ways to mitigate parameter sniffing problems for good. I’ll show you in 3 days of nonstop demos in this recorded class. (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
  Reducing the Blast Radius of Sniffing Problems
Available in days
days after you enroll
  Caching Multiple Plans with Branching
Available in days
days after you enroll
  Monitoring Sniffing Problems with the Plan Cache
Available in days
days after you enroll
  Monitoring Sniffing Problems with Query Store
Available in days
days after you enroll
  How SQL Server 2019 Tries to Reduce the Blast Radius
Available in days
days after you enroll
  The Final Lab
Available in days
days after you enroll