Azure Native

Pulumi Official
Package maintained by Pulumi
v1.67.0 published on Tuesday, Jul 12, 2022 by Pulumi

DatabaseAdvisor

Database, Server or Elastic Pool Advisor. API Version: 2020-11-01-preview.

Example Usage

Update database advisor

using Pulumi;
using AzureNative = Pulumi.AzureNative;

class MyStack : Stack
{
    public MyStack()
    {
        var databaseAdvisor = new AzureNative.Sql.DatabaseAdvisor("databaseAdvisor", new AzureNative.Sql.DatabaseAdvisorArgs
        {
            AdvisorName = "CreateIndex",
            AutoExecuteStatus = AzureNative.Sql.AutoExecuteStatus.Disabled,
            DatabaseName = "IndexAdvisor_test_3",
            ResourceGroupName = "workloadinsight-demos",
            ServerName = "misosisvr",
        });
    }

}
package main

import (
	sql "github.com/pulumi/pulumi-azure-native/sdk/go/azure/sql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewDatabaseAdvisor(ctx, "databaseAdvisor", &sql.DatabaseAdvisorArgs{
			AdvisorName:       pulumi.String("CreateIndex"),
			AutoExecuteStatus: sql.AutoExecuteStatusDisabled,
			DatabaseName:      pulumi.String("IndexAdvisor_test_3"),
			ResourceGroupName: pulumi.String("workloadinsight-demos"),
			ServerName:        pulumi.String("misosisvr"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}
package generated_program;

import java.util.*;
import java.io.*;
import java.nio.*;
import com.pulumi.*;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var databaseAdvisor = new DatabaseAdvisor("databaseAdvisor", DatabaseAdvisorArgs.builder()        
            .advisorName("CreateIndex")
            .autoExecuteStatus("Disabled")
            .databaseName("IndexAdvisor_test_3")
            .resourceGroupName("workloadinsight-demos")
            .serverName("misosisvr")
            .build());

    }
}
import pulumi
import pulumi_azure_native as azure_native

database_advisor = azure_native.sql.DatabaseAdvisor("databaseAdvisor",
    advisor_name="CreateIndex",
    auto_execute_status=azure_native.sql.AutoExecuteStatus.DISABLED,
    database_name="IndexAdvisor_test_3",
    resource_group_name="workloadinsight-demos",
    server_name="misosisvr")
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const databaseAdvisor = new azure_native.sql.DatabaseAdvisor("databaseAdvisor", {
    advisorName: "CreateIndex",
    autoExecuteStatus: azure_native.sql.AutoExecuteStatus.Disabled,
    databaseName: "IndexAdvisor_test_3",
    resourceGroupName: "workloadinsight-demos",
    serverName: "misosisvr",
});
resources:
  databaseAdvisor:
    type: azure-native:sql:DatabaseAdvisor
    properties:
      advisorName: CreateIndex
      autoExecuteStatus: Disabled
      databaseName: IndexAdvisor_test_3
      resourceGroupName: workloadinsight-demos
      serverName: misosisvr

Create a DatabaseAdvisor Resource

new DatabaseAdvisor(name: string, args: DatabaseAdvisorArgs, opts?: CustomResourceOptions);
@overload
def DatabaseAdvisor(resource_name: str,
                    opts: Optional[ResourceOptions] = None,
                    advisor_name: Optional[str] = None,
                    auto_execute_status: Optional[AutoExecuteStatus] = None,
                    database_name: Optional[str] = None,
                    resource_group_name: Optional[str] = None,
                    server_name: Optional[str] = None)
@overload
def DatabaseAdvisor(resource_name: str,
                    args: DatabaseAdvisorArgs,
                    opts: Optional[ResourceOptions] = None)
func NewDatabaseAdvisor(ctx *Context, name string, args DatabaseAdvisorArgs, opts ...ResourceOption) (*DatabaseAdvisor, error)
public DatabaseAdvisor(string name, DatabaseAdvisorArgs args, CustomResourceOptions? opts = null)
public DatabaseAdvisor(String name, DatabaseAdvisorArgs args)
public DatabaseAdvisor(String name, DatabaseAdvisorArgs args, CustomResourceOptions options)
type: azure-native:sql:DatabaseAdvisor
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

name string
The unique name of the resource.
args DatabaseAdvisorArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name str
The unique name of the resource.
args DatabaseAdvisorArgs
The arguments to resource properties.
opts ResourceOptions
Bag of options to control resource's behavior.
ctx Context
Context object for the current deployment.
name string
The unique name of the resource.
args DatabaseAdvisorArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name string
The unique name of the resource.
args DatabaseAdvisorArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name String
The unique name of the resource.
args DatabaseAdvisorArgs
The arguments to resource properties.
options CustomResourceOptions
Bag of options to control resource's behavior.

DatabaseAdvisor Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

The DatabaseAdvisor resource accepts the following input properties:

AutoExecuteStatus Pulumi.AzureNative.Sql.AutoExecuteStatus

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

DatabaseName string

The name of the database.

ResourceGroupName string

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

ServerName string

The name of the server.

AdvisorName string

The name of the Database Advisor.

AutoExecuteStatus AutoExecuteStatus

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

DatabaseName string

The name of the database.

ResourceGroupName string

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

ServerName string

The name of the server.

AdvisorName string

The name of the Database Advisor.

autoExecuteStatus AutoExecuteStatus

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

databaseName String

The name of the database.

resourceGroupName String

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

serverName String

The name of the server.

advisorName String

The name of the Database Advisor.

autoExecuteStatus AutoExecuteStatus

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

databaseName string

The name of the database.

resourceGroupName string

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

serverName string

The name of the server.

advisorName string

The name of the Database Advisor.

auto_execute_status AutoExecuteStatus

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

database_name str

The name of the database.

resource_group_name str

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

server_name str

The name of the server.

advisor_name str

The name of the Database Advisor.

autoExecuteStatus "Enabled" | "Disabled" | "Default"

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

databaseName String

The name of the database.

resourceGroupName String

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

serverName String

The name of the server.

advisorName String

The name of the Database Advisor.

Outputs

All input properties are implicitly available as output properties. Additionally, the DatabaseAdvisor resource produces the following output properties:

AdvisorStatus string

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

AutoExecuteStatusInheritedFrom string

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 string

The provider-assigned unique ID for this managed resource.

Kind string

Resource kind.

LastChecked string

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

Location string

Resource location.

Name string

Resource name.

RecommendationsStatus string

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 List<Pulumi.AzureNative.Sql.Outputs.RecommendedActionResponse>

Gets the recommended actions for this advisor.

Type string

Resource type.

AdvisorStatus string

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

AutoExecuteStatusInheritedFrom string

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 string

The provider-assigned unique ID for this managed resource.

Kind string

Resource kind.

LastChecked string

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

Location string

Resource location.

Name string

Resource name.

RecommendationsStatus string

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 []RecommendedActionResponse

Gets the recommended actions for this advisor.

Type string

Resource type.

advisorStatus String

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

autoExecuteStatusInheritedFrom String

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 String

The provider-assigned unique ID for this managed resource.

kind String

Resource kind.

lastChecked String

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

location String

Resource location.

name String

Resource name.

recommendationsStatus String

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 List<RecommendedActionResponse>

Gets the recommended actions for this advisor.

type String

Resource type.

advisorStatus string

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

autoExecuteStatusInheritedFrom string

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 string

The provider-assigned unique ID for this managed resource.

kind string

Resource kind.

lastChecked string

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

location string

Resource location.

name string

Resource name.

recommendationsStatus string

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 RecommendedActionResponse[]

Gets the recommended actions for this advisor.

type string

Resource type.

advisor_status str

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

auto_execute_status_inherited_from str

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 str

The provider-assigned unique ID for this managed resource.

kind str

Resource kind.

last_checked str

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

location str

Resource location.

name str

Resource name.

recommendations_status str

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.

recommended_actions Sequence[RecommendedActionResponse]

Gets the recommended actions for this advisor.

type str

Resource type.

advisorStatus String

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

autoExecuteStatusInheritedFrom String

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 String

The provider-assigned unique ID for this managed resource.

kind String

Resource kind.

lastChecked String

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

location String

Resource location.

name String

Resource name.

recommendationsStatus String

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 List<Property Map>

Gets the recommended actions for this advisor.

type String

Resource type.

Supporting Types

AutoExecuteStatus

Enabled
Enabled
Disabled
Disabled
Default
Default
AutoExecuteStatusEnabled
Enabled
AutoExecuteStatusDisabled
Disabled
AutoExecuteStatusDefault
Default
Enabled
Enabled
Disabled
Disabled
Default
Default
Enabled
Enabled
Disabled
Disabled
Default
Default
ENABLED
Enabled
DISABLED
Disabled
DEFAULT
Default
"Enabled"
Enabled
"Disabled"
Disabled
"Default"
Default

RecommendedActionErrorInfoResponse

ErrorCode string

Gets the reason why the recommended action was put to error state. e.g., DatabaseHasQdsOff, IndexAlreadyExists

IsRetryable string

Gets whether the error could be ignored and recommended action could be retried. Possible values are: Yes/No

ErrorCode string

Gets the reason why the recommended action was put to error state. e.g., DatabaseHasQdsOff, IndexAlreadyExists

IsRetryable string

Gets whether the error could be ignored and recommended action could be retried. Possible values are: Yes/No

errorCode String

Gets the reason why the recommended action was put to error state. e.g., DatabaseHasQdsOff, IndexAlreadyExists

isRetryable String

Gets whether the error could be ignored and recommended action could be retried. Possible values are: Yes/No

errorCode string

Gets the reason why the recommended action was put to error state. e.g., DatabaseHasQdsOff, IndexAlreadyExists

isRetryable string

Gets whether the error could be ignored and recommended action could be retried. Possible values are: Yes/No

error_code str

Gets the reason why the recommended action was put to error state. e.g., DatabaseHasQdsOff, IndexAlreadyExists

is_retryable str

Gets whether the error could be ignored and recommended action could be retried. Possible values are: Yes/No

errorCode String

Gets the reason why the recommended action was put to error state. e.g., DatabaseHasQdsOff, IndexAlreadyExists

isRetryable String

Gets whether the error could be ignored and recommended action could be retried. Possible values are: Yes/No

RecommendedActionImpactRecordResponse

AbsoluteValue double

Gets the absolute value of this dimension if applicable. e.g., Number of Queries affected

ChangeValueAbsolute double

Gets the absolute change in the value of this dimension. e.g., Absolute Disk space change in Megabytes

ChangeValueRelative double

Gets the relative change in the value of this dimension. e.g., Relative Disk space change in Percentage

DimensionName string

Gets the name of the impact dimension. e.g., CPUChange, DiskSpaceChange, NumberOfQueriesAffected.

Unit string

Gets the name of the impact dimension. e.g., CPUChange, DiskSpaceChange, NumberOfQueriesAffected.

AbsoluteValue float64

Gets the absolute value of this dimension if applicable. e.g., Number of Queries affected

ChangeValueAbsolute float64

Gets the absolute change in the value of this dimension. e.g., Absolute Disk space change in Megabytes

ChangeValueRelative float64

Gets the relative change in the value of this dimension. e.g., Relative Disk space change in Percentage

DimensionName string

Gets the name of the impact dimension. e.g., CPUChange, DiskSpaceChange, NumberOfQueriesAffected.

Unit string

Gets the name of the impact dimension. e.g., CPUChange, DiskSpaceChange, NumberOfQueriesAffected.

absoluteValue Double

Gets the absolute value of this dimension if applicable. e.g., Number of Queries affected

changeValueAbsolute Double

Gets the absolute change in the value of this dimension. e.g., Absolute Disk space change in Megabytes

changeValueRelative Double

Gets the relative change in the value of this dimension. e.g., Relative Disk space change in Percentage

dimensionName String

Gets the name of the impact dimension. e.g., CPUChange, DiskSpaceChange, NumberOfQueriesAffected.

unit String

Gets the name of the impact dimension. e.g., CPUChange, DiskSpaceChange, NumberOfQueriesAffected.

absoluteValue number

Gets the absolute value of this dimension if applicable. e.g., Number of Queries affected

changeValueAbsolute number

Gets the absolute change in the value of this dimension. e.g., Absolute Disk space change in Megabytes

changeValueRelative number

Gets the relative change in the value of this dimension. e.g., Relative Disk space change in Percentage

dimensionName string

Gets the name of the impact dimension. e.g., CPUChange, DiskSpaceChange, NumberOfQueriesAffected.

unit string

Gets the name of the impact dimension. e.g., CPUChange, DiskSpaceChange, NumberOfQueriesAffected.

absolute_value float

Gets the absolute value of this dimension if applicable. e.g., Number of Queries affected

change_value_absolute float

Gets the absolute change in the value of this dimension. e.g., Absolute Disk space change in Megabytes

change_value_relative float

Gets the relative change in the value of this dimension. e.g., Relative Disk space change in Percentage

dimension_name str

Gets the name of the impact dimension. e.g., CPUChange, DiskSpaceChange, NumberOfQueriesAffected.

unit str

Gets the name of the impact dimension. e.g., CPUChange, DiskSpaceChange, NumberOfQueriesAffected.

absoluteValue Number

Gets the absolute value of this dimension if applicable. e.g., Number of Queries affected

changeValueAbsolute Number

Gets the absolute change in the value of this dimension. e.g., Absolute Disk space change in Megabytes

changeValueRelative Number

Gets the relative change in the value of this dimension. e.g., Relative Disk space change in Percentage

dimensionName String

Gets the name of the impact dimension. e.g., CPUChange, DiskSpaceChange, NumberOfQueriesAffected.

unit String

Gets the name of the impact dimension. e.g., CPUChange, DiskSpaceChange, NumberOfQueriesAffected.

RecommendedActionImplementationInfoResponse

Method string

Gets the method in which this recommended action can be manually implemented. e.g., TSql, AzurePowerShell.

Script string

Gets the manual implementation script. e.g., T-SQL script that could be executed on the database.

Method string

Gets the method in which this recommended action can be manually implemented. e.g., TSql, AzurePowerShell.

Script string

Gets the manual implementation script. e.g., T-SQL script that could be executed on the database.

method String

Gets the method in which this recommended action can be manually implemented. e.g., TSql, AzurePowerShell.

script String

Gets the manual implementation script. e.g., T-SQL script that could be executed on the database.

method string

Gets the method in which this recommended action can be manually implemented. e.g., TSql, AzurePowerShell.

script string

Gets the manual implementation script. e.g., T-SQL script that could be executed on the database.

method str

Gets the method in which this recommended action can be manually implemented. e.g., TSql, AzurePowerShell.

script str

Gets the manual implementation script. e.g., T-SQL script that could be executed on the database.

method String

Gets the method in which this recommended action can be manually implemented. e.g., TSql, AzurePowerShell.

script String

Gets the manual implementation script. e.g., T-SQL script that could be executed on the database.

RecommendedActionMetricInfoResponse

MetricName string

Gets the name of the metric. e.g., CPU, Number of Queries.

StartTime string

Gets the start time of time interval given by this MetricInfo.

TimeGrain string

Gets the duration of time interval for the value given by this MetricInfo. e.g., PT1H (1 hour)

Unit string

Gets the unit in which metric is measured. e.g., DTU, Frequency

Value double

Gets the value of the metric in the time interval given by this MetricInfo.

MetricName string

Gets the name of the metric. e.g., CPU, Number of Queries.

StartTime string

Gets the start time of time interval given by this MetricInfo.

TimeGrain string

Gets the duration of time interval for the value given by this MetricInfo. e.g., PT1H (1 hour)

Unit string

Gets the unit in which metric is measured. e.g., DTU, Frequency

Value float64

Gets the value of the metric in the time interval given by this MetricInfo.

metricName String

Gets the name of the metric. e.g., CPU, Number of Queries.

startTime String

Gets the start time of time interval given by this MetricInfo.

timeGrain String

Gets the duration of time interval for the value given by this MetricInfo. e.g., PT1H (1 hour)

unit String

Gets the unit in which metric is measured. e.g., DTU, Frequency

value Double

Gets the value of the metric in the time interval given by this MetricInfo.

metricName string

Gets the name of the metric. e.g., CPU, Number of Queries.

startTime string

Gets the start time of time interval given by this MetricInfo.

timeGrain string

Gets the duration of time interval for the value given by this MetricInfo. e.g., PT1H (1 hour)

unit string

Gets the unit in which metric is measured. e.g., DTU, Frequency

value number

Gets the value of the metric in the time interval given by this MetricInfo.

metric_name str

Gets the name of the metric. e.g., CPU, Number of Queries.

start_time str

Gets the start time of time interval given by this MetricInfo.

time_grain str

Gets the duration of time interval for the value given by this MetricInfo. e.g., PT1H (1 hour)

unit str

Gets the unit in which metric is measured. e.g., DTU, Frequency

value float

Gets the value of the metric in the time interval given by this MetricInfo.

metricName String

Gets the name of the metric. e.g., CPU, Number of Queries.

startTime String

Gets the start time of time interval given by this MetricInfo.

timeGrain String

Gets the duration of time interval for the value given by this MetricInfo. e.g., PT1H (1 hour)

unit String

Gets the unit in which metric is measured. e.g., DTU, Frequency

value Number

Gets the value of the metric in the time interval given by this MetricInfo.

RecommendedActionResponse

Details Dictionary<string, object>

Gets additional details specific to this recommended action.

ErrorDetails Pulumi.AzureNative.Sql.Inputs.RecommendedActionErrorInfoResponse

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

EstimatedImpact List<Pulumi.AzureNative.Sql.Inputs.RecommendedActionImpactRecordResponse>

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

ExecuteActionDuration string

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

ExecuteActionInitiatedBy string

Gets if approval for applying this recommended action was given by user/system.

ExecuteActionInitiatedTime string

Gets the time when this recommended action was approved for execution.

ExecuteActionStartTime string

Gets the time when system started applying this recommended action on the user resource. e.g., index creation start time

Id string

Resource ID.

ImplementationDetails Pulumi.AzureNative.Sql.Inputs.RecommendedActionImplementationInfoResponse

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

IsArchivedAction bool

Gets if this recommended action was suggested some time ago but user chose to ignore this and system added a new recommended action again.

IsExecutableAction bool

Gets if this recommended action is actionable by user

IsRevertableAction bool

Gets if changes applied by this recommended action can be reverted by user

Kind string

Resource kind.

LastRefresh string

Gets time when this recommended action was last refreshed.

LinkedObjects List<string>

Gets the linked objects, if any.

Location string

Resource location.

Name string

Resource name.

ObservedImpact List<Pulumi.AzureNative.Sql.Inputs.RecommendedActionImpactRecordResponse>

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

RecommendationReason string

Gets the reason for recommending this action. e.g., DuplicateIndex

RevertActionDuration string

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

RevertActionInitiatedBy string

Gets if approval for reverting this recommended action was given by user/system.

RevertActionInitiatedTime string

Gets the time when this recommended action was approved for revert.

RevertActionStartTime string

Gets the time when system started reverting changes of this recommended action on user resource. e.g., time when index drop is executed.

Score int

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

State Pulumi.AzureNative.Sql.Inputs.RecommendedActionStateInfoResponse

Gets the info of the current state the recommended action is in.

TimeSeries List<Pulumi.AzureNative.Sql.Inputs.RecommendedActionMetricInfoResponse>

Gets the time series info of metrics for this recommended action e.g., CPU consumption time series

Type string

Resource type.

ValidSince string

Gets the time since when this recommended action is valid.

Details map[string]interface{}

Gets additional details specific to this recommended action.

ErrorDetails RecommendedActionErrorInfoResponse

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

EstimatedImpact []RecommendedActionImpactRecordResponse

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

ExecuteActionDuration string

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

ExecuteActionInitiatedBy string

Gets if approval for applying this recommended action was given by user/system.

ExecuteActionInitiatedTime string

Gets the time when this recommended action was approved for execution.

ExecuteActionStartTime string

Gets the time when system started applying this recommended action on the user resource. e.g., index creation start time

Id string

Resource ID.

ImplementationDetails RecommendedActionImplementationInfoResponse

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

IsArchivedAction bool

Gets if this recommended action was suggested some time ago but user chose to ignore this and system added a new recommended action again.

IsExecutableAction bool

Gets if this recommended action is actionable by user

IsRevertableAction bool

Gets if changes applied by this recommended action can be reverted by user

Kind string

Resource kind.

LastRefresh string

Gets time when this recommended action was last refreshed.

LinkedObjects []string

Gets the linked objects, if any.

Location string

Resource location.

Name string

Resource name.

ObservedImpact []RecommendedActionImpactRecordResponse

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

RecommendationReason string

Gets the reason for recommending this action. e.g., DuplicateIndex

RevertActionDuration string

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

RevertActionInitiatedBy string

Gets if approval for reverting this recommended action was given by user/system.

RevertActionInitiatedTime string

Gets the time when this recommended action was approved for revert.

RevertActionStartTime string

Gets the time when system started reverting changes of this recommended action on user resource. e.g., time when index drop is executed.

Score int

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

State RecommendedActionStateInfoResponse

Gets the info of the current state the recommended action is in.

TimeSeries []RecommendedActionMetricInfoResponse

Gets the time series info of metrics for this recommended action e.g., CPU consumption time series

Type string

Resource type.

ValidSince string

Gets the time since when this recommended action is valid.

details Map<String,Object>

Gets additional details specific to this recommended action.

errorDetails RecommendedActionErrorInfoResponse

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

estimatedImpact List<RecommendedActionImpactRecordResponse>

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

executeActionDuration String

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

executeActionInitiatedBy String

Gets if approval for applying this recommended action was given by user/system.

executeActionInitiatedTime String

Gets the time when this recommended action was approved for execution.

executeActionStartTime String

Gets the time when system started applying this recommended action on the user resource. e.g., index creation start time

id String

Resource ID.

implementationDetails RecommendedActionImplementationInfoResponse

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

isArchivedAction Boolean

Gets if this recommended action was suggested some time ago but user chose to ignore this and system added a new recommended action again.

isExecutableAction Boolean

Gets if this recommended action is actionable by user

isRevertableAction Boolean

Gets if changes applied by this recommended action can be reverted by user

kind String

Resource kind.

lastRefresh String

Gets time when this recommended action was last refreshed.

linkedObjects List<String>

Gets the linked objects, if any.

location String

Resource location.

name String

Resource name.

observedImpact List<RecommendedActionImpactRecordResponse>

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

recommendationReason String

Gets the reason for recommending this action. e.g., DuplicateIndex

revertActionDuration String

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

revertActionInitiatedBy String

Gets if approval for reverting this recommended action was given by user/system.

revertActionInitiatedTime String

Gets the time when this recommended action was approved for revert.

revertActionStartTime String

Gets the time when system started reverting changes of this recommended action on user resource. e.g., time when index drop is executed.

score Integer

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

state RecommendedActionStateInfoResponse

Gets the info of the current state the recommended action is in.

timeSeries List<RecommendedActionMetricInfoResponse>

Gets the time series info of metrics for this recommended action e.g., CPU consumption time series

type String

Resource type.

validSince String

Gets the time since when this recommended action is valid.

details {[key: string]: any}

Gets additional details specific to this recommended action.

errorDetails RecommendedActionErrorInfoResponse

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

estimatedImpact RecommendedActionImpactRecordResponse[]

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

executeActionDuration string

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

executeActionInitiatedBy string

Gets if approval for applying this recommended action was given by user/system.

executeActionInitiatedTime string

Gets the time when this recommended action was approved for execution.

executeActionStartTime string

Gets the time when system started applying this recommended action on the user resource. e.g., index creation start time

id string

Resource ID.

implementationDetails RecommendedActionImplementationInfoResponse

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

isArchivedAction boolean

Gets if this recommended action was suggested some time ago but user chose to ignore this and system added a new recommended action again.

isExecutableAction boolean

Gets if this recommended action is actionable by user

isRevertableAction boolean

Gets if changes applied by this recommended action can be reverted by user

kind string

Resource kind.

lastRefresh string

Gets time when this recommended action was last refreshed.

linkedObjects string[]

Gets the linked objects, if any.

location string

Resource location.

name string

Resource name.

observedImpact RecommendedActionImpactRecordResponse[]

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

recommendationReason string

Gets the reason for recommending this action. e.g., DuplicateIndex

revertActionDuration string

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

revertActionInitiatedBy string

Gets if approval for reverting this recommended action was given by user/system.

revertActionInitiatedTime string

Gets the time when this recommended action was approved for revert.

revertActionStartTime string

Gets the time when system started reverting changes of this recommended action on user resource. e.g., time when index drop is executed.

score number

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

state RecommendedActionStateInfoResponse

Gets the info of the current state the recommended action is in.

timeSeries RecommendedActionMetricInfoResponse[]

Gets the time series info of metrics for this recommended action e.g., CPU consumption time series

type string

Resource type.

validSince string

Gets the time since when this recommended action is valid.

details Mapping[str, Any]

Gets additional details specific to this recommended action.

error_details RecommendedActionErrorInfoResponse

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

estimated_impact Sequence[RecommendedActionImpactRecordResponse]

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

execute_action_duration str

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

execute_action_initiated_by str

Gets if approval for applying this recommended action was given by user/system.

execute_action_initiated_time str

Gets the time when this recommended action was approved for execution.

execute_action_start_time str

Gets the time when system started applying this recommended action on the user resource. e.g., index creation start time

id str

Resource ID.

implementation_details RecommendedActionImplementationInfoResponse

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

is_archived_action bool

Gets if this recommended action was suggested some time ago but user chose to ignore this and system added a new recommended action again.

is_executable_action bool

Gets if this recommended action is actionable by user

is_revertable_action bool

Gets if changes applied by this recommended action can be reverted by user

kind str

Resource kind.

last_refresh str

Gets time when this recommended action was last refreshed.

linked_objects Sequence[str]

Gets the linked objects, if any.

location str

Resource location.

name str

Resource name.

observed_impact Sequence[RecommendedActionImpactRecordResponse]

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

recommendation_reason str

Gets the reason for recommending this action. e.g., DuplicateIndex

revert_action_duration str

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

revert_action_initiated_by str

Gets if approval for reverting this recommended action was given by user/system.

revert_action_initiated_time str

Gets the time when this recommended action was approved for revert.

revert_action_start_time str

Gets the time when system started reverting changes of this recommended action on user resource. e.g., time when index drop is executed.

score int

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

state RecommendedActionStateInfoResponse

Gets the info of the current state the recommended action is in.

time_series Sequence[RecommendedActionMetricInfoResponse]

Gets the time series info of metrics for this recommended action e.g., CPU consumption time series

type str

Resource type.

valid_since str

Gets the time since when this recommended action is valid.

details Map<Any>

Gets additional details specific to this recommended action.

errorDetails Property Map

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

estimatedImpact List<Property Map>

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

executeActionDuration String

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

executeActionInitiatedBy String

Gets if approval for applying this recommended action was given by user/system.

executeActionInitiatedTime String

Gets the time when this recommended action was approved for execution.

executeActionStartTime String

Gets the time when system started applying this recommended action on the user resource. e.g., index creation start time

id String

Resource ID.

implementationDetails Property Map

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

isArchivedAction Boolean

Gets if this recommended action was suggested some time ago but user chose to ignore this and system added a new recommended action again.

isExecutableAction Boolean

Gets if this recommended action is actionable by user

isRevertableAction Boolean

Gets if changes applied by this recommended action can be reverted by user

kind String

Resource kind.

lastRefresh String

Gets time when this recommended action was last refreshed.

linkedObjects List<String>

Gets the linked objects, if any.

location String

Resource location.

name String

Resource name.

observedImpact List<Property Map>

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

recommendationReason String

Gets the reason for recommending this action. e.g., DuplicateIndex

revertActionDuration String

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

revertActionInitiatedBy String

Gets if approval for reverting this recommended action was given by user/system.

revertActionInitiatedTime String

Gets the time when this recommended action was approved for revert.

revertActionStartTime String

Gets the time when system started reverting changes of this recommended action on user resource. e.g., time when index drop is executed.

score Number

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

state Property Map

Gets the info of the current state the recommended action is in.

timeSeries List<Property Map>

Gets the time series info of metrics for this recommended action e.g., CPU consumption time series

type String

Resource type.

validSince String

Gets the time since when this recommended action is valid.

RecommendedActionStateInfoResponse

ActionInitiatedBy string

Gets who initiated the execution of this recommended action. Possible Value are: User -> When user explicity notified system to apply the recommended action. System -> When auto-execute status of this advisor was set to 'Enabled', in which case the system applied it.

CurrentValue string

Current state the recommended action is in. Some commonly used states are: Active -> recommended action is active and no action has been taken yet. Pending -> recommended action is approved for and is awaiting execution. Executing -> recommended action is being applied on the user database. Verifying -> recommended action was applied and is being verified of its usefulness by the system. Success -> recommended action was applied and improvement found during verification. Pending Revert -> verification found little or no improvement so recommended action is queued for revert or user has manually reverted. Reverting -> changes made while applying recommended action are being reverted on the user database. Reverted -> successfully reverted the changes made by recommended action on user database. Ignored -> user explicitly ignored/discarded the recommended action.

LastModified string

Gets the time when the state was last modified

ActionInitiatedBy string

Gets who initiated the execution of this recommended action. Possible Value are: User -> When user explicity notified system to apply the recommended action. System -> When auto-execute status of this advisor was set to 'Enabled', in which case the system applied it.

CurrentValue string

Current state the recommended action is in. Some commonly used states are: Active -> recommended action is active and no action has been taken yet. Pending -> recommended action is approved for and is awaiting execution. Executing -> recommended action is being applied on the user database. Verifying -> recommended action was applied and is being verified of its usefulness by the system. Success -> recommended action was applied and improvement found during verification. Pending Revert -> verification found little or no improvement so recommended action is queued for revert or user has manually reverted. Reverting -> changes made while applying recommended action are being reverted on the user database. Reverted -> successfully reverted the changes made by recommended action on user database. Ignored -> user explicitly ignored/discarded the recommended action.

LastModified string

Gets the time when the state was last modified

actionInitiatedBy String

Gets who initiated the execution of this recommended action. Possible Value are: User -> When user explicity notified system to apply the recommended action. System -> When auto-execute status of this advisor was set to 'Enabled', in which case the system applied it.

currentValue String

Current state the recommended action is in. Some commonly used states are: Active -> recommended action is active and no action has been taken yet. Pending -> recommended action is approved for and is awaiting execution. Executing -> recommended action is being applied on the user database. Verifying -> recommended action was applied and is being verified of its usefulness by the system. Success -> recommended action was applied and improvement found during verification. Pending Revert -> verification found little or no improvement so recommended action is queued for revert or user has manually reverted. Reverting -> changes made while applying recommended action are being reverted on the user database. Reverted -> successfully reverted the changes made by recommended action on user database. Ignored -> user explicitly ignored/discarded the recommended action.

lastModified String

Gets the time when the state was last modified

actionInitiatedBy string

Gets who initiated the execution of this recommended action. Possible Value are: User -> When user explicity notified system to apply the recommended action. System -> When auto-execute status of this advisor was set to 'Enabled', in which case the system applied it.

currentValue string

Current state the recommended action is in. Some commonly used states are: Active -> recommended action is active and no action has been taken yet. Pending -> recommended action is approved for and is awaiting execution. Executing -> recommended action is being applied on the user database. Verifying -> recommended action was applied and is being verified of its usefulness by the system. Success -> recommended action was applied and improvement found during verification. Pending Revert -> verification found little or no improvement so recommended action is queued for revert or user has manually reverted. Reverting -> changes made while applying recommended action are being reverted on the user database. Reverted -> successfully reverted the changes made by recommended action on user database. Ignored -> user explicitly ignored/discarded the recommended action.

lastModified string

Gets the time when the state was last modified

action_initiated_by str

Gets who initiated the execution of this recommended action. Possible Value are: User -> When user explicity notified system to apply the recommended action. System -> When auto-execute status of this advisor was set to 'Enabled', in which case the system applied it.

current_value str

Current state the recommended action is in. Some commonly used states are: Active -> recommended action is active and no action has been taken yet. Pending -> recommended action is approved for and is awaiting execution. Executing -> recommended action is being applied on the user database. Verifying -> recommended action was applied and is being verified of its usefulness by the system. Success -> recommended action was applied and improvement found during verification. Pending Revert -> verification found little or no improvement so recommended action is queued for revert or user has manually reverted. Reverting -> changes made while applying recommended action are being reverted on the user database. Reverted -> successfully reverted the changes made by recommended action on user database. Ignored -> user explicitly ignored/discarded the recommended action.

last_modified str

Gets the time when the state was last modified

actionInitiatedBy String

Gets who initiated the execution of this recommended action. Possible Value are: User -> When user explicity notified system to apply the recommended action. System -> When auto-execute status of this advisor was set to 'Enabled', in which case the system applied it.

currentValue String

Current state the recommended action is in. Some commonly used states are: Active -> recommended action is active and no action has been taken yet. Pending -> recommended action is approved for and is awaiting execution. Executing -> recommended action is being applied on the user database. Verifying -> recommended action was applied and is being verified of its usefulness by the system. Success -> recommended action was applied and improvement found during verification. Pending Revert -> verification found little or no improvement so recommended action is queued for revert or user has manually reverted. Reverting -> changes made while applying recommended action are being reverted on the user database. Reverted -> successfully reverted the changes made by recommended action on user database. Ignored -> user explicitly ignored/discarded the recommended action.

lastModified String

Gets the time when the state was last modified

Import

An existing resource can be imported using its type token, name, and identifier, e.g.

$ pulumi import azure-native:sql:DatabaseAdvisor CreateIndex /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/workloadinsight-demos/providers/Microsoft.Sql/servers/misosisvr/databases/IndexAdvisor_test_3/advisors/CreateIndex 

Package Details

Repository
https://github.com/pulumi/pulumi-azure-native
License
Apache-2.0