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 works as a multi-hatted DBA for TicketCity.com 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.
- Capitol Area Central Texas Users of SQL Server 81 Recordings
- MS SQL 20 Recordings