mssqltips logo

Exploring the Plan Cache to Optimize SQL Server Performance

(this is an on-demand video)

Sponsored by - IDERA

Webcast Abstract

Reusing compiled query plans is a key part of getting great performance. This session is about discovering how plans are cached and then looking into the cache to see which plans are used a lot (perhaps worth tuning those more), which are rarely used, and which plans are being compiled over and over again because the query is written in a way that keeps the optimizer from matching it to an existing plan. We'll look at how to evict a single plan from cache, talk about plan guides as a way to force the plan you want into cache, and do a brief look at the Query Store that was added in SQL 2016.

After this session you (or your DBA) will want to run a few queries to see what your plan cache looks like and you'll find some interesting stuff in the results!

Speaker - Andy Warren

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.




More SQL Server Solutions












download





get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools