Dec 02
2-11-16: Stored Procedure Optimization with Kimberly Tripp

Topic for the February 2016 Meeting:


Stored Procedure Optimization Techniques

Kimberly Tripp will discuss stored procedure caching and the potential for performance problems due to a problem known as parameter sniffing. There are some common solutions and while they can drastically improve performance, they can also cause other problems. Sometimes a hybrid solution is needs, from this session, you'll know the best way to write procedures so that stable requests are cached and unstable requests are not (giving you the most optimal performance without wasting resources).

This event has ended.  See below for slides, code download, and on demand recording.


About Kimberly Tripp (President and Founder of
KimberlyTripp.jpgKimberly has been a Microsoft SQL Server MVP and a Microsoft Regional Director for over 10 years; she's an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world. She has over 20 years of experience designing and tuning SQL Server solutions with a focus on optimizing procedural code, indexing strategies, statistics, and partitioning. When she's not tuning SQL servers, she's diving and photographing all sorts of underwater critters such as frogfish with her husband, Paul S. Randal.


Full Bio:
SQL Server MVP since 2002

 Click here to download Kimberly's slides and code samples:

Watch now on YouTube!