dm_exec_query_profiles


Columns

Column Type Size Nulls Auto Default Children Parents Comments
session_id smallint 2 √ null
request_id int 4 √ null
sql_handle varbinary 64 √ null
plan_handle varbinary 64 √ null
physical_operator_name nvarchar 512 √ null
node_id int 4 √ null
thread_id int 4 √ null
task_address varbinary 8 null
row_count bigint 8 √ null
rewind_count bigint 8 √ null
rebind_count bigint 8 √ null
end_of_scan_count bigint 8 √ null
estimate_row_count bigint 8 √ null
first_active_time bigint 8 √ null
last_active_time bigint 8 √ null
open_time bigint 8 √ null
first_row_time bigint 8 √ null
last_row_time bigint 8 √ null
close_time bigint 8 √ null
elapsed_time_ms bigint 8 √ null
cpu_time_ms bigint 8 √ null
database_id smallint 2 √ null
object_id int 4 √ null
index_id int 4 √ null
scan_count bigint 8 √ null
logical_read_count bigint 8 √ null
physical_read_count bigint 8 √ null
read_ahead_count bigint 8 √ null
write_page_count bigint 8 √ null
lob_logical_read_count bigint 8 √ null
lob_physical_read_count bigint 8 √ null
lob_read_ahead_count bigint 8 √ null
segment_read_count int 4 √ null
segment_skip_count int 4 √ null
actual_read_row_count bigint 8 √ null
estimated_read_row_count bigint 8 √ null
page_server_read_count bigint 8 √ null
page_server_read_ahead_count bigint 8 √ null
lob_page_server_read_count bigint 8 √ null
lob_page_server_read_ahead_count bigint 8 √ null

Relationships

Close relationships within degrees of separation