Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| runtime_stats_id | bigint | 8 | null |
|
|
|||
| plan_id | bigint | 8 | null |
|
|
|||
| runtime_stats_interval_id | bigint | 8 | null |
|
|
|||
| execution_type | tinyint | 1 | null |
|
|
|||
| execution_type_desc | nvarchar | 120 | √ | null |
|
|
||
| first_execution_time | datetimeoffset | 20,7 | null |
|
|
|||
| last_execution_time | datetimeoffset | 20,7 | null |
|
|
|||
| count_executions | bigint | 8 | null |
|
|
|||
| avg_duration | float | 8 | √ | null |
|
|
||
| last_duration | bigint | 8 | null |
|
|
|||
| min_duration | bigint | 8 | null |
|
|
|||
| max_duration | bigint | 8 | null |
|
|
|||
| stdev_duration | float | 8 | √ | null |
|
|
||
| avg_cpu_time | float | 8 | √ | null |
|
|
||
| last_cpu_time | bigint | 8 | null |
|
|
|||
| min_cpu_time | bigint | 8 | null |
|
|
|||
| max_cpu_time | bigint | 8 | null |
|
|
|||
| stdev_cpu_time | float | 8 | √ | null |
|
|
||
| avg_logical_io_reads | float | 8 | √ | null |
|
|
||
| last_logical_io_reads | bigint | 8 | null |
|
|
|||
| min_logical_io_reads | bigint | 8 | null |
|
|
|||
| max_logical_io_reads | bigint | 8 | null |
|
|
|||
| stdev_logical_io_reads | float | 8 | √ | null |
|
|
||
| avg_logical_io_writes | float | 8 | √ | null |
|
|
||
| last_logical_io_writes | bigint | 8 | null |
|
|
|||
| min_logical_io_writes | bigint | 8 | null |
|
|
|||
| max_logical_io_writes | bigint | 8 | null |
|
|
|||
| stdev_logical_io_writes | float | 8 | √ | null |
|
|
||
| avg_physical_io_reads | float | 8 | √ | null |
|
|
||
| last_physical_io_reads | bigint | 8 | null |
|
|
|||
| min_physical_io_reads | bigint | 8 | null |
|
|
|||
| max_physical_io_reads | bigint | 8 | null |
|
|
|||
| stdev_physical_io_reads | float | 8 | √ | null |
|
|
||
| avg_clr_time | float | 8 | √ | null |
|
|
||
| last_clr_time | bigint | 8 | null |
|
|
|||
| min_clr_time | bigint | 8 | null |
|
|
|||
| max_clr_time | bigint | 8 | null |
|
|
|||
| stdev_clr_time | float | 8 | √ | null |
|
|
||
| avg_dop | float | 8 | √ | null |
|
|
||
| last_dop | bigint | 8 | null |
|
|
|||
| min_dop | bigint | 8 | null |
|
|
|||
| max_dop | bigint | 8 | null |
|
|
|||
| stdev_dop | float | 8 | √ | null |
|
|
||
| avg_query_max_used_memory | float | 8 | √ | null |
|
|
||
| last_query_max_used_memory | bigint | 8 | null |
|
|
|||
| min_query_max_used_memory | bigint | 8 | null |
|
|
|||
| max_query_max_used_memory | bigint | 8 | null |
|
|
|||
| stdev_query_max_used_memory | float | 8 | √ | null |
|
|
||
| avg_rowcount | float | 8 | √ | null |
|
|
||
| last_rowcount | bigint | 8 | null |
|
|
|||
| min_rowcount | bigint | 8 | null |
|
|
|||
| max_rowcount | bigint | 8 | null |
|
|
|||
| stdev_rowcount | float | 8 | √ | null |
|
|
||
| avg_num_physical_io_reads | float | 8 | √ | null |
|
|
||
| last_num_physical_io_reads | bigint | 8 | √ | null |
|
|
||
| min_num_physical_io_reads | bigint | 8 | √ | null |
|
|
||
| max_num_physical_io_reads | bigint | 8 | √ | null |
|
|
||
| stdev_num_physical_io_reads | float | 8 | √ | null |
|
|
||
| avg_log_bytes_used | float | 8 | √ | null |
|
|
||
| last_log_bytes_used | bigint | 8 | √ | null |
|
|
||
| min_log_bytes_used | bigint | 8 | √ | null |
|
|
||
| max_log_bytes_used | bigint | 8 | √ | null |
|
|
||
| stdev_log_bytes_used | float | 8 | √ | null |
|
|
||
| avg_tempdb_space_used | float | 8 | √ | null |
|
|
||
| last_tempdb_space_used | bigint | 8 | √ | null |
|
|
||
| min_tempdb_space_used | bigint | 8 | √ | null |
|
|
||
| max_tempdb_space_used | bigint | 8 | √ | null |
|
|
||
| stdev_tempdb_space_used | float | 8 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
