10% Fill Factor

  • SELECT COUNT(*) FROM SENTENCE WHERE WORD = 'AND';

    ...

    Seriously, its kinda dangerous to make broad generalizations about things like FILL FACTOR.  Certain tables may be heavy write, others are heavy read.  Some are both.  Bottom line is, good ol' database administration detective work will always win the day.

    SQL Server Performance has an excellent article for determining the fill factor for a given table.

    http://www.sql-server-performance.com/articles/per/index_fragmentation_p1.aspx

    Too low of a fill factor percentage you have internal index fragmentation, too high you have external index fragmentation.  Its just that simple.  This is something you tweak over a long period of time.

    Now... to only get the time to tweak it... that's the real performance nightmare... 

Viewing post 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply