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:
After you've registered and watched part 1, check out part 2 and see how SentryOne can help you solve these problems.
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
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 (@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.