SQL Server Administration and Maintenance

SQW11 Welcome to the 2016 Query Store!


4:00pm - 5:15pm

Level: Intermediate

Janis Griffin

Database Performance Evangelist


A favorite new feature in SQL Server 2016 is the Query Store. The Query Store houses valuable information on performance of your queries as well as gives you great insights into your query workload. This session will look into the Query Store, how it works, the type information it holds and how you can use it to analyze performance issues. You'll be introduced to new DMVs and the performance impact of enabling the Query Store. Both DBAs and developers can increase their performance tuning skills by attending this session.

You will learn:

  • What the Query Store is and how it works
  • To identify and report the performance information from several new DMVs
  • How to find the best execution plan in the Query Store and make sure that SQL Server uses it