Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| database_id | int | 4 | null |
|
|
|||
| object_id | int | 4 | null |
|
|
|||
| type | char | 2 | √ | null |
|
|
||
| type_desc | nvarchar | 120 | √ | null |
|
|
||
| sql_handle | varbinary | 64 | null |
|
|
|||
| plan_handle | varbinary | 64 | null |
|
|
|||
| cached_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_elapsed_time | bigint | 8 | null |
|
|
|||
| last_elapsed_time | bigint | 8 | null |
|
|
|||
| min_elapsed_time | bigint | 8 | null |
|
|
|||
| max_elapsed_time | 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
