Viewing Fragmentation Statistics

You can measure fragmentation using the average clustering ratio statistic for a database. This statistic indicates the fragmentation level of the data (.pag) files. The maximum value, 1, indicates no fragmentation.

Note:

This statistic does not apply to aggregate storage databases.

  To view fragmentation statistics for a database:

  1. From Enterprise View or a custom view, select the database.

  2. Right-click and select Edit, then Properties.

  3. In Database Properties, select Statistics.

  4. Expand the Blocks node to view the average clustering ratio.

Related Information

Related Commands