Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse in SQL Server 2016. Then in 2017, Microsoft added wait stats per query plan and Automatic Plan Correction capabilities. This allows DBAs more tools to troubleshoot fires with and a way to automatically resolve issues.

In this Geek Sync, Tracy Boggiano will walk through the features of the Query Store, so you can understand how to use them in SQL Server 2016, 2017, and 2019.

Speaker: Tracy Boggiano is a Senior Database Administrator for DocuSIgn. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as an MCSE Data Platform. Tracy has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC. Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com. Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.

Topics: Database Performance, Database Administration, Database Monitoring
Products: SQL Diagnostic Manager for SQL Server