In the current Index optimize Job is it possible to modify only four settings:

- DTU Threshold
- Duration (maximum)
- Index Quantity (maximum)
- Online / Offline index rebuild

Especially short after a Go-Live but not restricted to this moment do we notice huge quantities of heavy fragmented indexes.

This is not a situation we would like to see, they are caused by mainly three fixed parameters.

There is first a index usage threshold of 10.000 (formula unknown) together with a threshold of 50 % fragmentation level combined with a page count Level of 100 and a usage

The second is a threshold of 25 % fragmentation combined with a page count Level of 200.

Incase a certain database growth is not established or when cleaning/archiving is done frequent does this lead to unexpected high fragmenation levels.

Many customers / database administrators and technical consultants would benefit from a small change. This would be the addition of three additional parameters.

- Manual override of the usage threshold of 10.000 (checkbox)
- Add a new parameter 'page count level', field type integer and I advice a value between 5 and 200
- Add a new parameter 'fragmentation level', field type integer and I advice a value between 10 and 99

Thank you very much for your attention, it will make customers happy around the Globe!

Martinus