Query Store is a new SQL Server 2016 component that collects execution plans and runtime statistics for the queries in the system. It helps you to detect suboptimal queries, shows how execution plans evolve over time, and allows you to force specific plans in order to address parameter sniffing–related issues.
This chapter provides an overview of the Query Store, explains how it is integrated into the query processing pipeline, and demonstrates how you can use it during system monitoring and performance troubleshooting.
Why Query Store?
Even though every database system is unique, there are ...