AzureSqlDatabaseAdvisorModel Class

Definition

Represents an Azure Sql Database Advisor

public class AzureSqlDatabaseAdvisorModel : Microsoft.Azure.Commands.Sql.Advisor.Model.AzureSqlServerAdvisorModel
type AzureSqlDatabaseAdvisorModel = class
    inherit AzureSqlServerAdvisorModel
Public Class AzureSqlDatabaseAdvisorModel
Inherits AzureSqlServerAdvisorModel
Inheritance
AzureSqlDatabaseAdvisorModel

Constructors

AzureSqlDatabaseAdvisorModel()

Default Constructor

AzureSqlDatabaseAdvisorModel(String, String, String, Advisor)

Construct AzureSqlDatabaseAdvisorModel from Management.Sql.LegacySdk.Models.Advisor object

Properties

AdvisorName

Gets or sets the name of the advisor.

(Inherited from AzureSqlServerAdvisorModel)
AdvisorStatus

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

(Inherited from AdvisorProperties)
AutoExecuteStatus

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

(Inherited from AdvisorProperties)
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).

(Inherited from AdvisorProperties)
DatabaseName

Gets or sets the name of the database

LastChecked

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

(Inherited from AdvisorProperties)
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.

(Inherited from AdvisorProperties)
RecommendedActions

Optional. Gets the recommended actions for this advisor.

(Inherited from AdvisorProperties)
ResourceGroupName

Gets or sets the name of the resource group

(Inherited from AzureSqlServerAdvisorModel)
ServerName

Gets or sets the name of the server

(Inherited from AzureSqlServerAdvisorModel)

Applies to