What are the challenges you face when working across database platforms? Take the survey

Azure DB - Ignore Automatic Tuning Indexes

We would like the ability to ignore indexes that Azure DB creates as part of Automatic Tuning.  Our customers have the ability to create custom reports against our DB and sometimes Azure suggests an index we don't ship that is specific to the customer. When we come across one that we thing will help we apply it, but we don't want to add that index to the base product (in most cases).  

The problem is next time we upgrade their instance we wipe out the index via SQL Change Automation and Octopus Deploy.  An example index name is below.  We name all of our indexes IX_% or UX_% so even a filter that we could specify would help.  



Sign In or Register to comment.