ServerAdvisor

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
    var serverAdvisor = new AzureNative.Sql.ServerAdvisor("serverAdvisor", new()
    {
        AdvisorName = "CreateIndex",
        AutoExecuteStatus = AzureNative.Sql.AutoExecuteStatus.Disabled,
        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.NewServerAdvisor(ctx, "serverAdvisor", &sql.ServerAdvisorArgs{
			AdvisorName:       pulumi.String("CreateIndex"),
			AutoExecuteStatus: sql.AutoExecuteStatusDisabled,
			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.ServerAdvisor;
import com.pulumi.azurenative.sql.ServerAdvisorArgs;
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 serverAdvisor = new ServerAdvisor("serverAdvisor", ServerAdvisorArgs.builder()
            .advisorName("CreateIndex")
            .autoExecuteStatus("Disabled")
            .resourceGroupName("workloadinsight-demos")
            .serverName("misosisvr")
            .build());
    }
}

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