Along with the release of SQL server 2016 CTP 3 now comes the preview of a brand new feature for on premise databases – the Query Store. This feature enables performance monitoring and troubleshooting through the log of executed queries.
This blogpost will cover the following aspects of the Query Store feature:
- How to activate it
- Configuration options
- What information is found in the Query Store
- How to use the feature
- What’s in it for me