GroupBy – Free SQL Server Training is free technical training by the community, for the community. Volunteer speakers submit abstracts at and you – the attendee – vote to pick the sessions. Want to present your own session or just vote on others? Join us at
RSS Feed
GroupBy – Free SQL Server Training

All Episodes
Now displaying: Page 1
May 2, 2017

With the release of SQL Server 2016, we were finally able to play with, in my opinion, one of the most exciting new features in SQL Server 2016, the Query Store!

The Query Store serves as a flight recorder for your query workload and provides valuable insights into the performance of your queries. It doesn’t stop there, however, using the performance metrics the Query Store records, we can decide which Execution Plan SQL Server should use when executing a specific query. If those two features aren’t enough, the Query Store provides all this information inside easy-to-use reports and Dynamic Management Views (DMVs) removing a great deal of the complexity of query performance analysis.

During this session, we will take a thorough look at the Query Store, its architecture, the performance impact of enabling the Query Store, DMVs, the built-in reporting and the custom Query Store Dashboard.

No matter if you are a DBA or developer, the Query Store has all the data you need to make your time analyzing query performance a whole lot more fun!