Resumable Online Index Rebuild is in public preview for Azure SQL DB

Community Manager

We are delighted to announce that Resumable Online Index Rebuild (ROIR) is now available for public preview in Azure SQL DB. With this feature, you can resume a paused index rebuild operation from where the rebuild operation was paused rather than having to restart the operation at the beginning. Additionally, this feature rebuilds indexes using only a small amount of log space. You can use the new feature in the following scenarios:

 

  • Resume an index rebuild operation after an index rebuild failure (such as after a database failover or after running out of disk space). 
  • Pause an ongoing index rebuild operation and resume it later. 
  • Rebuild large indexes without using a lot of log space and have a long-running transaction that blocks other maintenance activities. 

Slide1.PNG

 

Read about it in the Azure blog.

0 Replies