Azure Native v2.8.0, Sep 18 23

This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.

Azure Native v2.8.0 published on Monday, Sep 18, 2023 by Pulumi

pulumi/pulumi-azure-native

azure-native.sql.DatabaseAdvisor

Explore with Pulumi AI

This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.

Azure Native v2.8.0 published on Monday, Sep 18, 2023 by Pulumi

pulumi/pulumi-azure-native

Example Usage

Update database advisor

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var databaseAdvisor = new AzureNative.Sql.DatabaseAdvisor("databaseAdvisor", new()
    {
        AdvisorName = "CreateIndex",
        AutoExecuteStatus = AzureNative.Sql.AutoExecuteStatus.Disabled,
        DatabaseName = "IndexAdvisor_test_3",
        ResourceGroupName = "workloadinsight-demos",
        ServerName = "misosisvr",
    });

});

package main

import (
	"github.com/pulumi/pulumi-azure-native-sdk/sql/v2"
	"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 com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sql.DatabaseAdvisor;
import com.pulumi.azurenative.sql.DatabaseAdvisorArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

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 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, AutoExecuteStatusArgs

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, RecommendedActionErrorInfoResponseArgs

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, RecommendedActionImpactRecordResponseArgs

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, RecommendedActionImplementationInfoResponseArgs

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, RecommendedActionMetricInfoResponseArgs

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, RecommendedActionResponseArgs

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, RecommendedActionStateInfoResponseArgs

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/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/advisors/{advisorName}

Package Details

Repository: Azure Native pulumi/pulumi-azure-native
License: Apache-2.0

This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.

Azure Native v2.8.0 published on Monday, Sep 18, 2023 by Pulumi

pulumi/pulumi-azure-native

azure-native.sql.DatabaseAdvisor

On this page

On this page

Example Usage

Update database advisor

Create DatabaseAdvisor Resource

DatabaseAdvisor Resource Properties

Inputs

Outputs

Supporting Types

AutoExecuteStatus, AutoExecuteStatusArgs

RecommendedActionErrorInfoResponse, RecommendedActionErrorInfoResponseArgs

RecommendedActionImpactRecordResponse, RecommendedActionImpactRecordResponseArgs

RecommendedActionImplementationInfoResponse, RecommendedActionImplementationInfoResponseArgs

RecommendedActionMetricInfoResponse, RecommendedActionMetricInfoResponseArgs

RecommendedActionResponse, RecommendedActionResponseArgs

RecommendedActionStateInfoResponse, RecommendedActionStateInfoResponseArgs

Import

Package Details

On this page

On this page