Martinus Janssen Mister

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