Check when index was last rebuilt/reorganized

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Check when index was last rebuilt/reorganized

Author

Topic

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2013-10-01 : 11:27:31

Hi all,

Is there any way to check when an index was last rebuilt or reorganized?

Is there any query/DMV that will give this information?

Thanks,

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-10-01 : 12:28:16

I was looking for something similar a while ago, and I don't think I found anything satisfactory. You can use STAT_DATE function to see when the stats was updated, and people make use of that - for example, here: http://beyondrelational.com/modules/30/scripts/485/scripts/15577/when-was-index-maintenance-rebuildreorganize-last-performed-on-your-database.aspx However, if I am not mistaken (and my memory is vague on this), it does not capture reorgs; only rebuilds.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources