database_query_store_options


Columns

Column Type Size Nulls Auto Default Children Parents Comments
desired_state smallint 2 null
desired_state_desc nvarchar 120 √ null
actual_state smallint 2 null
actual_state_desc nvarchar 120 √ null
readonly_reason int 4 √ null
current_storage_size_mb bigint 8 √ null
flush_interval_seconds bigint 8 √ null
interval_length_minutes bigint 8 √ null
max_storage_size_mb bigint 8 √ null
stale_query_threshold_days bigint 8 √ null
max_plans_per_query bigint 8 √ null
query_capture_mode smallint 2 null
query_capture_mode_desc nvarchar 120 √ null
capture_policy_execution_count int 4 √ null
capture_policy_total_compile_cpu_time_ms bigint 8 √ null
capture_policy_total_execution_cpu_time_ms bigint 8 √ null
capture_policy_stale_threshold_hours int 4 √ null
size_based_cleanup_mode smallint 2 null
size_based_cleanup_mode_desc nvarchar 120 √ null
wait_stats_capture_mode smallint 2 null
wait_stats_capture_mode_desc nvarchar 120 √ null
actual_state_additional_info nvarchar 8000 √ null

Relationships

Close relationships within degrees of separation