Parameter Sniffing the Good, the Bad and the Ugly

Lance Tidwell
60 minutes
Database Administration
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.
Should have a basic understanding of execution plans.

Accompanying Material

No material found.

Back to Top cage-aids