Mastering Query Store
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!
Session Type: Breakouts – 75 mins (60 mins + 15 mins Q&A) – Slides + Demos
Track: Data Administration
Level: AdvancedBook Now Learn More About Training Classes