Database Advisor Args
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. Azure REST API version: 2021-11-01. Prior API version in Azure Native 1.x: 2020-11-01-preview. Other available API versions: 2014-04-01, 2022-11-01-preview, 2023-02-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",
});
});
Content copied to clipboard
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
})
}
Content copied to clipboard
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());
}
}
Content copied to clipboard
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}
Content copied to clipboard
Constructors
Link copied to clipboard
fun DatabaseAdvisorArgs(advisorName: Output<String>? = null, autoExecuteStatus: Output<AutoExecuteStatus>? = null, databaseName: Output<String>? = null, resourceGroupName: Output<String>? = null, serverName: Output<String>? = null)