December 20, 2010 at 7:42 am
JottoMagic (12/17/2010)
I have found that the "magic number" for FF would be the amount of index space that needs to be available between index rebuilds. Our indexes grow approximately 4% per week (8% every two weeks), so I have a FF of 90%.
+1 for the general methodology: I've seen automatic index maintenance jobs which have the SQL Agent Job Step Advanced "write output to log file" enabled, and they record the scan density, logical fragmentation percentage, index size in pages before the reorg/rebuild, and current fillfactor of every index they cover.
Every once in awhile, the logs are reviewed, and indexes that are reorganized or rebuilt "too often" get a lower fillfactor. Watching the results, the lower fillfactor index size is (almost) always smaller than the size the index grew to between reorg/rebuild runs.
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply