** IDPA-Des Moines will meet virtually in May 2021. There will be no meeting in-person until it is safe again after COVID-19 **

Join us at 17:30 CDT/22:30 UTC (aka 5:30 PM in Des Moines, IA) for social discussion, networking, etc. A technical presentation by Deepthi Goguri will follow at 18:00 CDT/23:00 UTC (6:00 PM)

“Don't try it, Own it – Query Store feature on your Servers!”

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!

Speaker Biodata:

Deepthi is a SQL Server Database Administrator with several years of experience in Administering SQL Servers. She is a Microsoft certified trainer and Microsoft certified professional with an Associate and Expert level Certification on Data Management and Analytics. Deepthi blogs for DBANuggets.com.

Deepthi is a Co-Organizer for Microsoft Data and AI South Florida user group and Data Platform Diversity, Equity, and Inclusion Virtual Group. She is a Volunteer for Data platform Women in Technology user group. She is a Friend of Redgate. Along with this, Deepthi loves arts and crafts.
You can contact her on Twitter @dbanuggets.