Post reply

avg_page_space_used_in_percent column in sys.dm_db_index_physical_stats

  • May 26, 2009 at 12:59 pm

    #384656

    I've query the dm sys.dm_db_index_physical_stats for the column avg_page_space_used_in_percent and I'm getting only NULL values for all my indexes (none of them has a value), those online as well as offline, clustered, heap as well as non-clustered.

    Is this normal and what does that mean?

    I was expecting a pourcent value of the space used within the page of the index.

  • May 26, 2009 at 1:07 pm

    #1000124

    What mode did you specify? If the mode is limited (which is the default) then quite a few of the columns will be null because the leaf pages of the index aren't read.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 26, 2009 at 1:13 pm

    #1000132

    Yes it was in the limited mode. Didn't knew that, now I do.

    Thank you

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

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