Advisor Class

Database, Server or Elastic Pool Advisor.

Variables are only populated by the server, and will be ignored when sending a request.

Inheritance

azure.mgmt.sql.models._models_py3.ProxyResource

Advisor

Constructor

Advisor(*, auto_execute_status: Optional[Union[str, azure.mgmt.sql.models._sql_management_client_enums.AutoExecuteStatus]] = None, **kwargs)

Parameters

auto_execute_status

str or AutoExecuteStatus

Required

Gets the auto-execute status (whether to let the system execute the recommendations) of this advisor. Possible values are 'Enabled' and 'Disabled'. Possible values include: "Enabled", "Disabled", "Default".

Variables

id

str

Resource ID.

name

str

Resource name.

type

str

Resource type.

kind

str

Resource kind.

location

str

Resource location.

advisor_status

str or AdvisorStatus

Gets the status of availability of this advisor to customers. Possible values are 'GA', 'PublicPreview', 'LimitedPublicPreview' and 'PrivatePreview'. Possible values include: "GA", "PublicPreview", "LimitedPublicPreview", "PrivatePreview".

auto_execute_status_inherited_from

str or AutoExecuteStatusInheritedFrom

Gets the resource from which current value of auto-execute status is inherited. Auto-execute status can be set on (and inherited from) different levels in the resource hierarchy. Possible values are 'Subscription', 'Server', 'ElasticPool', 'Database' and 'Default' (when status is not explicitly set on any level). Possible values include: "Default", "Subscription", "Server", "ElasticPool", "Database".

recommendations_status

str

Gets that status of recommendations for this advisor and reason for not having any recommendations. Possible values include, but are not limited to, 'Ok' (Recommendations available),LowActivity (not enough workload to analyze), 'DbSeemsTuned' (Database is doing well), etc.

last_checked

datetime

Gets the time when the current resource was analyzed for recommendations by this advisor.

recommended_actions

list[RecommendedAction]

Gets the recommended actions for this advisor.