SQL PASS Edmonton

Welcome to Edmonton PASS!

Upcoming Events:

July 19th, 2018 at 5:30 pm  

Plan Cache performance tuning

 

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.

Location:
Canadian Western Bank Conference Centre 
Lower Concourse (Basement)
10303 Jasper Avenue NW
Edmonton, Alberta
T5J 3X6
Canada
email:edmpass.pass.org

 




 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids