It would be great to be able to clear the index utilization exposed by the following DMVs/DMFs:
This is the scenario:
As a consultant you suggest some changes in the indexing strategies for a client.
you want to "reset" the counters such us index usage, physical operations, missing indexes, etc.
On the other hand, I don't know the cost of the implementation, but it would be nice to be able to reset the values at database level, or at instance level.
Upvotes: 34<=-=Feb 6 2008 10:15AM=-=>
Eladio – Thank you for using Microsoft Connect.
We agree the feature you requested should be useful, but we did not have the resources to do it in SQL Server 2008. We will keep your suggestion in mind going forward.
As always, we appreciate your valuable input.<=-=May 9 2014 4:46PM=-=>
After carefully evaluating all of the suggestion items in our pipeline, we are closing items that we will not implement in the near future due to current higher priority items. We will re-evaluate the closed suggestions again in the future based on the product roadmap.
Thanks again for providing the product suggestion and continued support for our product.
Jos de Bruijn – SQL Server PM
Daniel van der Meulen commented
Something like DBCC SQLPERF("sys.dm_db_missing_index", CLEAR) would be really nice to have. Until that time you can use my sp_clear_missing_index procedure. It's free on https://github.com/daniel70/sp_clear_missing_index