The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.

Event Display
Meeting Detail

Tue, Feb 07 2017 11:00 UTC


"Answering the Question, “What Happened?” with QUERY STORE"

RSVP: https://attendee.gotowebinar.com/register/3814088566924133891

ANSWERING THE QUESTION, “WHAT HAPPENED?” WITH QUERY STORE

One of the most highly anticipated new features in the SQL Server 2016 release is Query Store. It's been referred to as the "flight recorder" for SQL Server because it tracks query information, namely plans and runtime statistics. If you've ever had to stop everything and try to troubleshoot a sudden drop in performance, then you've probably already realized the value of this feature. In this session we'll explore the Query Store feature using the latest CTP of SQL Server 2016. We'll review the different options for Query Store, look at examples of what gets collected, dig through the included reports, and see how you can force SQL Server to use a specific plan for a query.


Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 17 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery. Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids