DatabaseAdvisor

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());
    }
}

$ pulumi import azure-native:sql:DatabaseAdvisor CreateIndex /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/advisors/{advisorName}