Learning all about the SQL Server Plan Cache
Published On: November 16, 2015
Categories: Execution Plans, Performance, Plan Explorer, Query Plan Analysis, Slide Decks 2
Get the Slides and T-SQL Scripts Shown in the Webcast
In case you didn't know, I've been doing a series of webinars on the topic of SQL query tuning, approximately once every two weeks. In these webinars, I go very heavy on the demos and, in all but the most recent webinar, eschew slides entirely.
The latest episode, broadcast live on Tuesday 10-Nov-2015, went in-depth into the SQL Server plan cache, the area of SQL Server memory reserved for handling T-SQL code and related objects. Since the topic was more elaborate and abstract than the three previous episodes, I wrote a supplementary slide deck along with the usual boatload of demos. We covered four main topics in the webinar:
- Situations that cause 'bloat' in the plan cache;
- Scenarios that cause the SQL Server optimizer to choose a suboptimal plan;
- Problems with parameter sniffing; and,
- Causes for inappropriate recompiles.
Click the hyperlink below to download the slides and T-SQL scripts:
If you'd like to watch the video, please check out the SentryOne Resource Library, where we have lots of videos covering a variety of performance troubleshooting and query tuning topics, including this webinar, and the three previous webinars in the series.
Register for an Upcoming Webinar Today!
If you have a moment, go ahead and register for my upcoming session on our Webinars page. I hope to see you at a future session! For that matter, if you are experiencing difficulties with your SQL tuning projects, let me know! We could end up discussing your issue on a future episode of SQL Query Tuning Mastery. Hey, free consulting, right? =^)
Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at SentryOne. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.