Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-04-18 : 02:25:50
|
| Hi The following is the result of the DBCC ShowcontigDBCC SHOWCONTIG scanning 'publishers' table...Table: 'publishers' (2057058364); index ID: 1, database ID: 5TABLE level scan performed.- Pages Scanned................................: 1- Extents Scanned..............................: 1- Extent Switches..............................: 0- Avg. Pages per Extent........................: 1.0- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]- Logical Scan Fragmentation ..................: 100.00%- Extent Scan Fragmentation ...................: 0.00%- Avg. Bytes Free per Page.....................: 7699.0- Avg. Page Density (full).....................: 4.88%Now as a per a Doc i read the Scan Density should be 100%Logical Scan Fragmentation should be from 0-10%Extent Scan Fragmentation should be 0%Here Logical Scan Fragmentation ..................: 100.00%So I ran the DBCC INDEXDEFRAG commandStill its showing the same results, can someone explain , should it not become 0-10% I even tried the DBCC DBREINDEXNo Effects Please Advice. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-04-18 : 05:43:30
|
| Did you update the stats? |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-04-18 : 08:10:18
|
| It won't do anything / tell you anything useful until you've got several pages in the table / index - looks like you've only got a handful of records in that table?Kristen |
|
|
|
|
|
|
DBCC ShowContig