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.

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >