Webcast : Exploring the Plan Cache to Optimize SQL Server Performance

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(s): Andy Warren is a SQL Server consultant based in Orlando. Andy was a founding principal of SQLServerCentral.com, is the former President of the Orlando SQL Server Users Group, and one of the founders of SQLSaturday. He has been an MVP since 2009 and has written and presented extensively SQL Server. Andy blogs at www.sqlandy.com, is on LinkedIn at www.linkedin.com/in/sqlandy, and is occasionally on Twitter as @SQLAndy.

Topics : Database Diagnostics,Database Monitoring,Database Performance,SQL Query Performance,

Products : SQL Diagnostic Manager for SQL Server,

Register for Free Webcast

Note: By registering, you confirm that you agree to the processing of your personal data by Idera, Inc. as described in the Privacy Statement.
Idera, Inc. is part of the Idera group and may share your information with its parent company Idera, Inc., and its affiliates. For further details on how your data is used, stored, and shared, please review our Privacy Statement.