Currently there is a one-size-fits-all approach to the AppInsight for SQL monitors. While the current thresholds and metrics work well for medium to large databases, they fall short on small ones. This is especially evident on index fragmentation. Read a SQL performance forum and you will quickly see that size matters both when the size is large and small.
Microsoft (Microsoft SQL Server 2000 Index Defragmentation Best Practices) indicates that small indexes, by there very nature of being small, are going to show "fragmentation" when (at least at a performance impacting level) none exists.
Brent Ozar, a well known and respected MsSQL authority, suggests that size needs to be taken into account when working on performance (http://www.brentozar.com/archive/2009/02/index-fragmentation-findings-part-2-size-matters/).
I would like to request that AppInsight for SQL be able to account for this. One idea would be to allow for page count aware thresholds, provide an additional threshold value for page (or KB size) that is an "and" rather than "or" (currently the Index counter offers a % fragmentation and size (KB) threshold, but the two are completely independent).
Disclosure: I am not a DBA, just a lowly Systems Admin, but I trust my DBA and these are things that we both (when I understand) feel should be addressed.
