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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.