Query Store is a new performance troubleshooting tool, fully integrated into the database engine. In my opinion, it is one of the best database engine features since 2005 and the introduction of OPTION (RECOMPILE)
. Query Store helps you to troubleshoot query performance by collecting information about queries, resource utilization, execution plans, and the other execution parameters. It is stored in a database and therefore it survives server crashes, restarts, and failovers.
Query Store does not only help you to identify issues with query executions, but also lets you easily and quickly fix or workaround problems caused by poorly chosen execution plans.
In this chapter, you will learn about the following points:
Why Query Store has been introduced
What Query Store is intended for and what it is not
Query Store Architecture
How Query Store can help you to quickly identify and solve some performance issues