Chapter 9. Query Store
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 ...