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.