Can I pause or resume an index rebuild operation?

Geschrieben von Database Magician am Sonntag, 19. November 2017

'One of the cool new features in SQL Server 2017 (and currently also in public preview in Azure SQL Database) is the option to pause and resume an online index rebuild operation.

This option can be useful for several use cases. Imagine you have a very large index, which takes approximately 5 hours to rebuild online. A lot of things can happen during those 5 hours.

For a start, you might not have enough time within your maintenance window to complete the operation. Now you can configure the operation to run for 3 hours and then pause automatically. You can then resume the operation during the next maintenance window. Of course, this means that SQL Server will have to maintain both old and new indexes until the new index is completely ready. But depending on your workload and policy, this might be a better option than to continue to rebuild the index outside of the maintenance window.'...

http://www.sqlservercentral.com/blogs/guy-glantser/2017/11/16/can-i-pause-or-resume-an-index-rebuild-operation/?utm_source=DBW&utm_medium=pubemail