May 19, 2010 at 2:05 am
Dear All,
Is there a way to clear the missing index usage views.
We worked during last period on index tuning, adding new indexes ,removing duplicate and unused ones.
I need to clear sys.dm_db_missing_index_group_stats ,
sys.dm_db_missing_index_groups and sys.dm_db_missing_index_details
without having to restart SQL server process and without affecting caching on server becuase it will be done on live enviroment.
Thanks in advance and looking forward for ur replies.
Nader Galal
May 19, 2010 at 1:44 pm
The only way I know to clear it is to restart the SQL Server Service.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 19, 2010 at 2:20 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/FindPost924105.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply