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. API Version: 2020-11-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 (
sql "github.com/pulumi/pulumi-azure-native-sdk/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
})
}
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/00000000-1111-2222-3333-444444444444/resourceGroups/workloadinsight-demos/providers/Microsoft.Sql/servers/misosisvr/databases/IndexAdvisor_test_3/advisors/CreateIndex
Content copied to clipboard
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
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
The name of the database.
Link copied to clipboard
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
The name of the server.