Viewing Fragmentation Statistics

  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.

Note:

The average clustering ratio database statistic is an approximate indication of the ordering in which data blocks are laid out in data (.pag) files. The maximum value of 1 indicates that the blocks are laid out in block key order within data files. The reported value of the clustering ratio may be less than 1, even upon restructure, due to the scalability enhancements as well as support for parallel operations. This statistic does not apply to aggregate storage databases.

Related Information

Related Commands