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