| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|
SQL Server, Query Store object |
Learn about the Query Store object, which provides counters to monitor resource usage of SQL Server to store query texts, execution plans and runtime stats. |
MikeRayMSFT |
mikeray |
12/04/2023 |
sql |
performance |
reference |
|
[!INCLUDE SQL Server 2016]
The Query Store object provides counters to monitor resource utilization of [!INCLUDE ssNoVersion] to store query texts, execution plans, and runtime stats for objects such as stored procedures, ad hoc and prepared [!INCLUDE tsql] statements, and triggers.
This table describes are the SQLServer:Query Store counters.
| SQL Server Query Store counters | Description |
|---|---|
| Query Store CPU usage | Execution time of Query Store operations expressed in hundredths of seconds. |
| Query Store logical reads | Number of physical read operations from Query Store. |
| Query Store logical writes | Number of logical write operations from Query Store. The frequency and delay of adding items (that represent runtime stats) to the queue is controlled by Data Flush Interval setting. |
| Query Store physical reads | Number of physical read operations from Query Store. |
Each counter in the object contains the following instances:
| Query Store instance | Description |
|---|---|
| _Total | Information for the Query Store for this instance of [!INCLUDE ssNoVersion]. |
| <database name> | Query Store information for this database. |
You begin to explore the query performance counters in this object using this T-SQL query on the sys.dm_os_performance_counters dynamic management view:
SELECT * FROM sys.dm_os_performance_counters
WHERE object_name LIKE '%Query Store%';