Post reply

Current Fill Factor

  • October 17, 2011 at 9:10 am

    #390636

    words of wisdom if you please .....

    Is there anywhere/way I can determine the current fill factor per index rather than the fill factor that was originally specified ?

    thanks simon

  • October 17, 2011 at 9:24 am

    #1395403

    I think this is a trick question 🙂 FILLFACTOR specifies a percentage that indicates how much the Database Engine should fill each index page during index creation or rebuild. Therefore, there is no "current" FILLFACTOR vs what was originally set. So, maybe you are asking for the amount of space that is free on a page at this particular point in time?

    Thanks,

    Jared

    Jared
    CE - Microsoft

  • October 17, 2011 at 9:26 am

    #1395405

    sorry yes phrased rather badly ... the current amount of free page space

    I hang my head in shame

  • October 17, 2011 at 9:28 am

    #1395408

    I'm not sure that this is exactly what you are looking for... but sp_spaceused may be your best bet.

    Thanks,

    Jared

    Jared
    CE - Microsoft

Viewing 4 posts - 1 through 3 (of 3 total)

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