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?
