Introduction to Query Store with Tracy Baggiano

In this session, we will look at the new Query Store feature in SQL Server 2016 and 2017. 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 2016. Then in 2017, Microsoft added wait stats per query plan and Automatic Tuning capabilities. Allowing DBAs more tools to troubleshoot fires with and a way to automatically resolve issues. In this session, we will walk through the features of Query Store, so you can understand how to use them in SQL Server 2016 and 2017.

Tracy Boggiano
Tracy is a Database Administrator for Broadvine. She has spent over 20 years in IT and has been using SQL Server since 1999 and is currently certified as a MCSE Data Platform. She 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 Special Interest Group for Advanced DBA topics. She also is currently leading bring Linux content into the various virtual PASS groups.