SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Check when index was last rebuilt/reorganized
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ranvir_2k
Posting Yak Master

United Kingdom
160 Posts

Posted - 10/01/2013 :  11:27:31  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3636 Posts

Posted - 10/01/2013 :  12:28:16  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000