CODEWITHSUNDEEP
azureazure-sql-database
Marconline
Marconline

Reputation: 1431

SQL Azure and Indexes

is that true that SQL Azure rebuilds / reorganizes index automatically?

We have a database on Sql Azure and experiencing performance degradation and I suppose this is a urban-legend.

Can you help me?

Thanks, Marco

Upvotes: 9

Views: 9456

Answers (2)

Ali Sufyan
Ali Sufyan

Reputation: 94

Sql Azure offers few nice amenities with it, as follows:

Intelligent Performance Performance overview Performance recommendations Query Performance Insight Automatic tuning

Keep an eye on the statistics, You can also allow azure to automatically tune your database indexes, add, remove them to tune database performance.

Hope it helps.

Upvotes: 0

DavideB
DavideB

Reputation: 609

SQL Azure does not rebuild indexes automatically while the statistics are updated automatically. If you have a specific reason to force the rebuild it, you have to directly issue the command.

This nice post helps you create a script to dynamically rebuild all indexes in a SQL Azure db.

Upvotes: 12

Related Questions