In this session, we'll discuss ways to manage execution plans inside the plan cache of busy and unpredictable SQL Servers. The plan cache keeps SQL Server healthy, but all it takes is one bad execution plan to decrease server performance.
Just like gardening, keeping a database healthy requires pruning. Techniques to manage, remove, and improve execution plans will be shown. The Query Store gives us power tools for this work, but it's not the entire solution.
About The Speaker:
Arthur Daniels has worked on SQL Server for four years, spending most of his time focusing on developing queries and improving performance. He focuses on managing indexes and queries for large SQL Server databases.