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.


  1. Monitor Disk Overallocation

    Recently we ran into disk space issues on a server. Looking into that, it was discovered that a 10TB database had 3TB in "Unused" space. That is the space was allocated to a table, but the table needed to be reorganized to recover the space. sp_spaceused shows this space, and a disk report of top tables clearly showed the Unused space. This was not something that Redgate noticed. Going back over our estate, we discovered there were more such databases where we could recover space. This could also be noted at an individual file level. Reorganizing that one database has…

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Email queuing

    Basically, I would like email to queue up in SQL Monitor. In the event an email fails to send (account locked out, mail server down, etc), having the email just fail to send is not the desired result. When problems are resolved, the email should send.
    For example, lets say IT is doing scheduled maintenance on the email server and during that window one of the SQL instances shuts itself down due to an error (for arguments sake, lets say out of disk). SQL Monitor will see it go offline and try to send out the alert but fail because…

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. see an administrative web-based log viewer

    Having the ability to review logs in a web-based interface is useful for administrators of a tool so we can diagnose and remedy some problems without needing to reach out to support. The downside is the log needs to be filterable or multiple log files need to exist.
    An example of a log that would be useful would be an email log. In the event an email fails to send, I'd like to know why without needing to download the entire log in a zip, extract the zip locally, and browse through it when I am looking for a specific…

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. A way to showcase all SQL Statements running for a specific time frame

    A way to showcase all SQL Statements running for a specific time frame. This is will be helpful to investigate any issue that occurred in the past.

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Suspend Monitoring of Individual Cluster Nodes

    Alert suppression windows can be applied to groups, clusters, instances, and machines - including individual cluster nodes. Howerer it seems it is only possible to suspend monitoring for instnaces or clusters not individual nodes,

    We recently had a hardware fault and it would have been helpful to suspned monitoring of a specific node whislt the engineer resolved the fault.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Long-running query Alert - time based parameters

    I need to disable monitoring long running queries at night.
    My proposal is that you could add new parameter to alerts
    Time from - Time to which will exclude monitoring during this time.

    That will help to exclude ETL - ssis, and other long rununig queries which we set up at night.

    6 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  ·  Flag idea as inappropriate…  ·  Admin →
  7. Add User Settings feature

    Add a User Settings feature that will hold all user preferences, as different DBAs / users have different ways in using SQL Monitor. For example - (1) ability to display on the Overviews page only desired health levels (Critical, Warning, etc), or named group, or base monitor, or any combination, rather than load all servers from all groups from all base monitors. I really don't want to know that I have 265 healthy out of 275 servers - this will speed up loading of the Overviews page. (2) any other user preference.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Be able to schedule a maintenance window with the possibility to use an offset.

    Be able to schedule a maintenance window with the possibility to use an offset. Say every 3rd tuesday of the month + 12 days.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Top 50 Queries should ignore queries that runs with explicit "waitfor"

    The query that runs with explicit "waitfor" should not be included in the top 50 query report.

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Service Level Agreement Metric Report

    The following contract metrics are common to many US Government clients. It would be very helpful (and a real time-saver) if SQL Monitor had report that could provide the below listed SLA's in a monthly email to an editable distribution. The report should be .pdf or .xlsx format, with layout intended to communicate to executive audiences. The setup for the report should allow comparing baseline dates. Thanks in advance for considering this idea.

    • List of database instances
    • Database uptime
    • Components that are reaching capacity
    • Computer resources growth
    • Reserve capacity
    • Throughput I/O
    19 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Control the delay before getting "Error on Base Monitor"

    We have perhaps a unique use case where one of our Base Monitors is at a remote site with a very high latency (700+ ms). Monitoring works surprisingly well since one of the later updates but unfortunately we are getting regular “Error on Base Monitor” emails (10+ per day) even though the connection itself is stable (just very slow).
    We would like to be able to control the delay before that error is raised, I’m guessing that slightly increasing this "timeout" would fix all our issues.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Add counter [forwarded_record_count] to Analysis page

    As you describe in this article: https://www.red-gate.com/simple-talk/sql/database-administration/sql-server-heaps-and-their-fragmentation/

    forwarded-record-count From sys.dm-db-index-physical-stats

    Please add forwarded-record-count to Analysis page

    Thanks guys!

    14 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Detailed Memory usage breakdown

    I would like to see a breakdown of memory usage. For example, how much memory is used by the plan cache, how much for the buffer pool, etc.
    Also, a breakdown of memory usage per database.

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. list, and get alerts from the SQL Monitor API.

    Add possibility to list, and get alerts from the SQL Monitor API.

    This so we more easily can share and distribute alerts to a users that shouldn't have access to SQL Monitor.

    In my org we have a lot of developers, and a lot of different databases that are hosted on the same clusters, I want the possibility to send more direct alerts and messages to these users.

    23 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Please add granular details on memory and processor usage

    Please add granular details on memory and processor usage to display resources used by each individual process

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Display maintenance windows on timeline

    When looking at the timeline graph with the CPU/IO/Waits stats it would be very nice to see the maintenance windows, for example as a difference background color.
    This would help immediately recognize why IO is spiking for example. I realize that can also be accomplished with the Baseline for regular maintenance but I don't see it as mutually exclusive since a maintenance window can be configured at any time.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Availability Group alert details

    It would be great to see the server name in the mail body which is affected by the alert. Currently it is only in the subject. EG: Raised on detail i the mail body contains the primary replica, the affected unreachable replica is only in the subject.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  18. Report that shows top 50 long running queries across the estate

    Submitting an enhancement request to expand the reporting capabilities for long running across the entire estate. The report tile only show a handful. It would be very useful to be able to run a report listing the top 25, 50, etc long running queries across the entire SQL estate. The data is available somewhere but instead of going into each instance a consolidated report would be greatly beneficial is order to identify queries for performance review. We are also going through an upgrade and are identifying queries to benchmark for before and after performance to ensure there is no degradation.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Have a parameter for status/severity colour

    when using slack notifications messages are automatically coloured red/green for failed, ended.

    Like a lot of companies we're migrating to Microsoft Teams and whilst we can use the Webhook stuff to reproduce most of the slack alert for Teams we're not able to colour code the alert based on status. Having a new parameter for status-colour and severity-colour would really allow us to clean this up.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Have a custom message added to alerts

    When an alert is emailed, I want to place an action (possibly including an html link) as a comment on the alert.

    This would allow the recipient of the alert to solve the issue directly.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base