Query Store in Action!
Details
Agenda
• 13:00-13:15 - Opening, Announcements, and More...
• 13:15-14:15 - Query Store in Action!
• 14:15-14:30 - Q&A and Open Discussion
Session: Query Store in Action! – Deepthi Goguri (60 Minutes, English)
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!
Query Store in Action!