Clearing dm_db_missing_index_*
It would be great to be able to clear the index utilization exposed by the following DMVs/DMFs:
sys.dmdbindexoperationalstats
sys.dmdbindexphysicalstats
sys.dmdbindexusagestats
sys.dmdbmissingindexcolumns
sys.dmdbmissingindexdetails
sys.dmdbmissingindexgroupstats
sys.dmdbmissingindex_groups
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.
AdminMicrosoft SQL Server
(Product Manager, Microsoft Azure)
shared this idea
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=-=>Hello,
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
1 comment
-
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