AdvisorProperties interface

Package:
@azure/arm-sql

Properties for a Database, Server or Elastic Pool Advisor.

Properties

advisorStatus

Gets the status of availability of this advisor to customers. Possible values are 'GA', 'PublicPreview', 'LimitedPublicPreview' and 'PrivatePreview'.
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).
lastChecked

Gets the time when the current resource was analyzed for recommendations by this advisor.
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.
recommendedActions

Gets the recommended actions for this advisor.

Property Details

advisorStatus

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

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).

autoExecuteStatusInheritedFrom?: AutoExecuteStatusInheritedFrom

Property Value

AutoExecuteStatusInheritedFrom

lastChecked

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

lastChecked?: Date

Property Value

Date

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.

recommendationsStatus?: string

Property Value

string

recommendedActions

Gets the recommended actions for this advisor.

recommendedActions?: RecommendedAction[]

Property Value

RecommendedAction[]