SQL Server Performance Tuning and Optimization

SQTH04 Making the SQL Query Processor Work For You


9:30am - 10:45am

Level: Intermediate

Kendal Van Dyke

Senior Program Manager, SQL Server,


This deep dive session will explore how to leverage maximum benefit from SQL Server's Intelligent Query Processing suite of features. We'll also cover how these features work with Query Store, and how to configure Query Store to work well for you (including on secondary replicas). Finally, we'll discuss what database compatibility level really means and how it affects your query performance.