Avoiding Stored Procedure Recompilations

Embed code for this video

Copy the code above to embed our video on your website/blog.

Close

Video format

Note: These selections will fall back to the next best format depending upon browser capability.

Close

Download

Right click “Save as…”

In this session, Greg describe the process by which SQL Server executes stored procedures and how it decides whether or not recompilations are necessary. He discusses how to monitor recompilations and explains in detail the specific triggers that cause recompilation. Greg then discusses techniques to be used when writing database code to help avoid the need for recompilations and to help keep systems performing well.

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.