olahallengren / sql-server-maintenance-solution

SQL Server Maintenance Solution
https://ola.hallengren.com
MIT License
2.91k stars 756 forks source link

Resumable Index online with MAX_DURATION #753

Open beliqar opened 1 year ago

beliqar commented 1 year ago

Description of the feature Hi, I am using MAX_DURATION with Resumable rebuild index . For example this ALTER INDEX index ON table Resume WITH (MAX_DURATION =1 MINUTES)

but I checked that in IndexOptimize on row 2128 is "AND @CurrentAction = 'INDEX_REBUILD_ONLINE' AND @CurrentResumableIndexOperation = 0 AND @Resumable = 'Y' "

so then is not possible or I don't know how use MAX_DURATION .

Can you check it please?

Thanks