Home Forums SQL Server 2008 SQL Server 2008 Administration Reset Index Usage Counters RE: Reset Index Usage Counters
SQLSACT
SSC-Insane
Points: 21838
More actions
April 4, 2013 at 7:42 am
#1603558
I could be wrong but I'm sure that between sys.dm_db_index_physical_stats,sys.dm_db_index_operational_stats and sys.dm_db_index_usage_stats - 2 out of the 3 are reset when the indexes are rebuilt. Not 100% sure though