Learning all about the SQL Server Plan Cache

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:

  1. Situations that cause 'bloat' in the plan cache;
  2. Scenarios that cause the SQL Server optimizer to choose a suboptimal plan;
  3. Problems with parameter sniffing; and,
  4. 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? =^)

Many thanks,
-Kevin

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.


Comments

Sentryone Monitoring Platform Trial