Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calculating FillFactor
Message
De
04/01/2001 09:05:19
 
 
À
03/01/2001 23:58:17
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
00458046
Message ID:
00459304
Vues:
25
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform