Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Rebuilt clustered index with new fill factor Expand / Collapse
Author
Message
Posted Friday, September 17, 2010 10:08 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 8:53 PM
Points: 387, Visits: 749
Hi folks
I Rebuilt clustered index with new fill factor 80%. The new filll factor is not reflected in avg_page_space_used_in_percent it shows 99% ?

this is small table by the way only 250 pages, so this is not a big deal I know the rule of thumb is 1000 pages or more an index is big enough to worry about in some folks eyes..others say less. needles to say I was just curious.

THANKS

Post #988355
Posted Friday, September 17, 2010 11:44 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 8:53 PM
Points: 387, Visits: 749
If I right click on the index it says 80.41 % for page fullness but under
sys.dm_db_index_physical_stats I get 98% for avg page space used? I thought they would be the same.....which tells me I must be misunderstanding something?
Post #988458
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse