Stored Procedures, Parameters, Problems…

Presented by Kimberly L. Tripp
Founder, SQLSkills.com

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

Download the recording

KimberlyTripp

Kimberly L. Tripp
SQLskills.com

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
SentryOne

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.