Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm confused by the results that I'm getting from sys.dm_db_missing_index_stats ...

The following query returns missing indexes that are actually created on the tables.

select * from sys.dm_db_missing_index_details where database_id = DB_ID('DatabaseName');

Has anyone else seen this issue??

Also, I noticed that the duplicate indexes that exist on the database are showing 0 for usage stats.

Any help would be greatly appreciated.

share|improve this question
up vote 2 down vote accepted

There is a bug related to this DMV, please see Paul Randal's blog post

share|improve this answer

Have you validated that the existing indexes are identical in every aspect with the recommendation, and they are enabled?

share|improve this answer
yep, pounded my head against this a few times. indexes are identical in every aspect. i believe that paul randal's blog post referenced above clears things up. i actually blindly applied this index based on the recommendation. i monitor usage stats to ensure that the index supports queries after having deployed. in this case, this appears to be one that is recommended but not used. – electricsk8 Jan 25 '11 at 20:02

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.