Index Fragmentation Alert – Small Indexes Generating Alerts

by Nov 8, 2019

I'm trying to figure out how to configure the alert Table Fragmentation to ignore indexes that are smaller than 1000 pages. There's nothing I can find within the alert, in the server properties, or grooming options that will let me configure this. Quite often, I have a table larger than the 8k (what I have set to the minimum table size when collecting reorg stats) and indexes smaller than 1k. I really don't need to do anything with these indexes but they continue to show up in alerts. Other than creating a custom script / alert to eliminate smaller indexes, are there any options available I can configure? either in the alert itself or the server properties?