Data page cluster ratio

For allpages-locked tables, the data page cluster ratio measures how well pages are sequenced on extents, when the table is read in page-chain order. A cluster ratio of 1.0 indicates perfect sequencing. A lower cluster ratio indicates a fragmented page chain.

For data-only-locked tables, the data page cluster ratio measures how well the pages are packed on extents. A cluster ratio of 1.0 indicates complete packing of extents. A low data page cluster ratio indicates that there are empty pages in extents that are allocated to the table.