>>The FillFactor is a setting the specifies how full to build the leaf level nodes of an index. It is only applied when an index is created and is not maintained afterwards. You would specify a fill factor to account for the growth that a table will undergrow and hence, provided space for new keys, delaying node spliting.
>>
>>DBCC SHOWCONTIG will return information about the fragmentation of your table or index. It will actually show external and internal fragmentation. External being the use of extents and internal referring to the use of space on a page.
>>
>>Refer to the
Scan Density as a measure of external fragmentation and
Avg. Page density (full) for internal fragmentation.
>>
>>-Mike
>
>On 13/11/2000
>Pages Scanned = 1261
>Extents Scanned = 158
>Scan Density [Best Count:Actual Count] = 100.00% [158:158]
>Avg. Bytes Free Per Page = 368.1
>Avg. Page Density (full) = 95.45%
>
>On 25/12/2000
>Pages Scanned = 1848
>Extents Scanned = 242
>Scan Density [Best Count:Actual Count] = 21.94% [231:1053]
>Avg. Bytes Free Per Page = 2182.1
>Avg. Page Density (full) = 73.04%
>
>Is there any formula to calculate the fillfactor ?
For Example
Old Reading = 1261 * 95.45 / 100 = 1204
New Reading = 1848 * 73.04 / 100 = 1350
Difference = 1350 - 1204 = 146
Rate = 146 / 1204 = 0.12
FillFactor = 100 / 1.12 = 89.28
Is this a correct formula ???