From the course: Microsoft SQL Server 2019 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

SQL Server's Query Store

SQL Server's Query Store - SQL Server Tutorial

From the course: Microsoft SQL Server 2019 Essential Training

Start my 1-month free trial

SQL Server's Query Store

“

- [Narrator} The Query Store is a relatively new feature in SQL Server, having been added in 2016. And it helps database administrators monitor the performance of queries over time. It does this by storing query performance data and execution information in tables stored on the primary filegroup of the database being queried. These tables will contain information on query execution plans, memory and CPU resource utilization, execution time, and other execution parameters. By saving this information over time, it can be reviewed in order to identify how performance changes over time, and to potentially roll a query back to a more efficient execution plan should the need arise. When a query is executed, the execution plan is initially stored in memory. By default, after a period of about 15 minutes, that collected execution data is flushed to the Query Store tables on disk in order to preserve it. The interval is configurable, but storing plan data does come with a performance hit to…

Contents