title: "sys.query_store_query (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/29/2016" ms.prod: sql ms.prod_service: "database-engine, sql-database" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology: system-objects ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
- "QUERY_STORE_QUERY"
- "SYS.QUERY_STORE_QUERY_TSQL"
- "SYS.QUERY_STORE_QUERY"
- "QUERY_STORE_QUERY_TSQL" dev_langs:
- "TSQL" helpviewer_keywords:
- "query_store_query catalog view"
- "sys.query_store_query catalog view" ms.assetid: bdee149e-7556-4fc3-8242-925dd4b7b6ac caps.latest.revision: 15 author: edmacauley ms.author: edmaca manager: craigg monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEtsql-appliesto-ss2016-asdb-xxxx-xxx-md]
Contains information about the query and its associated overall aggregated runtime execution statistics.
| Column name | Data type | Description |
|---|---|---|
| query_id | bigint | Primary key. |
| query_text_id | bigint | Foreign key. Joins to sys.query_store_query_text (Transact-SQL) |
| context_settings_id | bigint | Foreign key. Joins to sys.query_context_settings (Transact-SQL). |
| object_id | bigint | ID of the database object that the query is part of (stored procedure, trigger, CLR UDF/UDAgg, etc.). 0 if the query is not executed as part of a database object (ad-hoc query). |
| batch_sql_handle | varbinary(64) | ID of the statement batch the query is part of. Populated only if query references temporary tables or table variables. |
| query_hash | binary(8) | MD5 hash of the individual query, based on the logical query tree. Includes optimizer hints. |
| is_internal_query | bit | The query was generated internally. |
| query_parameterization_type | tinyint | Kind of parameterization: 0 – None 1 – User 2 – Simple 3 – Forced |
| query_parameterization_type_desc | nvarchar(60) | Textual description for the parameterization type. |
| initial_compile_start_time | datetimeoffset | Compile start time. |
| last_compile_start_time | datetimeoffset | Compile start time. |
| last_execution_time | datetimeoffset | Last execution time refers to the last end time of the query/plan. |
| last_compile_batch_sql_handle | varbinary(64) | Handle of the last SQL batch in which query was used last time. It can be provided as input to sys.dm_exec_sql_text (Transact-SQL) to get the full text of the batch. |
| last_compile_batch_offset_start | bigint | Information that can be provided to sys.dm_exec_sql_text along with last_compile_batch_sql_handle. |
| last_compile_batch_offset_end | bigint | Information that can be provided to sys.dm_exec_sql_text along with last_compile_batch_sql_handle. |
| count_compiles | bigint | Compilation statistics. |
| avg_compile_duration | float | Compilation statistics in microseconds. |
| last_compile_duration | bigint | Compilation statistics in microseconds. |
| avg_bind_duration | float | Binding statistics in microseconds. |
| last_bind_duration | bigint | Binding statistics. |
| avg_bind_cpu_time | float | Binding statistics. |
| last_bind_cpu_time | bigint | Binding statistics. |
| avg_optimize_duration | float | Optimization statistics in microseconds. |
| last_optimize_duration | bigint | Optimization statistics. |
| avg_optimize_cpu_time | float | Optimization statistics in microseconds. |
| last_optimize_cpu_time | bigint | Optimization statistics. |
| avg_compile_memory_kb | float | Compile memory statistics. |
| last_compile_memory_kb | bigint | Compile memory statistics. |
| max_compile_memory_kb | bigint | Compile memory statistics. |
| is_clouddb_internal_query | bit | Always 0 in [!INCLUDEssNoVersion] on-premises. |
Requires the VIEW DATABASE STATE permission.
sys.database_query_store_options (Transact-SQL)
sys.query_context_settings (Transact-SQL)
sys.query_store_plan (Transact-SQL)
sys.query_store_query_text (Transact-SQL)
sys.query_store_wait_stats (Transact-SQL)
sys.query_store_runtime_stats (Transact-SQL)
sys.query_store_runtime_stats_interval (Transact-SQL)
Monitoring Performance By Using the Query Store
Catalog Views (Transact-SQL)
Query Store Stored Procedures (Transact-SQL)
sys.fn_stmt_sql_handle_from_sql_stmt (Transact-SQL)