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. Apply regex rules to existing alerts

    Filtering alerts with regex is great for new alerts but it would be better if we could confirm our new command work by running them on existing alerts. Either testing or just been able to the filter the events using custom regex expressions.

    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)
  2. we dont allow ping to cross vlans so i cannot add servers to monitor

    we dont allow ping to cross vlans so i cannot add servers to monitor

    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. auto refresh

    I'd like the Analysis Graph to auto jump to present every 1 mintue

    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)
  4. Raise Free Space alerts on disks that are mounted, rather than simply drive letters/volumes

    In our clustered environments, instances are given a small drive for mounting the larger data/log/etc volumes within them.
    Whilst we always get a "disk full" warning on the mountpoint drives (subsequently disabled), there appears to be no ability to monitor the volumes that are mounted within, where we do care about free space.
    I do see that metrics for IO, latency etc are done on a per volume (not drive letter) basis, so would be great if we could have consistency.

    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)
  5. Analysis Thresholds

    One of the things I like about the free PAL tool, is that you can specify thresholds for each performance counter. Therefore, you can have a customizable red line which appears on your graph to easily tell you if your disk latencies are over 25ms or your free memory is less than 5% - for example.
    I would like to see something similar on the Analysis screen on SQL Monitor. I would like to specify for each machine, SQL Server or Custom metric a warning threshold and a critical threshold. This makes it easier to troubleshoot performance issues as you…

    11 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)
  6. Add "not started within X minutes" delay before SQL Agent status alert raised

    In an unpredictable maintenance window environment, as in, SQL Monitor's abilities in the window setting arena are inadequate, there are a reasonable number of times when SQL Agent is restarted with good reason.

    As alerts are tied to pagerduty, it's a one size fits all Alert at present, which isn't helpful.

    If a "delay emitting Alert for X time periods" could be added to this Alert, the short-duration bounces will go un-alerted, which really helps on call personnel to avoid unnecessary awakenings for "it is of no matter" Alerts.

    In my case, there are 24 recorded incidents of this Alert,…

    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)
  7. Sorting for columns in Host Machine Metrics

    The OverViews page provide lots of useful information about our SQL servers including being able to see all of the disks on the host machines. However the order of the disk names seems random. Can we have sorting enabled in this section so we can sort by space used or Disk

    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)
  8. Add additional perfmon counters

    It would be useful to have configurable perfmon counters available in "Analysis" above and beyond the out-of-the-box counters.

    65 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)
    Daniel Rothig responded

    For SQL Server perf counters, you can create a Custom Metric against sys.dm_os_performance_counters. For Machine perf counters, you have to use CLI at the moment

  9. Easily determine am/pm from the graphs.

    Currently it isn't clear by looking at a graph if the times are AM or PM. It would be helpful if hovering included AM/PM as well as the left and rightmost times shown on the bottom of the graph. It is confusing and takes effort to determine if I"m looking at morning or night.

    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. Login via https

    Is there a configuration setting to force the SQL Monitor login page (or entire site, preferably) to https?

    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)
  11. The "Output" area for Deadlock events should be resizable

    When viewing a Deadlock event, you can go to the "Output" tab to get details on what T-SQL was running when the deadlock occured. However, that window is quite small, and is not resizable.

    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)
  12. REDGATE Monitor 5.1.2.3497 e-mail alert body should give detail with deadlock victim spid and query

    REDGATE Monitor 5.1.2.3497 e-mail alert body should give detail with deadlock victim spid and query

    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)
  13. Overview screen show as a list

    Show the overview screen as a list of servers. If you have a large number of servers to be monitored, there is no way to see all of them at once (other than zooming out of the screen). It defeats the purpose of monitoring if you can't see everything.

    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)
  14. Have audible alerts on SQL Monitor

    It would be very helpful to have a configuration setting to make alerts audible (something like a beep or alarm ring). In the office we have a screen that displays the SQL Monitor where the alerts are only noticed when people look at the screen, which is not very often.

    An audible alert of 'red' alerts would prompt us to action them straight the way.

    32 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. allow more configuration options for the 'Job duration unusual' alert

    The 'Job duration unusual' alert is based off of the last ten runs of a job. I think allowing a configurable number of runs to be a baseline or better yet, the last x runs at the same time of day would be ideal.

    34 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. Monitor if all SQL Server related Windows services are running, especially Redgate SQL Backup Agent.

    I have found that backup jobs fail, due to SQL Backup service not running. Knowing that the service has stopped would be a great metric to have. This could then be extended to monitor other Windows services.

    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)
  17. SQL Monitore: I would like to see the response time I/O of database files.

    SQL Monitore: I would like to see the response time I/O of database files. Currently it is showing only on instance level but how can I see response time of a particular
    database.

    11 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. I only have one SQL Server, take me to the instance Overview instead of global dashboard

    I only have one SQL Server instance, instead of seeing one small bit of info and having to click that in the new global dashboard, take me directly into the instance so I can get relevant info on first login/site visit. Think about your design when we just have one server.

    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)
  19. Group / Sort custom metrics

    We have a lot of custom metrics and the current interface is not robust, being able to group / sort metrics in folders or in a tree would be very useful. Also the selection box in the analysis tab is not large enough to navigate a useful number of custom metrics

    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)
  20. Baseline machine metrics across cluster failovers

    CONTEXT: Using the Analysis graph for historical performance analysis of machine metrics on a cluster that failed over at least once

    PROBLEM: Machine metrics are collected per node. Baselines of only one node can be shown at a time, and so no baseline view of performance on the "active" component can be synthesised.

    EXAMPLE SOLUTIONS:
    • Enable multiple simultaneous baselines
    • Implement synthetic (bimodal) baselines across cluster nodes
    • Provide synthetic metrics for entites on the "active" component of a cluster

    What do you think about these solutions? Got another idea? Let us know in the comments!

    18 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)
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base