Hi all,
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.
Hi all,
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
eg
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.