SAM AppInsight for SQL - ability to ignore fragmentation of specific Indexes

Hi, I created a new thread 12th Jan 2018 regarding exactly this issue with fragmentation and didn't know there was a thread already running for a couple of years now. I will vote on this and hopefully at some point in the near future Solarwinds will add this to the next release or release a patch to add the page count option so as to eliminate the needless fragmentation errors that pop up every so often.

I found it.  - this is WRONG.. this is looking at the TABLE size not the index size..
Dear SAM please fix. please replace table size with "Number of Pages" for the index.
then we can ignore indexes less than out nominated value..

Yes we would also like to ignore nominated Tables.

​

Further to the above I question if the "Minimum Size of index to Retrieve" actually works.

I received (pun intended) and warning alert for an index on one of our SQL 2012 servers.
I investigated and found that the index space is 0.031MB (well below 1024 KB) at table level,

Further, there does not appear to be a storage size recorded for an individual index.
The nominal measure used by MS and Ola Hallengren is "Number of pages." in an index.

I attach 3 images that support this information and AGAIN I ask for a "Minimum number of pages" for retrieval of index fragmentation.

ALSO - voting is an excellent idea, however there are more Sysops/Wintel Admins than there are DBAs consequently out vote numbers are going to be irrelevant to the total population but supremely important to us.

Dear Solarwinds please advise how we can escalate our requests in relation to our population?

With respect,

Greg.

Actually - What I see as needed here is the ability to nominate how many (MIN) pages in an index before alerting.

For example out of the box SolarWinds alerts at all indexes that are fragmented.
For some databases they are always going to be fragmented because of the nature of their purpose (monitoring database for example)

Others are so small that the fragmentation is not an issue.

Microsoft nominally ignores indexes where there are less than a 1000 pages. I've recently seen alerts sent for a 5 page index..

Currently I am deleting the "greater than" values to ignore indexes for small databases or constantly changing indexes as I cannot restrict the "importance" of an index.

" Total size Index (KB) threshold:"  - How is this meant to work? Size is not a relevant parameter of an index. Pages in an index are, yes this is size related but the values "Greater than" imply that if the index gets to a nominated size it will be alerted ?? why??

Just what I needed. Thanks!!!