AI, Data Science & Cloud Certificates from Google, IBM & Meta — 50% Off
One plan covers every Professional Certificate on Coursera. 50% off Coursera Plus Annual for 10 days only — price increases June 17.
Unlock All Certificates
Bad parameter sniffing is a common cause of erratic performance in SQL Server databases. In Identifying & Fixing Performance Issues Caused by Parameter Sniffing, you'll learn how to detect and fix parameter sniffing problems in your production environments. First you'll see how the query optimizer generates plans and discover what the root cause of bad parameter sniffing is. Next you'll learn how to detect instances of bad parameter sniffing using DMVs, Extended Events and the Query Store. Finally, you'll learn four options for fixing bad parameter sniffing. When you're finished this course, you'll be well positioned to tackle erratic query performance in production SQL Server environments. Software required: SQL Server 2012 or later.
