Identifying & Fixing Performance Issues Caused by Parameter Sniffing
Fix slow database queries! Learn to diagnose and resolve parameter sniffing issues for improved performance. Troubleshooting tips & solutions included.
Course Content
Identifying & Fixing Performance Issues Caused by Parameter Sniffing is an intermediate-level Pluralsight course taught by Gail Shaw. It runs 1h 28m, is taught in English, and includes a certificate of completion. Learners rate it 4.7 out of 5 from 52 reviews. It is a paid course, first published June 2024.
Understanding and resolving parameter sniffing issues is crucial for maintaining optimal SQL Server performance. This course, "Identifying & Fixing Performance Issues Caused by Parameter Sniffing," provides a comprehensive guide to diagnosing and correcting erratic query behavior in your SQL Server databases.
You'll begin by exploring how the SQL Server query optimizer generates execution plans and uncovering the fundamental reasons behind bad parameter sniffing. Learn to pinpoint problematic instances of parameter sniffing using powerful tools:
- Dynamic Management Views (DMVs): Leverage DMVs for real-time monitoring and analysis.
- Extended Events: Set up Extended Events sessions to capture detailed sniffing information.
- Query Store: Utilize the Query Store to track query plan history and identify sniffing problems.
Finally, you'll discover four effective strategies for fixing parameter sniffing problems, including techniques to ensure consistent query plan execution.
By completing this course, you'll gain the skills necessary to proactively address and resolve erratic query performance in your SQL Server production environments.
Software Requirement: SQL Server 2012 or later.
Hire the developers behind TutorialSearch.io
We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.