How can we help you today? How can we help you today?

Missing Indexes feature request

Hi,

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?

cheers
Jonathan
fatherjack2
0

Comments

1 comment

Sort by
  • Eddie D
    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
    Eddie D
    0

Add comment

Please sign in to leave a comment.