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 blogs.sentryone.com/author/kevinkline. 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