Missing Indexes feature request
fatherjack2
Posts: 311
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
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
Senior DBA
Careers South West Ltd
Comments
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com