The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.

Event Display
Meeting Detail

Tue, Feb 21 2017 11:00 (UTC-06:00) Central Time (US & Canada)


Stored Procedure Optimization Techniques

RSVP: https://attendee.gotowebinar.com/register/2847423232720898561

Stored Procedure Optimization Techniques

Kimberly 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). Kimberly 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). Kimberly Tripp


Kimberly L. Tripp is the founder/co-owner (with her husband, Paul Randal) of SQLskills.com, a world-renowned training and consulting company. She worked for Microsoft University and on the SQL Server team in the early 1990s but left to consult in 1995. Since then, she has been training, consulting, and speaking on a number of SQL Server areas with performance tuning, VLDBs, and optimization her most common topics. Kimberly is an accomplished writer and presenter with numerous top-speaker awards over the years; she is also a SQL Server MVP. You can read more at SQLskills.com. In her free time, and with her husband, Paul Randal, she likes diving, searching for critters, and underwater photography!

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids