Rebuilding an index clears stats from sys.dm_db_index_usage_stats - by Joseph Sack

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 739566 Comments
Status Closed Workarounds
Type Bug Repros 22
Opened 4/27/2012 12:08:27 PM
Access Restriction Public


Rebuilding an index clears any existing row entry from sys.dm_db_index_usage_stats for that index.  This was not the behavior in SQL Server 2008.
Sign in to post a comment.
Posted by Torbenmikkelsen on 7/30/2015 at 11:41 PM
The problem is still i SQL2014 RTM.
Posted by Nizamettin Özpolat on 5/22/2014 at 1:00 AM
This is something not acceptable. sys.dm_db_index_usage_stats must be persistant. Please reopen this as bug and fix it.
Posted by Kalen Delaney on 1/27/2014 at 10:18 AM
What if they just added a column telling us when the stats were last reset/cleared?
Posted by RobNicholson, MCSM on 5/4/2013 at 12:04 AM
This problem still persists in 2012 SP1 CU3. This issue makes it very hard to know which indexes are not being used. A similar behavior occurs with dm_db_index_operational_stats (this is stated in Books Online though).
Posted by Patrick Keisler on 12/18/2012 at 6:38 PM
Nothing has changed in SQL 2012 SP1 (11.0.3000). The stats are not persistent.
Posted by Phil Brammer on 10/31/2012 at 10:54 AM
Confirmed that this is still the case after applying SQL 2012 CU4 (11.0.2383).
Posted by Timothy Ford on 8/16/2012 at 12:09 PM
This is really bad for all those proactive SQL Professionals that use the usage stats when doing performance tuning and pruning of unused/low-use indexes. Please remove this new "functionality" from SQL Server 2012.
Posted by Kendra D Little on 8/16/2012 at 11:25 AM
I have been able to reproduce this on SQL Server 2012 RTM.