SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

G. FritcheySQL Server 2022 Query Performance Tuninghttps://doi.org/10.1007/978-1-4842-8891-7_13

13. Parameter-Sensitive Queries: Causes and Solutions

Grant Fritchey¹  

(1)

Grafton, MA, USA

 

Stored procedures and prepared statements can use parameters as placeholders for values. The optimizer can use the values in the parameter when the plans compile to get specific statistics, commonly known as parameter sniffing. Most of the time, this enhances performance. However, some queries suffer poor performance because they are very sensitive to exactly which values are used to create the plan. These are known as parameter-sensitive queries. Dealing with these queries ...