Post reply

Index Usage

  • October 22, 2012 at 11:56 pm

    #393442

    Hi All

    When using the sys.dm_db_index_usage_stats DMV to track Index Usage, is the user_updates column just for updates to records in the table or does it also contain the cumulative inserts as well?

    Thanks

  • October 23, 2012 at 12:39 am

    #1551738

    The number of times index has been used in an update operation (this counts inserts, updates, and deletes) along with the time of the last update

  • October 23, 2012 at 2:31 am

    #1551777

    Inserts, updates and deletes. In this case, update means change, and the index is changed by all 3 of those.

    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 23, 2012 at 2:36 am

    #1551783

    GilaMonster (10/23/2012)

    Inserts, updates and deletes. In this case, update means change, and the index is changed by all 3 of those.

    Thanks for this

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

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