Azure SQL managed instances

Question

If we opt Azure SQL managed instances in DEV,QA and PROD environment . Will Microsoft take care the DB maintenance in terms of index rebuild or reorganize periodically etc. ?

score 3 · Accepted Answer · answered Nov 01 '20 at 11:38

3

Azure does not automatically rebuild your indexes. You need to maintain the SQL indexes.

There is a blog article on how you can automate these tasks here: https://geeks.ms/davidjrh/2015/10/08/rebuilding-sql-database-indexes-using-azure-automation/

answered Nov 01 '20 at 11:38

Shiraz Bhaiji

64,065
34
143
252

@Codehunter if this solves your problem please upvote/ accept the answer – Shiraz Bhaiji Nov 02 '20 at 14:26

score 0 · Answer 2 · answered Nov 02 '20 at 12:57

Please read this thread on StackOverflow to know on what scenarios Microsoft recommends to rebuild indexes. See the answer provided by Connor Cunningham (Microsoft).

My personal experience is to do that daily to make sure the CPU, memory and storage space of the database is the lowest, and you don't need to assign more resources to the database. Use Ola Hallengren maintence scripts available here on GitHub.

Azure SQL managed instances

2 Answers2