First: we run indexoptimize every day with at TimeLimit for let's say 3 hours. From these 3 hours about 45 minutes is used to check which indexes need to be rebuild.
It starts with index AAA_IX etc until the timelimit of 3 hours exceeds. A bunch of indexes have been rebuilt by that time.
Next day it starts again with index AAA_IX, or maybe index ABB_IX as index AAA_IX didn't match the requirements for rebuildingt. And again after 3 hours it ends at about the same index where it ended the previous day. Subsequent indexes won't be rebuild any time (unless we schedule extra runs which might take more time).
Is it possible to implement this? Maybe it can check CommandLog to see which was the last index which was successfully processed and continues with the next one from the list. As there doesn't seem to be another convenient way to see when an index was last optimized.
Update: might be that adding @OnlyModifiedStatistics='Y' also gives a better result and skips some of the just rebuilt indexes. I'll let this run over the weekend this way (with the timelimit of 3 hours).
First: we run indexoptimize every day with at TimeLimit for let's say 3 hours. From these 3 hours about 45 minutes is used to check which indexes need to be rebuild.
It starts with index AAA_IX etc until the timelimit of 3 hours exceeds. A bunch of indexes have been rebuilt by that time.
Next day it starts again with index AAA_IX, or maybe index ABB_IX as index AAA_IX didn't match the requirements for rebuildingt. And again after 3 hours it ends at about the same index where it ended the previous day. Subsequent indexes won't be rebuild any time (unless we schedule extra runs which might take more time).
Is it possible to implement this? Maybe it can check CommandLog to see which was the last index which was successfully processed and continues with the next one from the list. As there doesn't seem to be another convenient way to see when an index was last optimized.
Update: might be that adding @OnlyModifiedStatistics='Y' also gives a better result and skips some of the just rebuilt indexes. I'll let this run over the weekend this way (with the timelimit of 3 hours).