Azure SQL Database – Extensions for index resumable online operations
Published date: 27 November, 2019
Now in general availability, a new configuration option PAUSED_RESUMABLE_INDEX_ABORT_DURATION_MINUTES has been added to ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL) for resumable online index operations. This allows you to automatically abort a paused index for Azure SQL Database and SQL managed instance. Paused resumable indexes use additional resources, so keeping them in this state beyond the required timeframe causes unnecessary resource consumption. In the default configuration, a paused index is automatically aborted after one day. The time interval to abort a paused index is now user-configurable using the new database scoped configuration option.