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 |
|
|