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.

EDMPASS

Edmonton Microsoft Data Professionals

Azure Data Tech Groups

Microsoft

Robert Half

Science & Education

Personal Development

Intellectual Discussions

Education & Technology

E-Learning

Learning

Plan Cache performance tuning

Canadian Western Bank Conference Centre

Share

Edmonton Microsoft Data Professionals

Plan Cache performance tuning

Edmonton Microsoft Data Professionals

Details

Sponsors

Members are also interested in