Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a fairly simple query using sys.dm_db_missing_index_group_stats that identifies missing indexes in my SQL Server database. This is pretty commonly used. My question is how do I identify which of these indexes are important and should be created and should I just create them all or are there any other secrets? Anything I specifically should look for in the avg_user_impact or avg_total_user_cost columns?

share|improve this question
add comment

migrated from stackoverflow.com Mar 27 '13 at 6:14

This question came from our site for professional and enthusiast programmers.

1 Answer

Kimberly Tripp did a few very good video's on Index Analysis that covered your question extremely well as part of the MCM Readiness videos.

Indexing Strategies Demo
Indexing Strategies
Index Analysis

Among other things she said DO NOT just create all of them. Review each one and compare it to your existing indexes, review it's cost etc. I highly recommend them and best of all they are free!

share|improve this answer
add comment

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.