Hi. I need to set the "create Index" to off in the...
# dotnetc
clever-addition-88333
06/12/2023, 7:04 AMHi. 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?
e
echoing-dinner-19531
06/12/2023, 9:41 AMsql 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.
c
clever-addition-88333
06/12/2023, 10:33 AMWe use sql server in azure
clever-addition-88333
06/12/2023, 10:41 AMI would like to turn off the createindex in the red frame:
clever-addition-88333
06/12/2023, 10:42 AMWith pulumi on db create
e
echoing-dinner-19531
06/12/2023, 10:50 AMI 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.
c
clever-addition-88333
06/12/2023, 10:55 AMThanks, I will try it out.
clever-addition-88333
06/12/2023, 11:36 AMyes. 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,
});2 Views