I love the Appinsight for SQL server. One of my biggest issues is with the fragmentation counters throwing my databases it warning or critical states. The problem is with very small indexes a high level of fragmentation is not always a problem and most of the time can not be resolved with a rebuild/reorganise. I would like to suggest:
- Add a column to the Index Fragmentation section that shows the size of the index either in Pages or actual size.
- Allow the threshold to take into account the size of the index i.e the warning threshold might be set to 60% fragmentation with an index size above 500 pages.
Thanks
Nick
