Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculating FillFactor
Message
From
04/01/2001 09:05:19
 
 
To
03/01/2001 23:58:17
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00458046
Message ID:
00459304
Views:
24
>Currently the fillfactor of the fragmented table is 0.
>What I'm looking for is a standard formula to calculate the most reasonable fillfactor that I should use.

The fillfactor should represent the volatility of the data and the impact of the implied growth that you're willing to deal with. If you have a table whose size is 100 pages and you recreate the clustered index with a fillfactor of 50, you've created enough space to allow twice the number of rows before node spliting begins but you've also doubled the number of pages (200) and the amount of work SQL Server must do.

I guess the short answer is that I don't know of any formula that will provide you with the optimal fillfactor.

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

Click here to load this message in the networking platform