dm_db_tuning_recommendations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
name nvarchar 8000 √ null
type nvarchar 8000 √ null
reason nvarchar 8000 √ null
valid_since datetime2 16,7 √ null
last_refresh datetime2 16,7 √ null
state nvarchar 8000 √ null
is_executable_action bit 1 √ null
is_revertable_action bit 1 √ null
execute_action_start_time datetime2 16,7 √ null
execute_action_duration time 12,7 √ null
execute_action_initiated_by nvarchar 8000 √ null
execute_action_initiated_time datetime2 16,7 √ null
revert_action_start_time datetime2 16,7 √ null
revert_action_duration time 12,7 √ null
revert_action_initiated_by nvarchar 8000 √ null
revert_action_initiated_time datetime2 16,7 √ null
score int 4 √ null
details nvarchar 2147483647 √ null

Relationships

Close relationships within degrees of separation