Learn more about SQL Server tools

mssqltips logo
giveaway
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Exploring the Plan Cache to Optimize SQL Server Performance

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.



































By submitting this data you are accepting to receive newsletters, account updates and special offers about SQL Server from MSSQLTips and our sponsors. We respect your privacy and you can unsubscribe at any time.



More SQL Server Solutions











Learn more about SQL Server tools