O'Reilly logo

SQL Server MVP Deep Dives Vol. 2 by Kimberly Tripp, Paul Randal, Paul Nielsen, Brad McGehee, Greg Low, Louis Davidson, Kalen Delaney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required