Share via


AdvisorProperties Class

Definition

Represents the properties of an Azure SQL Server/Database/Elastic Pool Advisor.

public class AdvisorProperties
type AdvisorProperties = class
Public Class AdvisorProperties
Inheritance
AdvisorProperties
Derived

Constructors

AdvisorProperties()

Initializes a new instance of the AdvisorProperties class.

Properties

AdvisorStatus

Optional. Gets the current the status of this advisor. Possible values are 'GA', 'PublicPreview', 'LimitedPublicPreview' and 'PrivatePreview'.

AutoExecuteStatus

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

AutoExecuteStatusInheritedFrom

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

LastChecked

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

RecommendationsStatus

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

RecommendedActions

Optional. Gets the recommended actions for this advisor.

Applies to