Chapter 32. Parameter sniffing: your best friend... except when it isn’t
Grant Fritchey
Lots of people have heard the phrase parameter sniffing. Usually it’s heard in conjunction with some horrific performance problem that has occurred within their system. But what most people don’t know is that parameter sniffing is a process that’s occurring all the time within your servers, and most of the time it’s helping you. Only sometimes does parameter sniffing lead to problems, but when it does create a problem, it’s a big one. My goal is to show you what parameter sniffing is and how it’s constantly helping your database applications run better. You’ll also learn how parameter sniffing can go wrong and why it happens. I’ll be able to show you several ...
Get SQL Server MVP Deep Dives, Volume 2 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
