query_store_query


Columns

Column Type Size Nulls Auto Default Children Parents Comments
query_id bigint 8 null
query_text_id bigint 8 null
context_settings_id bigint 8 null
object_id bigint 8 √ null
batch_sql_handle varbinary 44 √ null
query_hash binary 8 null
is_internal_query bit 1 null
query_parameterization_type tinyint 1 null
query_parameterization_type_desc nvarchar 120 √ null
initial_compile_start_time datetimeoffset 20,7 null
last_compile_start_time datetimeoffset 20,7 √ null
last_execution_time datetimeoffset 20,7 √ null
last_compile_batch_sql_handle varbinary 44 √ null
last_compile_batch_offset_start bigint 8 √ null
last_compile_batch_offset_end bigint 8 √ null
count_compiles bigint 8 √ null
avg_compile_duration float 8 √ null
last_compile_duration bigint 8 √ null
avg_bind_duration float 8 √ null
last_bind_duration bigint 8 √ null
avg_bind_cpu_time float 8 √ null
last_bind_cpu_time bigint 8 √ null
avg_optimize_duration float 8 √ null
last_optimize_duration bigint 8 √ null
avg_optimize_cpu_time float 8 √ null
last_optimize_cpu_time bigint 8 √ null
avg_compile_memory_kb float 8 √ null
last_compile_memory_kb bigint 8 √ null
max_compile_memory_kb bigint 8 √ null
is_clouddb_internal_query bit 1 √ null

Relationships

Close relationships within degrees of separation