April 24, 2006 at 9:33 am
I ran Dbcc showcontig against one of my tables and i got following results
DBCC SHOWCONTIG scanning 'Webhits' table...
Table: 'NOTES' (581577110); index ID: 1, database ID: 18
TABLE level scan performed.
- Pages Scanned................................: 551860
- Extents Scanned..............................: 69430
- Extent Switches..............................: 226910
- Avg. Pages per Extent........................: 7.9
- Scan Density [Best Count:Actual Count].......: 30.40% [68983:226911]
- Logical Scan Fragmentation ..................: 16.68%
- Extent Scan Fragmentation ...................: 37.41%
- Avg. Bytes Free per Page.....................: 2465.8
- Avg. Page Density (full).....................: 69.53%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
After Reindexing with fill factor 70( this table as lot of inserts and as well Select also), i got following results.
DBCC SHOWCONTIG scanning 'Webhit' table...
Table: 'NOTES' (581577110); index ID: 1, database ID: 18
TABLE level scan performed.
- Pages Scanned................................: 541914
- Extents Scanned..............................: 68016
- Extent Switches..............................: 68015
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.59% [67740:68016]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 31.57%
- Avg. Bytes Free per Page.....................: 2362.5
- Avg. Page Density (full).....................: 70.81%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
everything looking good but still Extent Scan Fragmentation ...................: 31.57%
how we can reduce Extent Scan Fragmentation ?
Please somebody help me.
April 24, 2006 at 9:39 am
hi,
look in Book s Online (BOL) for DBCC DBREINDEX. This should help.
Paul
April 24, 2006 at 11:28 am
After reindex only i got above results. but still Extent Scan Fragmentation ...................: 31.57%
April 24, 2006 at 11:59 am
Have you tried dropping the index and re-creating it? I don't know if that will do it but it's something to try.
Regards,
Mark
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply