Stored Procedures, Parameters, Problems…

There’s never been a SQL Server database where Kimberly didn’t see problems with stored procedure parameters. It’s so common that a name has been given specifically to the problem: parameter sniffing problems. But, what is parameter sniffing? Are there ways around it? What are the pros and cons? Can you detect that it’s happening? 

Download this special training session as Kimberly discusses:

  • How stored procedure caching works
  • The potential for performance problems due to parameter sniffing
  • Ways to help your developers test and code for these problems proactively

After you've registered and watched part 1, check out part 2 and see how SentryOne can help you solve these problems. 


SQL Skills logo


Interested in additional SentryOne webinars?  Check our webinar library.

Available On Demand

Kimberly L. Tripp

Kimberly L. Tripp


Kimberly (@KimberlyLTripp)  is a SQL Server MVP and a Microsoft Regional Director and has worked with computers since 1985. Since 1995, Kimberly has worked as a Speaker, Writer, Trainer and Consultant for her own company SQLskills.com, which she now runs with her husband, Paul Randal. Kimberly and Paul enjoy the ability to work together on different types of projects, from Immersion Events to consulting to speaking at conferences to writing articles and books.

Kimberly has presented lectures and seminars at Microsoft Tech*Ed, SQL Connections, PASS Summit, and other SQL Server-related events since 1996 and is consistently top-rated both on quality of technical content and presentation style. Kimberly helps customers tackle their availability and performance problems as well as design and architect appropriate solutions.

Aaron Bertrand

Aaron Bertrand


Aaron (@AaronBertrand) is a Product Manager at SentryOne, with industry experience dating back to Classic ASP and SQL Server 6.5. He is editor-in-chief of the performance-related blog, SQLPerformance.com, and serves as a community moderator for the Database Administrators Stack Exchange.

Companies with the highest demands for database performance choose SentryOne