With the release of the public preview versions 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, it’s architecture, the
build-in reporting, DMVs and the performance impact of enabling the Query
Store. No matter if you are a DBA or developer, the Query Store has information
that can help you analyze performance issues or write better queries!