Session Title: Getting Started with Query Store
Speaker: Deepthi Goguri
Abstract: Are you facing performance issues due to the parameter sensitive queries? Are many plans being generated for your queries and you cannot control choosing the plan best for your query? Come learn in this session how we can capture the different plans generated for those queries and decide which plan you can force for better performance using the Query Store feature. Query Store feature introduced in SQL Server 2016 and has advanced its features introducing Wait stats per Query plan and Automatic Plan correction feature in SQL Server 2017 and Azure SQL database which will force the plans and resolve the issues automatically for you. Sound’s amazing, right? Join Deepthi to know all about the Query Store feature and its advancements in detail so you can implement them to take advantage of this Awesome feature!
300+ sessions are now available on-demand from Data Platform Summit 2021 & 2020 at no cost. Browse all sessions.
Stay tuned, more learning coming your way.