Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| sql_handle | varbinary | 64 | null |
|
|
|||
| statement_start_offset | int | 4 | null |
|
|
|||
| statement_end_offset | int | 4 | null |
|
|
|||
| plan_generation_num | bigint | 8 | √ | null |
|
|
||
| plan_handle | varbinary | 64 | null |
|
|
|||
| creation_time | datetime | 16,3 | √ | null |
|
|
||
| last_execution_time | datetime | 16,3 | √ | null |
|
|
||
| execution_count | bigint | 8 | null |
|
|
|||
| total_worker_time | bigint | 8 | null |
|
|
|||
| last_worker_time | bigint | 8 | null |
|
|
|||
| min_worker_time | bigint | 8 | null |
|
|
|||
| max_worker_time | bigint | 8 | null |
|
|
|||
| total_physical_reads | bigint | 8 | null |
|
|
|||
| last_physical_reads | bigint | 8 | null |
|
|
|||
| min_physical_reads | bigint | 8 | null |
|
|
|||
| max_physical_reads | bigint | 8 | null |
|
|
|||
| total_logical_writes | bigint | 8 | null |
|
|
|||
| last_logical_writes | bigint | 8 | null |
|
|
|||
| min_logical_writes | bigint | 8 | null |
|
|
|||
| max_logical_writes | bigint | 8 | null |
|
|
|||
| total_logical_reads | bigint | 8 | null |
|
|
|||
| last_logical_reads | bigint | 8 | null |
|
|
|||
| min_logical_reads | bigint | 8 | null |
|
|
|||
| max_logical_reads | bigint | 8 | null |
|
|
|||
| total_clr_time | bigint | 8 | null |
|
|
|||
| last_clr_time | bigint | 8 | null |
|
|
|||
| min_clr_time | bigint | 8 | null |
|
|
|||
| max_clr_time | bigint | 8 | null |
|
|
|||
| total_elapsed_time | bigint | 8 | null |
|
|
|||
| last_elapsed_time | bigint | 8 | null |
|
|
|||
| min_elapsed_time | bigint | 8 | null |
|
|
|||
| max_elapsed_time | bigint | 8 | null |
|
|
|||
| query_hash | binary | 8 | √ | null |
|
|
||
| query_plan_hash | binary | 8 | √ | null |
|
|
||
| total_rows | bigint | 8 | √ | null |
|
|
||
| last_rows | bigint | 8 | √ | null |
|
|
||
| min_rows | bigint | 8 | √ | null |
|
|
||
| max_rows | bigint | 8 | √ | null |
|
|
||
| statement_sql_handle | varbinary | 64 | √ | null |
|
|
||
| statement_context_id | bigint | 8 | √ | null |
|
|
||
| total_dop | bigint | 8 | √ | null |
|
|
||
| last_dop | bigint | 8 | √ | null |
|
|
||
| min_dop | bigint | 8 | √ | null |
|
|
||
| max_dop | bigint | 8 | √ | null |
|
|
||
| total_grant_kb | bigint | 8 | √ | null |
|
|
||
| last_grant_kb | bigint | 8 | √ | null |
|
|
||
| min_grant_kb | bigint | 8 | √ | null |
|
|
||
| max_grant_kb | bigint | 8 | √ | null |
|
|
||
| total_used_grant_kb | bigint | 8 | √ | null |
|
|
||
| last_used_grant_kb | bigint | 8 | √ | null |
|
|
||
| min_used_grant_kb | bigint | 8 | √ | null |
|
|
||
| max_used_grant_kb | bigint | 8 | √ | null |
|
|
||
| total_ideal_grant_kb | bigint | 8 | √ | null |
|
|
||
| last_ideal_grant_kb | bigint | 8 | √ | null |
|
|
||
| min_ideal_grant_kb | bigint | 8 | √ | null |
|
|
||
| max_ideal_grant_kb | bigint | 8 | √ | null |
|
|
||
| total_reserved_threads | bigint | 8 | √ | null |
|
|
||
| last_reserved_threads | bigint | 8 | √ | null |
|
|
||
| min_reserved_threads | bigint | 8 | √ | null |
|
|
||
| max_reserved_threads | bigint | 8 | √ | null |
|
|
||
| total_used_threads | bigint | 8 | √ | null |
|
|
||
| last_used_threads | bigint | 8 | √ | null |
|
|
||
| min_used_threads | bigint | 8 | √ | null |
|
|
||
| max_used_threads | bigint | 8 | √ | null |
|
|
||
| total_columnstore_segment_reads | bigint | 8 | √ | null |
|
|
||
| last_columnstore_segment_reads | bigint | 8 | √ | null |
|
|
||
| min_columnstore_segment_reads | bigint | 8 | √ | null |
|
|
||
| max_columnstore_segment_reads | bigint | 8 | √ | null |
|
|
||
| total_columnstore_segment_skips | bigint | 8 | √ | null |
|
|
||
| last_columnstore_segment_skips | bigint | 8 | √ | null |
|
|
||
| min_columnstore_segment_skips | bigint | 8 | √ | null |
|
|
||
| max_columnstore_segment_skips | bigint | 8 | √ | null |
|
|
||
| total_spills | bigint | 8 | √ | null |
|
|
||
| last_spills | bigint | 8 | √ | null |
|
|
||
| min_spills | bigint | 8 | √ | null |
|
|
||
| max_spills | bigint | 8 | √ | null |
|
|
||
| total_num_physical_reads | bigint | 8 | null |
|
|
|||
| last_num_physical_reads | bigint | 8 | null |
|
|
|||
| min_num_physical_reads | bigint | 8 | null |
|
|
|||
| max_num_physical_reads | bigint | 8 | null |
|
|
|||
| total_page_server_reads | bigint | 8 | null |
|
|
|||
| last_page_server_reads | bigint | 8 | null |
|
|
|||
| min_page_server_reads | bigint | 8 | null |
|
|
|||
| max_page_server_reads | bigint | 8 | null |
|
|
|||
| total_num_page_server_reads | bigint | 8 | null |
|
|
|||
| last_num_page_server_reads | bigint | 8 | null |
|
|
|||
| min_num_page_server_reads | bigint | 8 | null |
|
|
|||
| max_num_page_server_reads | bigint | 8 | null |
|
|
Relationships
Close relationships within degrees of separation
