Advisor interface

Package:

@azure/arm-sql

Database, Server or Elastic Pool Advisor.

Extends

ProxyResource

Properties

advisorStatus	Gets the status of availability of this advisor to customers. Possible values are 'GA', 'PublicPreview', 'LimitedPublicPreview' and 'PrivatePreview'. NOTE: This property will not be serialized. It can only be populated by the server.
autoExecuteStatus	Gets the auto-execute status (whether to let the system execute the recommendations) of this advisor. Possible values are 'Enabled' and 'Disabled'
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). NOTE: This property will not be serialized. It can only be populated by the server.
kind	Resource kind. NOTE: This property will not be serialized. It can only be populated by the server.
lastChecked	Gets the time when the current resource was analyzed for recommendations by this advisor. NOTE: This property will not be serialized. It can only be populated by the server.
location	Resource location. NOTE: This property will not be serialized. It can only be populated by the server.
recommendationsStatus	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. NOTE: This property will not be serialized. It can only be populated by the server.
recommendedActions	Gets the recommended actions for this advisor. NOTE: This property will not be serialized. It can only be populated by the server.

Inherited Properties

id	Resource ID. NOTE: This property will not be serialized. It can only be populated by the server.
name	Resource name. NOTE: This property will not be serialized. It can only be populated by the server.
type	Resource type. NOTE: This property will not be serialized. It can only be populated by the server.

Property Details

advisorStatus

Gets the status of availability of this advisor to customers. Possible values are 'GA', 'PublicPreview', 'LimitedPublicPreview' and 'PrivatePreview'. NOTE: This property will not be serialized. It can only be populated by the server.

advisorStatus?: AdvisorStatus

Property Value

AdvisorStatus

autoExecuteStatus

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

autoExecuteStatus?: AutoExecuteStatus

Property Value

AutoExecuteStatus

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). NOTE: This property will not be serialized. It can only be populated by the server.

autoExecuteStatusInheritedFrom?: AutoExecuteStatusInheritedFrom

Property Value

AutoExecuteStatusInheritedFrom

kind

Resource kind. NOTE: This property will not be serialized. It can only be populated by the server.

kind?: string

Property Value

string

lastChecked

Gets the time when the current resource was analyzed for recommendations by this advisor. NOTE: This property will not be serialized. It can only be populated by the server.

lastChecked?: Date

Property Value

Date

location

Resource location. NOTE: This property will not be serialized. It can only be populated by the server.

location?: string

Property Value

string

recommendationsStatus

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. NOTE: This property will not be serialized. It can only be populated by the server.

recommendationsStatus?: string

Property Value

string

recommendedActions

Gets the recommended actions for this advisor. NOTE: This property will not be serialized. It can only be populated by the server.

recommendedActions?: RecommendedAction[]

Property Value

RecommendedAction[]

Inherited Property Details

id

Resource ID. NOTE: This property will not be serialized. It can only be populated by the server.

id?: string

Property Value

string

Inherited From ProxyResource.id

name

Resource name. NOTE: This property will not be serialized. It can only be populated by the server.

name?: string

Property Value

string

Inherited From ProxyResource.name

type

Resource type. NOTE: This property will not be serialized. It can only be populated by the server.

type?: string

Property Value

string

Inherited From ProxyResource.type