Missing Index Advisor

The Missing Index Advisor analyzes the details on the missing index and offers you suggestions on different indexes that could be added in order to cover the missing index.

Beware:  Just because an index is missing doesn’t mean that adding the suggested index is the best idea.  Be sure to understand why the index is being added, and if possible track down the query that needs the missing index.  Sometimes it is better to clean up a query instead of just adding a missing index.  Also, before adding any index to a production server, you should test to confirm that the suggested index will get used.

You get to the Missing Index Advisor from the Missing Indexes Report.