What are the challenges you face when working across database platforms? Take the survey

Missing Indexes feature request

fatherjack2fatherjack2 Posts: 311
edited February 13, 2009 12:34PM in SQL Monitor Previous Versions

would it be a useful feature to include a list of missing/potential indexes for each database in the recommendations view?

Parameters could be user configurable for predicted impact/benefit or maybe top 5 so as to avoid over indexing.

All the data is availalbe from sys.dm_db_missing_index_groups, sys.dm_db_missing_index_group_stats and sys.dm_db_missing_index_details that once a week a recommendation of improvements to indexing could be relevant.

I guess working on from this it would also make sense to include unused index details too - from dm_db_index_usage_stats this time...

any votes from anyone else?


Senior DBA
Careers South West Ltd


  • Options
    Eddie DEddie D Posts: 1,789 Rose Gold 5
    Thank you for your suggestion.

    I have submitted a Feature Request "To include a list of missing / potential indexes for each database in the recommendations view" for the development team to consider.

    The reference number for this request is SSR-1445.

    I cannot guarantee that the request submitted will be successful or if approval is given, what future version of SQL Response the requested feature will appear.

    Many Thanks
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.