Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculating FillFactor
Message
From
03/01/2001 07:55:44
 
 
To
02/01/2001 23:06:06
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00458046
Message ID:
00458847
Views:
36
>>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 ???

Maybe I don't completely understand what you're looking for.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform