May 25, 2011 at 7:42 pm
I've checked these but they aren't that helpful...
SELECT * FROM sys.dm_db_index_usage_stats (I mean information from these tables)
As far as I'm aware when ever indexes are rebuilt the statistics get updated,
E.g.
SELECT 'Index Name' = i.name,
'Statistics Date' = STATS_DATE(i.object_id, i.index_id)
FROM sys.objects o
JOIN sys.indexes i ON o.name = 'Address' AND o.object_id = i.object_id;
GO
But I think this is not accurate enough...Because I just want to create a report that I can run to get this information from sql server boxes....
Any help appreciated.....
May 26, 2011 at 3:10 am
Select Name as IndexName,
STATS_DATE ( object_id , index_id ) as IndexCreatedDate
From sys.indexes
Ryan
//All our dreams can come true, if we have the courage to pursue them//
May 26, 2011 at 4:03 am
There is no strict way to find the last rebuil date time info...
Please refer the below links:
http://sqlblog.com/forums/thread/13120.aspx
http://www.sqlservercentral.com/Forums/Topic340343-149-1.aspx#bm340730
May 26, 2011 at 4:27 am
Sumanta Roy (5/26/2011)
Select Name as IndexName,STATS_DATE ( object_id , index_id ) as IndexCreatedDate
From sys.indexes
That is not the last rebuild date of the index, it's the date the statistics were last updated. Since they can auto-update, that could be anything.
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
May 26, 2011 at 4:46 am
thanks Gail.
Ryan
//All our dreams can come true, if we have the courage to pursue them//
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply