Versions Compared

Old Version 1

changes.mady.by.user Unknown User (6092b4dfd35380006886a5fb)

Saved on

compared with

New Version 2

changes.mady.by.user Unknown User (6092b4dfd35380006886a5fb)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:

...