Hi. I need to set the "create Index" to off in the...
# dotnet
Hi. I need to set the "create Index" to off in the Automatic tuning tab of my sql Db ( the automatic index disturbing the performance of the database). How to do that with pulumi?
sql db on which provider? There's probably a resource property, but can't go look at docs unless we know what sql resource your using.
We use sql server in azure
I would like to turn off the createindex in the red frame:
With pulumi on db create
I think you can do this with azure-native and the DatabaseAdvisor resource: https://www.pulumi.com/registry/packages/azure-native/api-docs/sql/databaseadvisor/ I don't think it supported for the old azure provider.
Thanks, I will try it out.
yes. The Databaseadvisor did the work. Thank you 🙂 - Example:
Copy code
var databaseAdvisor = new AzureNative.Sql.DatabaseAdvisor("sqlDatabaseAdvisor", new AzureNative.Sql.DatabaseAdvisorArgs
            ResourceGroupName = resourceGroup.Name,
            ServerName = server.Name,
            DatabaseName = database.Name,
            AdvisorName = "CreateIndex",
            AutoExecuteStatus = AzureNative.Sql.AutoExecuteStatus.Disabled,