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.


  • or

716 results found

  1. Provide a direct link to the base monitor download

    When installing updates, only the SQL Monitor web service link is initially provided. In order to get access to the SQL Monitor base monitor download one has to first install the the SQL Monitor web service. This process slows down upgrade time and extends the "broken state" time in a multi-base monitor configuration.

    Please provide a direct link to the base monitor download without requiring an initial WebService monitor install.

    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. Ability to not monitor/show certain queries in the TOP 50 list.

    The top 50 query view in SQL monitor is showing the query that is running on the service broker queue with explicit waitfor statement. In our server these waitfor is 5 min and we have 100 threads that runs for 5 minute and wait for the messages in the queue.
    The query monitor shows these query as the top slow performing queries, but in reality these are not slow queries, they are just waiting for messages in the queue. We need a way to not show up the queries in top 50 list, so the queries that are actually slow…

    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)
  3. be able to choose the actions during maintenance window.

    During a monthly patch round along the servers, a restart or some downtime is mandatory. I want to be able to select the actions SQL Monitor will perform with the alerts triggered within that maintenance window. Most of the time I'm aware of the required Windows reboot, so I do not need an email telling me that the SQL Server was not reachable for a short period. So I would like to tell SQL Monitor not to trigger any alert during the maintenance window. (preferably a one-time maintenance window, see other suggestion)

    22 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. 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)
  5. Collecting custom metrics for multiple databases at the same time

    ATM, a custom metric can return one value, but sometimes collecting the metric for one database takes the same amount of time as collecting it for all of the databases.

    Having a multi-database metric (maybe something that returns a database id -> value map (as a two col table)) would be especially useful if it takes a long time to collect the metric (in my case it takes nearly 30 secs to collect it).

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. Under Estate section: display last date/time server and/or instances on each server were restarted

    I want to know what SQL Server Services are running/stopped on each server and be able to alerted if said servers are stopped.

    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)
  7. Use base monitor service user account to authenticate with vcenter

    When monitoring a vcenter deployment, it would be nice if the base monitor service could just delegate the credentials it is running as rather than entering them in the username and password boxes inside sql monitor.

    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)
  8. Manage Scheduled SQL Monitor Reports from one overview page.

    It's easy to set up a new report and schedule for SQL monitor reports. But once schedules are created it's difficult to manage them.
    Have an overview page that would allow you to see all that has been scheduled .... giving options to:
    1) Delete individual schedule (e.g. following server decommission or server no longer monitored).
    2) Edit individual report schedule ... e.g. change time / frequency and for a particular type of report change the target server for that report ... i.e server replaced, being able to move report from reporting on original server report created for to…

    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)
  9. I want to be able to document in SQL Monitor why an alert is set a certain way.

    On the alert configuration screen for any alert, at any level I would like to see a comment type box where I can enter in the box the reason the alert is set as it is.

    For example if I have disabled the backup overdue alert for a particular database I would like to be able to save that reason in this comment box. Or if I have changed the disk space usage for a particular drive on a server different than the default I want to be able to document the reason why.

    I want to see this box…

    21 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  ·  Adam responded

    Thank you for this suggestion, it makes sense to want to record why certain configuration changes have been made.

    We released this enhancement in version 8.0.10 (in July this year – apologies for delay in updating this suggestion).

    I will mark this suggestion as Completed, but please do reply if you have any further feedback.

    Thanks,
    SQL Monitor Development Team

  10. 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…)
  11. show sql related windows event log entries

    Rather than going through all Windows event log entries looking for SQL related events on every monitored server, it would be good to have them displayed on the server screen along with the SQL Error log entries.

    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)
  12. Be able to monitor Basic Availability Groups. Currently Basic Availability Groups are not supported

    Be able to monitor Basic Availability Groups. Currently Basic Availability Groups are not supported

    30 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. A Comprehensive Manual for SQL Monitor

    Currently there is a serious lack of information about SQL Monitor and that's bad for everyone and not just the user base for DPA. Therefore DPA needs a head to toe, top-down comprehensive manual that details every single aspect of DPA from the metrics it captures to the settings it uses and every single function/feature no matter how insignificant needs to be documented in a single manual/guide. When complete there should not be any part of DPA that is not detailed in this manual. While I can see no reason for why something this comprehensive would not be made available…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

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

    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)
  15. Provide AAD authentication mode to connect to Azure SQL server apart from username and password authentication.

    Provide AAD authentication mode to connect to Azure SQL server apart from username and password authentication.

    Because if Azure SQL is set to AAD authentication only for security reasons in any organization, username and password to add new Azure SQL server/DB under SQL Monitoring doesn't help.

    36 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 Backups LSNs in Always On Availability Groups

    With Always on Availability Groups, Error is... Log backup for database "XXX" on a secondary replica failed because the last backup LSN from the primary database is greater than the current local redo LSN. And SQL Monitor cannot check for this. I would like to see if SQL monitor can catch it before the Azure Backup Vault fails to backup every 15 minutes.

    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)
  17. 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)
  18. Access rights on database level

    CONTEXT: We want to give our developers access rights to there databases alerts (long running queries, blocking processes, deadlocks ...).

    PROBLEM: Access rights are only allowed on sql server instance level. Database1 should only see dev team1, database2 should only see dev team2. This is not possible at the moment.

    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)
  19. “Longest Running Queries” in Redgate SQL Monitor Reports

    I need to show more “Longest Running Queries” in Redgate SQL Monitor Reports. The layout of the report is also a bit awkward, it seems if everything does not fit into the report.
    See attachment.

    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)
  20. Utilize in SQL Monitor Analysis or Reports pages any SQL Server counter available in PERFMON.

    For instance BRENT OZAR has an excellent method to diagnose memory pressure. The counter in use is SQLServer: Memory Manager – Memory Grants Pending which is not available.

    If Memory Grants Pending is averaging over 0, queries can’t even start because they can’t get enough memory. You may have queries that have incorrect memory grants, or you may just desperately need more RAM.

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

Suggestions

Categories

Feedback and Knowledge Base