When running 'Index Fragmentation' , 'Page Space Used %' column is all zeroes (4306426)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

When running 'Index Fragmentation' , 'Page Space Used %' column is all zeroes
Description

When running Tools | Adminster | Index Fragmentation, the results for 'Page Space Used,[%]' column is always 0. Is this correct?
Cause

This is as designed. Scanning level is set to 'Limited'
Limited—Provides fastest performance, only the parent-level pages are scanned. Fragmentation percent and Page Space Used percent can display as null.
Sampled—Provides estimated index statistics, based on 1% sample of all pages. This mode does not show heap indexes fragmentation percent.
Detailed—Provides actual index statistics, all pages are scanned.
Resolution

Set scanning level to 'Sampled' or 'Detailed' to populate the Page Space Used % column.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title