Skip to content

Suggestions

Welcome to the Redgate SQL Monitor feature suggestions list. Tell us how we can improve SQL Monitor by voting on these suggestions or by submitting your own ideas.

This is the easiest way to make an impact on SQL Monitor’s roadmap. Check out the completed suggestions to see how your ideas have influenced us in the past. Please note that this list is one of multiple sources that drive our development, meaning that we will not always implement the highest-ranking suggestions.

To give your idea the greatest possible impact, please follow these guidelines:

  • Describe the goal you’re trying to accomplish, rather than a specific solution to get there
  • If you have a favoured solution, add it as a comment to your suggestion
  • Give us as much context as possible
  • Only make one suggestion per post. If you have multiple ideas, submit them in separate posts
  • Comment and vote on existing posts to develop the ideas — often the SQL Monitor team will initially stay quiet about new suggestions to see what you have to say!

If you have any questions visit the SQL Monitor forum.


683 results found

  1. Monitor Table Growth and get projections

    It would be nice if in the Estate tab under disk usage, we could dig deeper and see table growth and projected growth over time.

    19 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. have the ability to customize browser tab labels

    Provide the ability to label browser tabs to indicate contents, such as "Host101 Disk Activity" or "Host102 Database Transactions" or "Host103 Disk Usage"

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. I would like to do some custom filters of 'Alerts raised or updated in the last:'.

    I would like to do some custom filters of 'Alerts raised or updated in the last:'. AND also be able to do range filters for them eg 2am to 6pm.

    We are 24/7 DBAs at a big bank in South Africa and we want to be able to see whats alerts came through our individual shifts.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. Add the ability to report/analyize Index fragmentation

    I would love to see the ability to see the Index Fragmention results in the report/anayize feature. I have been fighting index fragmention but cant really tell how much it has improved.

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. Command Line Install

    I'd like command line installation to be an available option for SQL Monitor as I want to automate and script it, rather than having to do it manually

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. SQL Monitor Audit Trail

    It would be nice to have an audit trail of changes in SQL Monitor. For example, if an alert is changed, a new instances is added/removed, or users are added or removed.

    23 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. Monitor database total space usage not by individual data files.

    I have many databases that we are monitoring for space which have multiple datafiles. Usually most the datafiles are full but at least 1 of the files is able to autogrow. Sometimes autogrow has reached its max limitation and sometimes we have turned it off once the file reached the largest size we will allow it. Our goal is to monitor so the database does not run out of space. We currently get alerts for the files that are full, we know some are full, we aren't worried about them, we still have 1 or 2 files we allow to…

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. Configure Different Emails for alert levels

    Allow for customization of emails for alerts at each alert level, so that I can send to different emails for each alert level.

    So that I can send High alerts to one email address, medium alerts to another email address, etc…

    57 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. see Lock Escalations/sec as available metric in analysis graph

    The customizable analysis graph does not include the option to display Lock Escalations/Sec (\SQLServer:Access Methods\Table Lock Escalations/sec). I like to compare this to baseline to regression-test releases. In conjunction with waits\locks, it can also warn the user that an index is no longer being used (as would happen if Entity Framework began searching a varchar column for an nvarchar value).

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. See data in local server time

    I'd like to all the data from a particular server in local server time instead of my time

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. Remove single AG replica

    Currently when adding an Availability Group it automatically discover and add all replicas which is great.

    However sometime we might not want all replicas to be monitored, in our case it's because of limited bandwidth on a certain asynchronous node. While it is indeed possible to "Pause Monitoring" on that node, it would be nice to be able to delete it completely (using some kind of exception list so it's not re-added automatically).

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. Do not uncheck alarms after entering a comment

    Scenario: Let's say there are 15 related alarms in the alarm inbox on which you want to add a common comment and then clear.

    Currently you would check the 15 alarms, click on the comment button and enter your comment. Unfortunately at that point it would uncheck all the selected alarms and you would need to check them again to clear them.

    After entering a comment I would like the current selection to stay checked.

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. update alerts

    When you go into an alert, would it be possible to have a button that can fire off and get the current value as it is now. For example, the attached was raised but may not get picked up for whatever reason until the Monday, if I could refresh the values that would be great as an index main task may have happened between the alert and when I get to it. Hope that makes sense?

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. Manage Scheduled SQL Monitor Reports from one overview page.

    It's easy to set up a new report and schedule for SQL monitor reports. But once schedules are created it's difficult to manage them.
    Have an overview page that would allow you to see all that has been scheduled .... giving options to:
    1) Delete individual schedule (e.g. following server decommission or server no longer monitored).
    2) Edit individual report schedule ... e.g. change time / frequency and for a particular type of report change the target server for that report ... i.e server replaced, being able to move report from reporting on original server report created for to replacement…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. Utilize in SQL Monitor Analysis or Reports pages any SQL Server counter available in PERFMON.

    For instance BRENT OZAR has an excellent method to diagnose memory pressure. The counter in use is SQLServer: Memory Manager – Memory Grants Pending which is not available.

    If Memory Grants Pending is averaging over 0, queries can’t even start because they can’t get enough memory. You may have queries that have incorrect memory grants, or you may just desperately need more RAM.

    30 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. ADD Support for GCP Cloud SQL (MSSQL managed instances)

    As Google Cloud Platform increases their market share and adds features such as managed instances for Microsoft SQL Server, it would be great to have the ability to monitor those as well.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. silence alerts for x hours

    If an alert is firing repetitively for say a job failure, to be able to silence the alert for a number of specified hours (not permanently) if you know it will recover later, but you don't want to disable the job - just want the alerts to stop temporarily

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. Ignore Negative Custom Metric Collection

    I am trying to add a custom metric based on the sys.dmosperformance_counters DMV. These are very useful for gaining Instance Level information. These counters increment as each lock is requested. I have used the “Use a calculated rate of change between collections” option which accurately depicts the graph I am trying to accomplish. The caveat is that these counters are reset to 0 when the instance is restarted. Therefore in any of my graphs, I get this huge negative value. This basically renders the metric useless because I cannot visualize any metrics once a server is rebooted.

    Is…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. MONITORING ERROR (SQL SERVER DATA COLLECTION) more infromation

    Is it possible to list the items that failed in the alert?

    In the description for this alert it notes that one or more of the following connection methods failed:
    WMI
    Remote registry (PerfMon and registry access)
    Remote file access is not set up (hidden administrative shares should be enabled)
    SQL connectivity

    Is it possible to note in the alert details which one failed? It would make troubleshooting after the fact a bit easier.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. Show alert bubbles in other metrics, too

    I like seeing the alert bubbles in the main overview. It would be helpful to also be able to see them in the additional metrics shown below. Anothe option would be to align these other metrics with the main 4-metric window.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base