Where I can find report about all recommended indexes?

C145

Now to check if SQL Monitor recommends some index I need to click on single query and check if there is some recommendation.

Is there other place to see recommendations? All in one place?

Jon_Kirkwood

Hi @C145

 

Thank you for reaching out on the Redgate forums.

Within SQL Monitor there is a Fragmented Indexes alert that could be added to a scheduled report. This would appear as part of all alerts in a report tile.

You may be also able to create a custom metric to only show fragmented indexes - https://sqlmonitormetrics.red-gate.com/?s=fragment

 

If this doesn't provide the necessary information we would recommend using SQL Index Manager to scan your estate for recommended fixes to indexes to improve performance. www.red-gate.com/products/sql-index-manager/

 

 If this doesn't fully meet your request on this post, I would suggest voting against an existing feature request or providing your own on our UserVoice site.https://sqlmonitor.uservoice.com/ 

The UserVoice site is managed by our development teams to gather feature & functionality requests from our users to incorporate into our solutions.

 

Having a look at suggestions around indexes & fragmentation I found these links that may be of relevance:

• https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/39619981-add-the-ability-to-report-analyize-index-fragmenta
• https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/2448174-should-have-feedback-on-missing-index-its-great-k
• https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/44832073-fragmented-indexes