1、查看指定对象的所有统计信息
SELECT name, sp.*
FROM sys.stats AS stat
CROSS APPLY sys.dm_db_stats_properties(stat.object_id, stat.stats_id) AS sp
WHERE stat.object_id = object_id('object_name');
2、查找频繁修改的对象的统计信息
SELECT obj.name objname,obj.type,obj.type_desc,obj.schema_id,SCHEMA_NAME(obj.schema_id) [SCHEMA_NAME], obj.object_id, stat.name, last_updated, modification_counter
FROM sys.objects AS obj
INNER JOIN sys.stats AS stat ON stat.object_id = obj.object_id
CROSS APPLY sys.dm_db_stats_properties(stat.object_id, stat.stats_id) AS sp
WHERE obj.type='U'
order by modification_counter desc