Topic:
One of the most highly anticipated new features in the SQL Server 2016 release was Query Store. If you’ve ever had to drop everything to troubleshoot a sudden drop in performance, then this is a feature you want in your environment. In this session we will cover the data collected, how to use the built-in reports to find problematic queries, and walk through plan forcing in Query Store. Get ready to make troubleshooting easier with this feature that’s included in all editions of SQL Server 2016 and higher!
Speaker:
Erin Stellato, Principal Consultant SQLSkills
Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand 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 including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.