Skip to content

Plan Cache performance tuning

Photo of EDMPASS
Hosted By
EDMPASS
Plan Cache performance tuning

Details

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.

Photo of Edmonton Microsoft Data Professionals group
Edmonton Microsoft Data Professionals
See more events