Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Mastering Parameter Sniffing
Before the Class
Prerequisites
Introductions and Overview (9:21)
Download the Slide Deck and Demo Scripts
Reducing the Stench of Sniffing Problems
With Index Tuning (33:21)
With Query Hints (39:02)
With Recompile Hints (21:10)
Lab 1 Setup: Get One Plan to Work Well Enough for Most (4:29)
Lab 1: Brent's Solution (38:22)
Caching Multiple Plans with Branching
Bad Branching Causes Sniffing, Good Branching Reduces It (22:52)
Lab 2 Setup: Reducing Sniffing by Caching Multiple Plans (2:45)
Lab 2: Brent's Solution (82:03)
Monitoring Sniffing Problems with the Plan Cache
Spotting Variable Plans in the Cache (49:14)
Lower-Impact Query Store: usp_PlanCacheAutopilot (6:40)
Higher-Impact: Query Store (28:06)
Lab 3 Setup: Track Down Sniffing in Plan Cache History (2:51)
Lab 3: Brent's Solution (31:36)
How SQL Server 2019 and 2022 Tries to Reduce the Blast Radius
Memory Grant Feedback (27:52)
Adaptive Joins (15:00)
Automatic Tuning, aka Automatic Plan Regression (10:11)
The Final Lab
Lab 4 Setup and Class Recap (6:11)
Working on usp_SearchPostsByPostType (54:48)
Working on usp_RptFastestAnswers (95:26)
Working on usp_SearchPostsByLocation (40:23)
Working on usp_RptQuestionsAnsweredForUser (18:13)
Working on usp_SearchUsers (49:59)
Working on usp_RptUsersLeaderboard (14:51)
Working on usp_RptPostLeaderboard (37:22)
Working on usp_RptAvgAnswerTimeByTag (24:44)
Working on usp_DashboardFromTopUsers (28:17)
Working on usp_GetTagsForUser (12:16)
Lab 3 Setup: Track Down Sniffing in Plan Cache History
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock