How do you use cloud databases? Take the survey.
Where I can find report about all recommended indexes?
C145
Posts: 1 New member
in SQL Monitor
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?
Is there other place to see recommendations? All in one place?
Tagged:
Answers
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: