I was recently checking a SQL Database in Azure and noticed this recommendation:

database index recommendation

recommendation details

According to the Microsoft docs on "create index" recommendations, they do have mechanisms in place to ensure that the creation of the index won't be a problem in terms of available CPU, Data IO, Log IO, and available storage.

I found some helpful infomation in an answer to another question which states:

SQL Azure monitors the use of the system and the query plans it generates and tries to work out whether the plans could benefit from additional indexes. When it thinks it has one, it makes the suggestion. If you elect to implement the suggestion it will run some tests to ensure it has actually made an improvement, and will roll back if it hasn't. We implement almost all the suggestions it offers. Indexes are generally not material to the operation of a database so they're safe to add, with a few critical exceptions (like clustered and unique indexes). For the most part, as long as your DB tier offers you sufficient storage, we recommend adding any index suggested with either a Medium or High Impact rating.

Is this a safe and recommended action? Are there any necessary precautions?


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.