Post reply

Index Properties Fragmentation Page

  • October 19, 2011 at 9:48 am

    #246680

    Hi All

    On the index properties fragmentation page, the top field is for page fullness, I was wondering how SQL calculates this field?

    Looking at http://msdn.microsoft.com/en-us/library/ms188436.aspx it would make you assume that sys.db_dm_index_physical_stats is where it comes from, but I am not to sure.

    I would of thought that the avg_page_space_used_in_percent column is where the information is, but then I execute the function every index has NULL in this column so I just dont know.

    I can't see how any other column or any math functions on any of the columns could come to the value.

    Any ideas?

    Thanks

    Anthony

  • October 19, 2011 at 9:51 am

    #1396742

    It's the avg_page_space_used_in_percent column from sys.dm_db_index_physical_stats

    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

  • October 19, 2011 at 9:56 am

    #1396750

    Thanks Gail.

    I will gladly kick myself now, I forgot to put a "mode" in so was always doing limited and returning NULL.

    I will go hang my head in shame.

    Thanks

    Ant

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

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