Parameter Sniffing the Good, the Bad, and the Ugly


Parameter sniffing is something that more than often helps performance on your servers; however, there are times when it can hinder performance as well. In this session we will define exactly what parameter sniffing is, and examine when it is good and when it is bad. Lastly, we will explore the different options available to fix bad parameter sniffing. After this session, you will be able to locate and fix bad parameter sniffing when it occurs on your servers.


  • Lance Tidwell

    2 Recordings

    Lance Tidwell works as a multi-hatted DBA for for the last 10 years in Austin,TX. Where he has had to work on many sides of the database from development to creating backup/restore strategies as well as performance tuning.

Recorded At:

Recorded on:

Oct 18, 2016

More Info: