Post reply

Determine last index rebuild or reorg

  • January 5, 2012 at 10:46 am

    #248596

    Hi. Would sys.dm_db_index_usage_stats.last_system_update be the place to look for the last time an index got rebuilt or reorganized? From there chain to sys.tables and sys.indexes for table and index name?

    Thanks,

    Ken

  • January 5, 2012 at 10:50 am

    #1429208

    No.

    Unless you keep a record, there's no history of when an index was created or rebuilt.

    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