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.


679 results found

  1. Showing Unlicensed and will not allow you to stop monitoring

    I added a server that I needed to monitor for a couple hours. When I was done, I swapped out the license and attempted to pause the monitoring to remove the blue banner at the top:

    You have unlicensed servers. Unlicensed servers will not be monitored and will not raise alerts.

    However, I was unable to pause the monitoring as it just refreshed the page, with the blue bar at the top, and the "pause monitoring" button still enabled and "resume monitoring" button still disabled. Ideally, there would be a way to say I don't want to monitor this server…

    4 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. Analysis Graph Tab

    This is about the Statistics for the Disk avg. read and write metrics.

    There are times when based on the results for a server the statistics are presented in seconds. More often than not it will be 0.0, 0.2 sec, etc.

    This is not very helpful, and I often find myself having to download the Export (csv) and get the average.

    It would be much more beneficial to just show all results in milliseconds, or present an option to the end user of seeing ms or seconds.

    Thank you

    3 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)
  3. Group alerts into a hierarchy

    I want to be able to group alerts into a hierarchy so that for instance when a server goes offline, all of the other alerts generated such as instance unavailable are not generated.

    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  ·  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. Set up multiple custom alerts for a single custom metric

    For some custom metrics, the ideal number is not a fixed number. (E.g. ideal number of VLFs depends on log file size). In those cases I write a custom metric that returns a "percentage of ideal number". I like to be warned both when the actual number is too high and when it is too low so I would like to set up two custom alerts for this.

    This is currently not possible without creating a copy of the custom metric, which of course wastes resources. Please consider adding the option to set up multiple custome alerts for a single…

    7 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. I would like to be able to install an update without having to change the browser port.

    I start with port 8080, when installing an update the port is "in-use" so I have to switch to port 8081, with the next update I switch back to port 8080.
    Surely the update should be smart enough to see there is a running process and either disable the web process until the update is finished, or make the update without having to change the port

    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. Be able to report on current alert configuration at All Servers and Specific Servers/Instance levels

    Be able to run a report or create an output file that lists default and customized alert settings at All Server, Server and Instance level (Including notification setup).

    This is a common request from management and at this point the only option I can think is to setup a spreadsheet and start going through all the alerts.

    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)
  7. Sortable columns on the Alert Inbox (Grouped or ungrouped)

    The Alert inbox should be sortable by column.
    It would be much easier to focus on key items if the Alert Text column could be sorted. A straight alpha sort (Asc or Desc) would be great. So for instance a "Long-running query (731)" would sort before a "Long-running query (525)" and all of the "Long-running query" be easy to seledt and clear.

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. Allow custom metrics to be optionally created as "event" alerts rather than default "continuous" alerts.

    I have installed the "Used/available database space increased alert" which alerts when defined thresholds of used space have been exceeded. However, once activated, the alert remains in an active state with no additional notifications (easily missed). I'd prefer to have this metric run daily and notify each time a threshold is exceeded.

    20 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. Option to include @Channel or @User in Slack Channel Notification

    Provide an option for individual alerts to include @Channel or @User to the slack channel notification.

    5 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)
  10. Shift Click to select multiple alerts

    Add the possibility to select multiple alerts by using Shift + Click.
    This was possible in the versions before alert grouping.

    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)
  11. blocked by (number)

    This should be easy to implement..

    "blocked by [some number]"
    If available show the security context/or username associated to the session number.

    It would be a time saver, and enable me to react or ignore faster

    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)
  12. Create Duplicate of Default Alerts

    Hi, it would be great to create 2 Default alerts with deffernt setting for differnt servers
    and to seperate AO Group when creating Alerts
    so that a Backup Replica wont go into some alerts that serve the production Servers

    4 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)
  13. be able to be advised if a certain query (sql_handle or query_hash) is suddenly taking much longer than normal to execute. Not only to see

    I would like to be able to be advised if a certain query (grouped by sqlhandle or queryhash) is suddenly taking longer than normal to execute.

    The query may or may not be included in the top 10 queries.

    /Rasmus

    6 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. Remove a user/group from SQL Monitor

    It would be desirable to be able to remove a user and/or group from SQL Monitor.
    At present, there are no options to manage them, only add them.

    7 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)
  15. View trace queries without alert

    It would be nice to be able to view Trace queries without an alert. For example a separate page to go through the queries against the DB even when an alert is not raised.

    6 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. Is it possible to have long running queries order by Execution time desc ?

    Is it possible to have long running queries order by Execution time desc ?

    1 vote
    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. Per database table fragmentation.....

    I would like to see a a Sql Monitor "information" page that shows the "top 10" fragmented tables on a per database level.

    110 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. Include instance-specific name (@@SERVERNAME) on alert mails

    The alert mails for a SQL Server cluster contain the cluster name but not the actual instance virtual name. It would be nice if the mails contained the actual virtual name (as given by "select @@servername") so that the email contained all the details needed to connect to an alerting instance.

    My cluster name (i.e. CLUST01) is a different IP than my virtual names (i.e. VIRTUALSQL01), which means that I can't connect to my "FOO" instance by "CLUST01\FOO" as the alert email seems to indicate. Instead I need to connect via "VIRTUALSQL01\FOO" which is not present anywhere in the alert…

    20 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)
  19. Monitor for unavailable disks

    I'd like to see SQL monitor check for disks that were previously available but are no longer. Example: I have a machine were a disk is online, something goes wrong and the disk goes offline. I would like SQL monitor to alert me to this. If the disk contains database files I would get a database unavailable alert, however if it is a drive that holds backups there would be no notification until the backups start failing.

    This would have to be setup differently for clusters where a disk may exist on any node in the cluster due to failovers.

    7 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)
  20. Blocking process Hover Information should show Total Blocking Duration

    The (Restored in 8.0.6) hover over the Alert List's "Last Updated" column shows the duration of the Alert itself, NOT the total time involved.

    Unless you memorize the configuration of this Alert for each of its 3 severity levels, and assume they never change, and never vary by server, nor by database... you must sill open each event to see the "Total blocking duration for all descendants" published under the "Details" tab, then add that to the event duration, for which you must now do time subtraction as there is no "Duration" on the Status line... (another omission).

    Having to…

    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  ·  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