Hi,
I'm new to the platform and we're trialing it internally.
Some of our databases hold LOB_DATA in their tables, and we're finding that the Top Indexes alert is constantly flagging due to 99% fragmentation.
When I review the table in question, I can see that the IN_ROW_DATA is 99% fragmented, but is only about 100 pages.
Whereas the LOB_DATA is 500,000 pages. sys.dm_db_index_physical_stats doesn't show fragmentation for LOB_DATA, but it does show 99% page space used.
As such, I'm happy that the index is properly maintained, but I want to stop SAM from alerting on these indexes and putting an exclamation mark on the databases.
Is there any way to filter these indexes, or filter all LOB_DATA indexes?
Thanks for your help
Steve
