 SQL Server Administration: Find out when statistics were last updated. Out of date statistics are a common cause of poor performance. Tables that are active should have statistics updated regularly. Use the query below to find out if your databases have old statistics.
USE <<database>>
GO
-- find last time when stats had been updated.
SELECT object_id AS [TableId], index_id AS [IndexId], OBJECT_NAME(object_id) AS [TableName], name AS [IndexName], stats_date(object_id,index_id) stat_update_date, INDEXPROPERTY(object_id, name,'IsAutoStatistics') is_system_generated_stats
FROM sys.indexes WITH (NOLOCK) OPTION(MAXDOP 1)
GO
________________________________________________________________________________ |
