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 ...

Get SQL Server 2016 Developer's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.