What is Parameter Sniffing, and how does it affect performance?

Quick Answer SQL Server caches a procedure's plan based on the parameter values from the first compilation. If those values were unusual (e.g., a rare customer ID), the plan is optimized for that case. When typical values run later, they use a plan that's wrong for them. Symptoms: same procedure runs fast sometimes, slow other times.