Day 17 - Query Store On Prem And Azure by Deepthi Goguri

Do you face performance problems with queries generating multiple query plans? Identifying the optimal plan for these queries becomes difficult if you only depend on the plan cache. You need a history of the query plans over time to identify performance degradation, and this is where Query store can help!

If you are not familiar with Query Store and its benefits, this session is right for you! You will learn about Query Store fundamentals, monitoring performance using Query Store, how to manually force and unforce plans, automatic plan correction, things to remember while using Query Store, and the new query hint feature added recently to Azure SQL Database and available for preview.

The demos will show you how to readily test and implement Query Store and take advantage of this amazing feature SQL Server has to offer!