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?
Same here. I even raised the collection minimum to 16000 KB, but get alerts for tables of 600 KB size.I just put up with the fact that SQLdm is flawed.
Is there a support case I can reference to see if this is escalated to R&D already?
Powered by IDERA