Identifying and Fixing Parameter Sniffing

You swear nothing changed - but suddenly your SQL Server has ground to a halt. Queries are slow across the board. You restart the server, rebuild indexes, or update statistics, and magically the problem goes away - but what really happened, and how do you fix it faster and more permanently?

Brent Ozar will explain what parameter sniffing is, show it happening live, explain why most people fix it the wrong way, and give you options to fix it long term.

Brent Ozar

I make Microsoft SQL Server go faster.

Las Vegas, Nevada, United States


Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top