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. Add a description for users in the manage users for active directory

    In some environments, the user login doesn't necessarily match the true user's name. This would help navigate what the user is assigned to that specific account.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Exclude System Databases (and potentially other user databases) from backup alerts

    We would like the ability to exclude system database from the backup alerts, as we do not back them up. We have a system in place to script out security and sql agent jobs/schedules for each of our systems nightly. We also have been leveraging the dbatools PowerShell stack as a way to automate server migrations and other automation activities. Also, our tier one systems are in availability groups. Lastly, we do not backup everything in our lower level environments, as we perform nightly database refreshes for the majority of our systems. However, we do have some testing databases that…

    8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Job Duration Unusual: ability to set different thresholds for different jobs

    Some jobs that take a few minutes, others routinely take a longer time to run, and so it would be useful to set different thresholds for different jobs.

    The current set up allows for excluding jobs from the alert, but offers no way of still monitoring those jobs.

    I only want to exclude the jobs from monitoring, only if its possible to add in another alert just for them.

    The documentation seems to hint that you can configure different alerts for different jobs, but all I've found is the high medium low thresholds, and this isn't the same.

    This combined…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Export a Databases report to Excel including Name, Availability, Transactions/sec and Database size for any time period

    In SQL Monitor I want to export a Databases report to Excel including Name, Availability, Transactions/sec and Database size for any time period. You can see this data and screenshot it, but it would be much more professional, useable and positive for management if I could deliver it in Excel instead of combining screenshots.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Suppress Free Space monitor (Azure Hyperscale DB)

    When using Azure Hyperscale DB - the DB auto grows - therefore the Free Space monitor needs to be silenced/ignored forever (except if you about to hit the max of 100TB!)

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Alert for full filegroup

    if a database is a fixed size (max size set), or if the db is initially set to be the full size of a disk, there is no alert to let us know that the database is full.

    for instance - if T: drive contains tempdb (and only tempdb) and we've sized it to take the whole drive. we've done funky sizing and growth settings so we can get an alert when the db grows, but once its grown and the temp objects are cleared, we're unlikely to get another disk warning, because the DB will already be taking 100%…

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Filter for Database with no Tlog backup

    On the Estate->Backup page, it would be great to have an additional drop-down option for 'DBs without Tlog"

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  8. Configure job duration unusual alerts to ignore negative variances

    Typically (although there are exceptions) I'm not concerned if a job has a high negative variance compared to baseline. One other way to satisfy this would be another suggestion already in here, allowing for more configurable options such as a floor/ceiling variance .

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Webhook notifications need to be configurable at an alert level

    While Webhook notifications is a cute idea, it has no value to me if I can't customize what alerts get it. Please add a Webhooks column to the individual alert settings.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Understanding what caused the Diskspace alert

    When viewing a disk space alert, it would be very useful to view the disk space usage for the drive the alert is raised for?

    Ideally I'd like to to be able to get to the page: the Estate | Disk usage | [and filtered for the Specific Server: Drive:]

    I understand that on the detail page of the server, you can see the growth of the databases for the selected time period, but its not always db files that cause the alerts.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Ignore failing jobs using regex

    the config for JOB DURATION UNUSUAL alerts allows the use of regex to filter the jobs to ignore.

    this functionality would be very useful for FAILING JOBS alerts

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Frequency of the customer metric

    It would be useful if we can specify frequency less than 1 minute in the custom metric. Because sometime we need to check any metrics more than once a minute.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Automatic failover when GEO replication is set up for PaaS servers

    It would be great to have a feature to monitor automatic failover when GEO replication is set up between PaaS servers.

    It is quite useful information to understand if failover occurs.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. It would be a great feature to have SQL Monitor suggest efficiency recommendations. The way that vperformance tuning settings based on acon

    It would be a great feature to have SQL Monitor suggest efficiency recommendations the way that vRealize Ops Manager does, which is basically a tool you point at the environment and it shows you efficiency recommendations. Rather than having to perform time consuming manual analysis.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Monitor individual CPU cores and not just avg CPU as a whole

    AVG CPU is not enough of an indication of how things are going - There could be an entire numa node maxed at 100% while other nodes are almost idle and it will drag the avg down.

    As per here: https://forum.red-gate.com/discussion/comment/162141#Comment_162141

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Alert for the jobs that is sucessful but with warning or a step level having issue

    Alert for the jobs that is successful but with warning or a step level having issue . currently this is only shown as warning in the Estate > Backup tab

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Recognize Low Alerts visually in overview

    Low Alerts show as blue dots on the Latest Alerts panel, but in the overview they show Green like Healthy.
    Especially when showing Small Tiles (we monitor 60+ instances) they do not stand out from Healty ones (see the attached examples).

    For that reason I dont use many Low Alerts.
    It would be more consistent to use blue in the overviews also.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. search Top Queries

    I have a process that reports on stored proc outliers. When I go to SQL Monitor, it is very difficult to search the top queries to find the particular stored proc.

    For instance, if I do a ctrl+f and search for "I.Invoices", the search may find that snippet in "hidden" areas (in the dropdowns) but I cannot tell where the found items are.

    A query syntax search of the top queries would be extremely helpful.

    8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Be able to give users different access to different groups

    I would like to be able to give some developers Read-only access level to some servers (or server group). For example Production servers.

    But give them Standard access level to other servers (or server group) so they can clear alerts for example and configure their own alerts.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Like Installed Version can there be tab to show the latest security patch being installed

    Like Installed Version can there be tab to show the latest security patch being installed . A very good report for audit compliance

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 25 26
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base