SqlAdvisorData Class

Reference

Definition

Namespace:: Azure.ResourceManager.Sql

Assembly:: Azure.ResourceManager.Sql.dll

Package:: Azure.ResourceManager.Sql v1.2.1

Package:: Azure.ResourceManager.Sql v1.3.0-beta.9

Source:: SqlAdvisorData.cs

Source:: SqlAdvisorData.cs

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

A class representing the SqlAdvisor data model. Database, Server or Elastic Pool Advisor.

public class SqlAdvisorData : Azure.ResourceManager.Models.ResourceData, System.ClientModel.Primitives.IJsonModel<Azure.ResourceManager.Sql.SqlAdvisorData>, System.ClientModel.Primitives.IPersistableModel<Azure.ResourceManager.Sql.SqlAdvisorData>

type SqlAdvisorData = class
    inherit ResourceData
    interface IJsonModel<SqlAdvisorData>
    interface IPersistableModel<SqlAdvisorData>

Public Class SqlAdvisorData
Inherits ResourceData
Implements IJsonModel(Of SqlAdvisorData), IPersistableModel(Of SqlAdvisorData)

Inheritance: Object

ResourceData
SqlAdvisorData

Implements: IJsonModel<SqlAdvisorData> IPersistableModel<SqlAdvisorData> IPersistableModel<T>

Constructors

SqlAdvisorData()

Initializes a new instance of SqlAdvisorData.

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).
Id	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}. (Inherited from ResourceData)
Kind	Resource kind.
LastCheckedOn	Gets the time when the current resource was analyzed for recommendations by this advisor.
Location	Resource location.
Name	The name of the resource. (Inherited from ResourceData)
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.
ResourceType	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts". (Inherited from ResourceData)
SystemData	Azure Resource Manager metadata containing createdBy and modifiedBy information. (Inherited from ResourceData)

Methods

JsonModelWriteCore(Utf8JsonWriter, ModelReaderWriterOptions)

(Inherited from ResourceData)

Explicit Interface Implementations

IJsonModel<SqlAdvisorData>.Create(Utf8JsonReader, ModelReaderWriterOptions)	Reads one JSON value (including objects or arrays) from the provided reader and converts it to a model.
IJsonModel<SqlAdvisorData>.Write(Utf8JsonWriter, ModelReaderWriterOptions)	Writes the model to the provided Utf8JsonWriter.
IPersistableModel<SqlAdvisorData>.Create(BinaryData, ModelReaderWriterOptions)	Converts the provided BinaryData into a model.
IPersistableModel<SqlAdvisorData>.GetFormatFromOptions(ModelReaderWriterOptions)	Gets the data interchange format (JSON, Xml, etc) that the model uses when communicating with the service.
IPersistableModel<SqlAdvisorData>.Write(ModelReaderWriterOptions)	Writes the model into a BinaryData.

Applies to

Sdílet prostřednictvím