I want to know when the statistics has been updated last in the production database.Is there any DMV to check? or should we create a table with time stamp to record the information.Thanks in advance.
you could use STATS_DATE described here http://msdn.microsoft.com/en-us/library/ms190330.aspx
USE AdventureWorks; GO SELECT name AS stats_name, STATS_DATE(object_id, stats_id) AS statistics_update_date FROM sys.stats WHERE object_id = OBJECT_ID('Person.Address'); GO
No one has followed this question yet.