RecommendedActionProperties Class

Definition

Represents the properties of an Azure SQL Advisor Recommended Ac.

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

Constructors

RecommendedActionProperties()

Initializes a new instance of the RecommendedActionProperties class.

Properties

Details

Optional. Gets additional details specific to this recommended action

ErrorDetails

Optional. Gets the error details if and why this recommended action is put to Error state.

EstimatedImpact

Optional. Gets the estimated impact info for this recommended action E.g., Estimated CPU gain, Estimated Disk Space change

ExecuteActionDuration

Optional. Gets the time taken for applying this recommended action on user resource. E.g., Time taken for index creation

ExecuteActionInitiatedBy

Optional. Gets if approval for applying this recommended action is given by User/System.

ExecuteActionInitiatedTime

Optional. Gets the time when this recommended action is approved for execution

ExecuteActionStartTime

Optional. Gets the time when system started applying this recommended action on the user resource. E.g., Index creation start time

ImplementationDetails

Optional. Gets the implementation details of this recommended action for user to apply it manually.

IsArchivedAction

Optional. Gets if this recommended action was already suggested some time ago but user chose to ignore this and System recommends again.

IsExecutableAction

Optional. Gets if this recommended action is actionable to User

IsRevertableAction

Optional. Gets if changes applied by this recommended action can be reverted by User

LastRefresh

Optional. Gets time when this Recommended Action was last refreshed.

LinkedObjects

Optional. Gets the observed/actual impact info for this recommended action E.g., Actual CPU gain, Actual Disk Space change

ObservedImpact

Optional. Gets the observed/actual impact info for this recommended action E.g., Actual CPU gain, Actual Disk Space change

RecommendationReason

Optional. Gets the reason for recommending this action. E.g., DuplicateIndex

RevertActionDuration

Optional. Gets the time taken for reverting changes of this recommended action on user resource. E.g., Time taken for dropping the created index.

RevertActionInitiatedBy

Optional. Gets if approval for reverting this recommended action is given by User/System.

RevertActionInitiatedTime

Optional. Gets the time when this recommended action is approved for revert

RevertActionStartTime

Optional. Gets the time when system started reverting changes of this recommended action on user resource. E.g., Time when Index drop is executed.

Score

Optional. Gets the impact of this recommended actions. Possible values are 1 - Low impact, 2 - Medium Impact and 3 - High Impact

State

Optional. Gets the info of the state the Recommended Action is in.

TimeSeries

Optional. Gets the time series info of metrics for this recommended action E.g., CPU time series

ValidSince

Optional. Gets the time since when this Recommended action is valid.

Applies to