Autoplay
Autocomplete
Speed
Previous Lecture
Complete and Continue
Mastering Parameter Sniffing
Before the Class
Prerequisites
Introductions and Overview (15:15)
Download the Slide Deck and Demo Scripts
Reducing the Blast Radius of Sniffing Problems
With Index Tuning (44:34)
With Query Hints (38:56)
With Recompile Hints (26:20)
Lab 1 Setup: Get One Plan to Work Well Enough for Most (4:58)
Lab 1: Brent's Solution (38:03)
Caching Multiple Plans with Branching
Bad Branching Causes Sniffing, Good Branching Reduces It (34:18)
Lab 2 Setup: Fix a Parameter Sniffing Problem with Branching (2:51)
Lab 2: Brent's Solution (34:05)
Monitoring Sniffing Problems with the Plan Cache
Spotting Variable Plans in the Cache (29:32)
Trending the Plan Cache Over Time (35:28)
Lab 3 Setup: Track Down Sniffing in Plan Cache History (9:40)
Lab 3: Brent's Solution (27:32)
Monitoring Sniffing Problems with Query Store
Lower-Impact Query Store: usp_PlanCacheAutopilot (18:41)
Higher-Impact: Query Store (32:04)
Lab 4 Setup: Track Down Sniffing with Query Store or usp_PlanCacheAutopilot (2:41)
Lab 4: Brent's Solution (24:10)
How SQL Server 2019 Tries to Reduce the Blast Radius
Memory Grant Feedback (30:02)
Adaptive Joins (18:03)
Automatic Tuning, aka Automatic Plan Regression (13:02)
The Final Lab
Lab 5 Setup and Class Recap (4:35)
Working on usp_SearchPostsByPostType (38:53)
Working on usp_RptFastestAnswers (88:00)
Working on usp_SearchPostsByLocation (40:23)
Working on usp_RptQuestionsAnsweredForUser (18:13)
Working on usp_SearchUsers (49:59)
Automatic Tuning, aka Automatic Plan Regression
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock