Advertisement

Query Store

  • Dmitri Korotkevitch
Chapter

Abstract

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.

Keywords

Execution Plan Query Execution Store Internal Execution Statistic Context Setting 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Dmitri Korotkevitch 2016

Authors and Affiliations

  • Dmitri Korotkevitch
    • 1
  1. 1.TampaUSA

Personalised recommendations