DatabaseAdvisorArgs

data class DatabaseAdvisorArgs(val advisorName: Output<String>? = null, val autoExecuteStatus: Output<AutoExecuteStatus>? = null, val databaseName: Output<String>? = null, val resourceGroupName: Output<String>? = null, val serverName: Output<String>? = null) : ConvertibleToJava<DatabaseAdvisorArgs>

Database, Server or Elastic Pool Advisor. Uses Azure REST API version 2021-11-01. In version 1.x of the Azure Native provider, it used API version 2020-11-01-preview. Other available API versions: 2014-04-01, 2022-11-01-preview, 2023-02-01-preview, 2023-05-01-preview, 2023-08-01, 2023-08-01-preview, 2024-05-01-preview.

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 (
sql "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

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}

Constructors

Link copied to clipboard
constructor(advisorName: Output<String>? = null, autoExecuteStatus: Output<AutoExecuteStatus>? = null, databaseName: Output<String>? = null, resourceGroupName: Output<String>? = null, serverName: Output<String>? = null)

Properties

Link copied to clipboard
val advisorName: Output<String>? = null

The name of the Database Advisor.

Link copied to clipboard

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

Link copied to clipboard
val databaseName: Output<String>? = null

The name of the database.

Link copied to clipboard
val resourceGroupName: Output<String>? = null

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

Link copied to clipboard
val serverName: Output<String>? = null

The name of the server.

Functions

Link copied to clipboard
open override fun toJava(): DatabaseAdvisorArgs