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 |
|
john.burns
Posting Yak Master
100 Posts |
 Posted - 2007-11-26 : 11:21:58
|
| all,reindex just ran on friday... how is it possible to have a logicalscan fragmentation of 97% ... is it because fillfactor is set to100 and pages cannot be reorganized any better with this arrangement?thanksTABLE level scan performed.- Pages Scanned................................: 15842685- Extents Scanned..............................: 1981052- Extent Switches..............................: 2071631- Avg. Pages per Extent........................: 8.0- Scan Density [Best Count:Actual Count].......: 95.59% [1980336:2071632]- Logical Scan Fragmentation ..................: 97.91%- Extent Scan Fragmentation ...................: 0.21%- Avg. Bytes Free per Page.....................: 49.2- Avg. Page Density (full).....................: 99.39% |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-26 : 11:23:54
|
| index rebuild or index defrag?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-27 : 02:11:44
|
| Rebuilt clustered index on the table? |
|
|
|
|
|
|
Question on Showcontig stats