Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

up vote 2 down vote accepted

There is a bug related to this DMV, please see Paul Randal's blog post http://www.sqlskills.com/BLOGS/PAUL/post/Missing-index-DMVs-bug-that-could-cost-your-sanity.aspx

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

 
discard

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.