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.


198 results found

  1. Relative-day maintenance windows

    Rackspace maintenance days revolve around, for example, "Default week - Wednesday - 02:00 to 04:00", where "default week" is established in the service contract. That can change to early-week or (I forget the name) "late-week".

    Current SQL Monitor Maintenance Windows are wholly inadequate to record a "Default week is 2nd week of each month, maintenance on that week's Wednesday, at (the time period)".

    Without this, my PagerDuty Alerts go berserk during maintenance windows, and shy of having someone go and suspend monitoring at 2 in the morning and remember to turn it back on, it just keeps on sending out…

    8 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)
    completed  ·  Neil Turner responded

    Thanks for this suggestion. SQL Monitor 10 now allows teams to suppress alerts, or just their notifications, over certain periods using alert suppression windows. Please see What’s New in SQL Monitor 10 for more details (https://www.red-gate.com/hub/product-learning/sql-monitor/whats-new-in-sql-monitor-10).

    We hope this meets requirements and will mark it as completed. Please raise further suggestions for any improvements you would like to see.

    Thanks,

    SQL Monitor product team

  2. Allow option to exclude Integrity Check Overdue Alert for read only databases

    An alert configuration option should allow
    a database status to be checked when querying for last good integrity checks and read_only databases could be excluded from the alert. Even when integrity checks are performed on read only databases, the last checked date is not updated resulting in unnecessary alerts in most cases.

    8 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. Ability To Alias PaaS (SQL Azure) Instances

    You currently can alias IaaS instances but the option does not show up if it is a PaaS instance.

    8 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)
  4. Order databases alphabetically in the Analysis view

    In the analysis tab, when you select the metrics and the server, where there is a database list, the list of databases is not ordered alphabetically. It would be much easier to find the database you want to look at if it was ordered - especially on servers with lots of databases.

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  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)
  5. Enable changing Alert levels on Clock Skew alerts

    I would like to be able to change the alert level from high to medium or even low.
    It would be nice if the alert level would be set depending on the skew size, so that for example low level could mean 5 second, medium at 10 seconds and high at 30 seconds.

    I would like to do this, since we receive the alert occasionally from our test server (is gets cleared rather quickly so it is no big issue for us).

    7 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)
    completed  ·  Adam responded

    Thanks for this suggestion. Apologies for not updating at the time, but this suggestion was completed in version 8.0.10 in July 2018.

    We will mark this as completed but please do let us know if you have any further feedback.

    Kind regards,
    SQL Monitor Development Team

  6. 7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  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. Allow filtering out certain types of wait statistics (e.g. to remove benign ones)

    As the title says. See Paul Randal's query for an example: https://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/
    Give us the option to control exactly which types are filtered out of results.

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

    These are specified in the SQL Monitor database, as an entry in [settings].[KeyValuePairs]

  8. Monitor SQL Server 2014 failover clusters with Cluster Shared Volumes

    There is currently some trouble with monitoring a windows failover cluster with CSV - specifically, the error log is unreachable because base monitor apparently connects to the wrong network name to access files.

    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)
    completed  ·  Adam responded

    As mentioned in the comments, this was completed in v5.2.7
    (relevant issue was SRP-10451: Cannot retrieve log files for users who monitor SQL Server installed on a clustered shared volume).

    Apologies for not updating this at the time.

    Thanks
    SQL Monitor Development Team

  9. Alert History on new Overview - Don't show Cleared Alerts

    The slide-out Alert pane is useful on the Overview IF, and ONLY IF, under normal circumstances we want to see NON-cleared Alerts, like the default filter on the Alerts page itself.

    Please make this pane behave like the Alert page's filter, and allow us to re-filter, to include cleared if we want to. But at the very least allow us to set a default filter (in my case NON-cleared).

    Thanks.

    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)
    completed  ·  Adam responded

    Hi, thanks for the suggestion. The version 6.0.10 release added the ability to show/hide cleared and ended alerts from the timeline and alert sidebar on server overviews. We intend to add this to the global dashboard soon. Hopefully this solves the issue.

  10. Setting Maintenance Window via API service

    That would be very nice if there as an API service which we would use to set maintenance window for a given sql host or a group of hosts.

    7 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)
    completed  ·  Neil Turner responded

    Thanks for this suggestion. SQL Monitor 10 now allows teams to suppress alerts, or just their notifications, over certain periods using alert suppression windows. Windows can be set-up using SQL Monitor, or via the API. Please see the example Scripts within Configuration for more details.

    We hope this meets requirements and will mark it as completed. Please raise further suggestions for any improvements you would like to see.

    Thanks,

    SQL Monitor product team

  11. Notifications to Slack Only

    Would be nice to have the option to send some alerts to slack only, at the moment the only option is to send to slack and email, or don't send to either.

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  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. see the dates in UK format in the Estate - Installed Versions tab

    the release date and end of mainstream support date are both shown in USA format i.e. mm/dd/yyyy

    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)
  13. Have more flexibility in Maintenance Window Schedules

    We do OS and SQL Server patching one Sunday a month for dev and QA and the following Sunday for production. I think if maintenance windows scheduler looked more like setting a schedule in an agent job it would be perfect for setting these kinds of maintenance windows. And if we could drive setting / modifying maintenance windows via T-SQL that would be even better.

    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)
    completed  ·  Neil Turner responded

    Thanks for this suggestion. SQL Monitor 10 now allows teams to suppress alerts, or just their notifications, over certain periods using alert suppression windows. Please see What’s New in SQL Monitor 10 for more details (https://www.red-gate.com/hub/product-learning/sql-monitor/whats-new-in-sql-monitor-10).

    We hope this meets requirements and will mark it as completed. Please raise further suggestions for any improvements you would like to see.

    Thanks,

    SQL Monitor product team

  14. Email Alerts subject info

    Change the subject to the email alert, remove the SQL monitor ID number as taking up space without adding value, making it more difficult to gather the neccesary info from the subject line for job failure etc when viewing email through a portable device iPhone etc.

    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)
    completed  ·  Priya Sinha responded

    SQL Monitor V 3.3. has now released. This release contains improved subject lines and message bodies of alert emails to help you quickly understand problems before logging in to SQL Monitor.

    Thanks,
    SQL Monitor Development Team

  15. occurrences

    Please retain a "tombstone" that can be referenced to present a history of "Occurrences" for HIGH Alerts. Allow us an additional retention period so these don't hang around forever - but please don't limit the number of days, just a smallint would be good.

    When Monitoring Fails and is cleared, the Occurrence disappears when DB maint nukes "old cleared Alerts". If the retention period is short, say 14 days, the history of occurrences is soon lost.

    A "tombstone" would at least keep the occurrences for trending.

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

    Just keep the alert data in the Purge settings indefinitely – it’s only the metadata of the alerts, none of the performance data, so are “tombstones” as you described

  16. Alert Details - Performance Data - Top 10 expensive queries - Bug

    The "Top 10 expensive queries" tab under the "Performance Data" section of the "Alert Details" view shows "Totals" data by default even though the "Avg. per execution" radio option is selected by default.

    This can be confirmed by changing the selection to totals and then back to average.

    Observed in Web Version 3.2.1.231

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Daniel Rothig responded

    Hi, thanks for pointing this out to us. It has been fixed in version 3.3

  17. Analysis | Allow for custom versus comparisons

    It would be useful to compare a custom time range between different days such as 08:00 - 10:00 for this Monday and the Monday before.

    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)
    completed  ·  Priya Sinha responded

    This has now been implemented in v3.4.

    Thanks
    SQL Monitor Development Team

  18. Globally enable/disable monitoring

    We would like the ability to quickly turn off and on all monitoring and alerting globally. This would be usefull when we have major outage that we become aware of and start to work on, however alerts get generated very quickly and can overwhelm the email system or support phone. It would be great if we could continue to collect performance metrics but stop all alerts until the problem is resolved.

    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)
  19. Add Disk Used Percentage to the Analysis screen.

    The Disk Used metric on the Analysis screen is great for tracking how much disk space is being used but it would be more useful if this figure was a percentage so you could tell how close to capacity the disk is.

    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)
    completed  ·  Adam responded

    Thank you for this suggestion. Disk Used % was subsequently added to the Analysis page.

    Additionally we have now added a new Estate tab which includes an overview of the disk space used across the estate with a projection of how it will grow in the coming year. You can try this out by updating to the latest version 8.0.13 (it was released in version 8.0.10), or by viewing the online demo at https://monitor.red-gate.com/Estate/Disks

    We will now close this suggestion but please do raise another suggestion or contact us if you feel further improvements would be particularly helpful to you.

    Kind regards,
    SQL Monitor Development Team

  20. Disable Chat functionality

    It would be nice to have an Option to disable the built in chat functionality. I understand this is a quick easy method for obtaining feedback from the user community. The issue I have is that this is not an "Approved Chat Client" according to my info sec unit.

    Having the ability to turn it off allows me to satisfy their requirements while still allowing this to be enabled for other users to quickly interact and provide feedback to RedGate.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Adam responded

    After upgrading to SQL Monitor 6.0.8 or later you can now disable the intercom chat feature.

    After upgrading navigate to the following file C:\Program Files\Red Gate\SQL Monitor\Web\Website\web.config

    and amend the line

    intercom enabled=“true”

    to be false, then restart the website.

    Further details can be found here:
    https://forums.red-gate.com/viewtopic.php?f=205&t=80218&sid=76afdd87b11da381fcb31901d658270a#p143776

    Thanks for your patience with this issue,
    SQL Monitor Development Team

  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base