Blog Post

Azure Database Support Blog
3 MIN READ

How to maintain Azure SQL Indexes and Statistics

Yochanan_Rachamim's avatar
Yochanan_Rachamim
Icon for Microsoft rankMicrosoft
Mar 14, 2019
First published on MSDN on Jul 03, 2016   [2020-11-09]Note: New version with major update is now available include resume functionality, resumable index rebuild, fix forwarded records in heaps....
Updated May 04, 2025
Version 5.0
Maintenance
reindex
update statistics
IliasBalasis's avatar
IliasBalasis
Copper Contributor
Sep 19, 2024

On second thought I am afraid this was not a red herring after all.

 

Even after completing a run and starting a new one, without an AzureSQLMaintenanceCMDQueue table being present, I still get repeated rebuild/reorganization commands for partitions.