Mastering Parameter Sniffing
All the tools to help troubleshoot and fix sniffing issues for good.
Mastering
What you will get:
- Watch on any Device
- 6 sections
- lectures
- of video
Last updated: 30 Sept
Your Instructor
I make Microsoft SQL Server go faster. I've been working with SQL Server since the late 1990s, and I'm one of the rare Microsoft Certified Masters of SQL Server. I love teaching, travel, and laughing. I live in Las Vegas, Nevada.
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 Stench 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
How SQL Server 2019 and 2022 Tries to Reduce the Blast Radius
Available in
days
days
after you enroll
The Final Lab
Available in
days
days
after you enroll
- 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)