The Table Fragmentation (Percent) alert provides the percentage of fragmented pages in a table. It is the scan density from dbcc showcontig on a clustered index of a table. If the table does not have a clustered index, table fragmentation is not collected. If this value exceeds 80%, consider the following remedies:

• Drop and re-create the clustered index.
• Reorder the leaf-level pages of the index in a logical order.
• Rebuild the index online.

This alert is raised based on the diagnostic data collection interval specified in Server Properties. For more information, see Set general server options.