Answering the question, “What happened?” with Query Store - Erin Stellato

One of the most highly anticipated new features in SQL Server 2016 is Query Store. It's been referred to as the "flight recorder" for SQL Server because it tracks query information, namely query plans and runtime statistics. If you've ever had to drop everything to troubleshoot a sudden change in performance, then you've probably already realized the value of this feature.

In this session, we'll step through how Query Store works - you’ll understand what information it captures and how to access the historical data through the UI and the system views. Then, we'll look at the data collected to identify queries that don't perform well and those that have regressions in performance due to different plans. Finally, we'll see how to force a specific plan for a query, discover what happens when the optimizer cannot use that plan, and examine how plan forcing compares to using plan guides. Expect to learn how to make troubleshooting easier with this feature that’s included in all editions of SQL Server 2016!

http://photos1.meetupstatic.com/photos/event/4/0/2/3/600_457576419.jpeg

Erin Stellato works for SQLskills as a Principal Consultant and is a SQL Server MVP and lives in Cleveland, OH. She has over 16 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include statistics, performance tuning, Extended Events, and helping accidental/involuntary DBAs figure out how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences like SQLintersection and the PASS Summit. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.

Email: Erin@SQLskills.com

Website: http://www.SQLskills.com ( http://www.SQLskills.com )

Full Bio: http://www.sqlskills.com/about/erin-stellato/ ( http://www.sqlskills.com/about/erin-stellato/ )

Blog: http://www.SQLskills.com/blogs/Erin ( http://www.SQLskills.com/blogs/Erin )

Twitter: http://twitter.com/ErinStellato ( http://twitter.com/ErinStellato )

SQL Server MVP since 2012