New answers tagged maintenance
I have seen this behaviour - even when rebuilding online - you still need a schema modification (SCH-M) lock to change the index over. On a busy table, this can take time to acquire.
For everyone interested, I have created a chart showing the index REBUILD duration of about 2500 index rebuilds within couple of weeks in relation to the fragmentation of the index and it's size in pages. This data is based on 10 SQL Servers, hundreads of tables and on Ola Hallengren's optimizing procedures. The general threshold for rebuilding is set to ...
Top 50 recent answers are included