Post reply

Analysing dm_db_index_physical_stats result.

  • November 29, 2010 at 2:33 am

    #388323

    Hi All,

    I queried "dm_db_index_physical_stats" for a particular index and got the following values,

    [p]

    avg_fragmentation_in_percentavg_fragment_size_in_pages avg_page_space_used_in_percent

    ==================================================================================

    95.33411489 1.038218111 43.02531505

    100 1.243902439 57.46886583

    0 1 17.40795651

    After rebuilding the index again queried the same and got the following.

    avg_fragmentation_in_percentavg_fragment_size_in_pages avg_page_space_used_in_percent

    ==================================================================================

    27.92297111 3.043963712 84.16702496

    100 1.666666667 58.82085495

    0 1 8.685446009

    [/p]

    Can you pls let me know how to analyse this.? Values in first row is OK, I understand it.

    But 3rd row is quite confusing. Why the value has been reduced to '8.685446009' .? I am not clear.

    Do we need to look into only the first row ???. Please help.

    Thanks.

  • November 29, 2010 at 3:01 am

    #1256153

    Duplicate post. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1027192-146-1.aspx

    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

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

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