Skip to main content
NOW AVAILABLE

Azure SQL Database—Extensions for index resumable online operations

Published date: November 27, 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.

Learn more about ALTER DATABASE SCOPED CONFIGURATION

  • Azure SQL Database
  • Features