Post reply

Table Fill Factors

  • November 24, 2009 at 7:53 am

    #156432

    Hi,

    How can one calculate the right fillfactor for a table? I know that its not a straightforward thing but if there is a method of knowing whats best for a table, please advise.

    Also if a table fragments quickly, how can that be resolved?

    Thanks

  • November 24, 2009 at 8:50 am

    #1083508

    There isn't necessarily an easy way to dot his. If you have a read only table, set it to 100. If you have one that heavily changes, you will likely want something lower. If you have no idea, start at 80, measure page splits and fragmentation over time and then decide if you need to raise or lower it.

    If it gets fragmented, rebuilding the clustered index helps.

Viewing 2 posts - 1 through 1 (of 1 total)

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