Where I can find report about all recommended indexes?

• 

  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

   

  Jon_Kirkwood October 11, 2023 07:06

  - 0 +

Add comment

Please sign in to leave a comment.