Skip to content

Suggestions

Welcome to the Redgate Monitor feature suggestions list. Tell us how we can improve Redgate Monitor by voting on these suggestions or by submitting your own ideas.

This is the easiest way to make an impact on Redgate 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 — the Redgate Monitor team will often stay quiet initially about new suggestions to see what you have to say!

If you have any questions visit the Redgate Monitor forum.


212 results found

  1. 12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →
  2. Pagerduty API/WebHooks and Better Notification channel

    We are in a high secure payments network, we do not wish to open ports used for email (smtp) however we would like integration with Pagerduty.

    Please create a generic web hook interface where the payload can be fully customised or direct integration via there API.

    I would like the option to pick what communication channel is used based on the severity of the alert

    Alert Rule XXXXXX
    H M L
    Email
    Pagerduty X
    Slack X

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  3. be able to schedule monitoring suspend or maintenance on instance level

    We have a cluster with two instances. The databases on these instances are restored on different times during the day.
    I want to be able to schedule suspend of monitoring during these different time periods so that one instance is suspended and the other is not. Or put them in maintenance mode on the instance , not on host machine level.

    12 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 →
    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

  4. Custom reports against alerts, queries and metrics

    CONTEXT: We want to see the bigger picture arising from the data presented in SQL Monitor.

    PROBLEM: Currently you can't pull together a report in the SQL Monitor UI, and the monitoring database is not particularly accessible. We need reports against:
    - The metrics shown in the analysis graph
    - The top queries and waits
    - The alerts raised over time
    - Server configuration and SLA

    EXAMPLE SOLUTIONS:
    - Provide reporting scripts against the monitoring database
    - Privide a BI interface against the monitoring database
    - Priovide richer data-export functionality in the UI
    - Provide a report designer in the…

    263 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  56 comments  ·  Admin →
  5. Add the calling module/process in "Blocking process" alerts

    In the Details tab of a Blocking Process alert the process name of the blocking process is included. It would be very useful if this was included in the "Blocked process" info on the processes tab. This would assist us in working out what it is that the blocked process is trying to access because the SQL fragment is often too generic to be useful.

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  6. Sort or Filter Monitored Servers

    In Configuration -> Monitored servers I would like to sort and filter the servers and have the grouping functionality applied to this screen. This would make it easier to find my server that I want to put a maintenance window on.

    38 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  7. Missing database name in blocking session alert

    When I receive an alert about a blocking session, it does not tell me the database. The mail starts with e.g.

    Blocking Session ID: 93
    Number of blocked descendants: 1
    Total blocking duration for all descendants: 00:03:02
    Blocking SQL fragment: CREATE PROCEDURE [dbo]...

    In the subsequent blocks (blocked sessions) it shows the corresponding database name, but only after much of scrolling, when the block cames from a long procedure (some with > 1000 lines).

    So please add the database name to the blocking session part too.

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  Adam responded

    Thanks for the suggestion. Version 7.1.3 has now been released and improvements include adding the database name to the Blocking process alert.

    Kind regards,
    SQL Monitor Development Team

  8. Block Specific Deadlocks by Lock Details

    We've just updated to SQL Monitor 6. We was hoping there was a feature in this to change alert settings for Deadlocks with specific lock details rather than just all Deadklocks.

    For example
    we don't want email alerts on: Deadlock 'object: ReportServerTempDB.dbo.SessionLock, lock mode: Exclusive (X), index: IDX_SessionLock

    However we wish to receive emails when: Deadlock 'dbid: 6, object id: 72057594038845440, index id: (9bf78693a4b4)'

    However this feature doesn't exist. Would be great to have added to an update in the near future!

    42 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  Adam responded

    Thanks for this suggestion and the comments.

    As previously announced, since version 8.0.22 (released November 13th, 2018) Deadlock (XE) alerts can now be filtered by database, login name & resource, and victimless (eg Exchange Event) deadlocks are excluded by default.

    We are marking this as complete, but please do let us know if you have any further feedback.

    Thanks,
    SQL Monitor Development Team

  9. Triage and configure repeating alerts more efficiently

    CONTEXT: Some alert types such as Long-running queries, Job Failure or Error Log Entries can trigger very frequently under certain circumstances.

    PROBLEM: This causes a large number of alert emails to be sent, and the only way to ascetain that all these alerts are the same is to view the details screen for all of them.

    EXAMPLE SOLUTIONS
    • Group similar alerts in the alert inbox
    • Raise alerts not on individual events, but on these events happening a specified number of times
    • Mention identifying information sooner: e.g. directly in the alert inbox
    • Suppress query-based alerts for specific…

    462 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  61 comments  ·  Admin →
  10. suspend

    Hi,
    I think it's very important to show Suspended status of a monitored host/instance should be shown in dashboard.
    I had suspended monitoring on an instance and forgot to resume so I've missed monitoring for a while.
    I suggest to show the state of monitoring (Active or Suspended) maybe graphically/iconic, in the dashboard and Server overview pages

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →
  11. Suppress performance-related alerts during maintenance periods

    CONTEXT: I expect my system to slow down during routine maintenance tasks, which often leads to false postitives for performance-related alerts (long-running queries, High CPU...) in SQL Monitor.

    PROBLEM: While I could configure a maintenance window where alerts don't get raised, this would also suppress operational alerts (e.g. Machine unreachable, Job failed) - these are still relevant while maintenance is in progress

    EXAMPLE SOLUTIONS:
    • Allow to configure maintenance times for individual alerts
    • Change maintenance window behaviour so that operational alerts are still active during maintenance

    What do you think about these solutions? Got another idea? Let us know…

    233 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    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

  12. Only receive emails for the most important alerts

    CONTEXT: I review alerts raised by SQL Monitor in order to stay on top of my server activity, and I also have alert emails enabled in order to respond quickly to issues.

    PROBLEM: I only want to receive emails for issues that require immedate action or are otherwise noteworthy. I don't want to change the alert thresholds because for my triage, the "lower-priority" alerts are still interesting - but they shouldn't be sent as emails.

    EXAMPLE SOLUTIONS:
    • Send emails by alert priority - e.g. medium and high only
    • Alter the default alert behaviour to only send emails for…

    240 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  Adam responded

    We have released version 9.0.10 of SQL Monitor which includes the ability to choose to receive notifications for only high level alerts, or only high and medium alerts (or the default of all severities) globally.
    https://documentation.red-gate.com/sm9/release-notes-and-other-versions/sql-monitor-9-0-release-notes

    We realise this is long overdue, as we’ve struggled to provide one solution to the different problems contained in this suggestion. As such, we’ve decided to break this down into different problems we can look to address.

    We believe this release delivers the solution to the problem originally suggested, to be able to send email notifications for alerts with a Medium or High priority, so will mark this as completed. However, please do raise new suggestions for anything you feel hasn’t been addressed by this release, so we are able to consider each one as we continue to improve SQL Monitor.

    Thank you for your patience,
    SQL Monitor Development Team

  13. Show deadlock alerts using the deadlock graph

    Display deadlocks alerts in a more graphical and easier to understand way.

    35 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  Adam responded

    Thanks for this suggestion. Version 8.0.2 uses extended events to display graphs for the deadlocks.

    We will close this suggestion, but please do add another suggestion if there are further improvements you would like to see.

    Kind regards,
    SQL Monitor Development Team

  14. Make SQL Monitor scale to more machines and networks

    CONTEXT: We want to monitor many different servers in different domains and locations

    PROBLEM: Network configuration for cross-domain monitoring can be challenging, and SQL Monior can slow down if many servers are being mointored

    EXAMPLE SOLUTIONS:
    • Create a central web interface that can access multiple Base monitors
    • Provide an optional agent that can be deployed for easier network configuration
    • Make a single installation of SQL Monitor scale to a larger number of servers, and make network configuration easier

    126 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  21 comments  ·  Admin →
  15. SQL Monitor 5.2.5 upgrade dashboard server/SQL Server memory

    Upon upgrading from 5,1 to 5.2.5 the new Global Dashboard no longer shows machine memory vs. memory being consumed by SQL Server. Why was this removed? This can be critical to see if SQL Server or any other process is using up all of the servers memory.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  Adam responded

    Thanks for this suggestion. Apologies for not closing this sooner as it was completed a long time ago; we did agree that we should show machine memory vs. SQL Server memory and this is shown on the Server Overview memory chart.

    Thanks,
    SQL Monitor Development Team

  16. Add "Re-send Email" for an Alert

    Some emails find black holes. Need option in the "Actions" dropdown to re-send an Alert email. Please pop-up the addressee dialog so we can direct/redirect to recipient list and add a custom subject to help us segregate the email into an email thread for discussion/attention.

    15 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  17. Single sign on

    Make it so that I can add an AD group to the settings, then enable AD Auth in IIS and not be prompted for username and password.
    LDAP settings should not be needed.

    15 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  Daniel Rothig responded

    Support (at) red-gate.com can provide you with instructions how to disable SQL Monitor authentication in order to fall back on IIS authentication, which supports Single Sign On.

  18. 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…)
    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

  19. Use the Base Monitor Service account to query Active Directory when using AD Credentials

    We are using a Managed Service Account to run SQL Monitor so we don't have to manage passwords. However we still need to have a regular domain account to query AD because there is no option other than to specify a username and password.

    What would be great is to have an option to use the base monitor service account to query AD instead of having to specify a username and password.

    This would work in a similar way to what already exists when setting up credentials for the server you monitor, where you can choose to connect to the…

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  20. Comment multiple alerts at once

    I would like the ability to add the same comment to all of my selected alerts before clearing them in the Alert Inbox.

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  Adam responded

    Hi,

    Thanks for this suggestion.

    Version 8.0.23 has now been released and includes the return of the ability to add a comment to multiple alerts.

    This was initially removed while developing the ability to group alerts, and it’s taken us longer than expected to reintroduce – apologies for the inconvenience this caused.

    We hope this solves this suggestion. We’ll mark it as completed, but please do reply if you have any further feedback.

  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base