DBAs and developers that are interested in analyzing query performance.
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 build-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!
Why I Want to Present This Session:
I absolutely love the Query Store feature and I believe it is THE feature that makes performance analysis and tuning available for everyone working with SQL Server.