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

733 results found

  1. Disk Space / tempdb / Custom Alerts

    Hi,
    I have couple of suggestions as per my present system architecture ...
    1) For disk space alerts, user should be able to configure this alert for as many disk/drives as user wants out of the total disks/drives are available on the server. If needed, user should also be able to ignore a particular drive. Right now, SQL monitor checks for all the disks/drives on the server
    2) For database level alerts, there should be a exclusive alert for tempdb space
    3) In custom alerts, SQL Monitor should be able to display a resultset of a SQL query and…

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

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

    Closing as this is multiple ideas – please raise a separate suggestion for each

  2. Make "Source" hyperlink in Alert take you to the specific date time on the Server Overview Page

    If I click on the "Source" Hyperlink in alert, this opens the server overview page for the relevant server, however, the displayed time frame is the default (24 hour period ending at the current time)

    It would be helpful if the server overview page opened at the date / time of the alert as it is highly likely after clicking the hyperlink, that you are going to want to view the point in time of the alert

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

    We're currently reviewing this suggestion as part of general usability improvements.

  3. Azure Service Principal authentication (Client ID / Client Secret)

    It would be highly beneficial for us if Redgate Base Monitor supported authentication via Azure Service Principals using Client ID and Client Secret across all Azure products, including Azure SQL Database and Azure SQL Managed Instance.

    We are restricted to using Service Principals only and cannot rely on user-based authentication. Support for SPN authentication would allow us to fully automate the onboarding of new Azure SQL Databases and Managed Instances via Terraform, using our own modules, and register them in Redgate without any manual interaction. This would significantly improve scalability, consistency, and security in our Azure monitoring setup.

    15 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)
  4. Custom metric: alert when value changed

    I want to be alerted if someone creates or deletes a database. The metric itself is easy (select count(*) from sys.databases - executed for the master DB on all servers).

    But in the alert setting I can only define that it should trigger if the new result is abover or below a set value but not for value changed (compared eigther to the previous value or the "baseline").

    So I have to create two metrics / alerts for DB drop (below) and create (above) AND have to define / modify the number of databases as alert threshold for…

    19 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. 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

  6. For SQL Permission currently there is only permission for users in the server level displayed . Can the permission level in the database

    For SQL Permission currently there is only permission for users in the server level displayed . Can the permission level in the database level be able to display

    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)
  7. Alert suppresion window by specific date every month

    We do our maintenance on scheduled windows on the 20th and 21st day of every month, including weekends.

    Currently, it is not possible to set up such a recurring alert suppression window.
    Can you add this to the Redgate Monitor alert suppression settings?

    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)
  8. One-time Maintenance Window

    We perform updates to (nearly) all our Windows servers on our domain monthly. I'd like see the ability to set a maintenance window and have it removed once it has passed, rather than having the maintenance window fixed to set time every week.

    One use case is "silencing" alert generation while investigation is in progress

    71 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

  9. Filter to search the SQL Agent Jobs by server name

    Filter to search the SQL Agent Jobs by server name . Currently only can filter by job name

    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. Add more information to alert email

    It would be nice to have more information sent into the alert email, instead of having to login into the monitor to check details. I am not sure if there is a way to do this already. If there isn't - this would be nice to have.

    For e.g: This doesn't divulge which query. If the query was mentioned, it would help.

    ID: 59

    SQL Server: (local)
    Machine: (Machine Name)
    Alert type: Long-running query
    Level: None
    Time raised: 8 Mar 2012 12:44 PM (UTC-05)
    Time ended: 8 Mar 2012 12:50 PM (UTC-05)
    View full alert detail

    147 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

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

  11. See on the overview page incase of a AlwaysOn or a windows cluster which node is the active\primary

    We have several windows clusters and AlwaysOn clusters. It would be very helpful to see on the overview page which node is active.

    It can be easily done by adding a color to the AG icon on the tile.

    I know that it can be seen on the cluster overview but I really think it belongs on the Overview page.

    29 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 →
  12. ssis

    SQL Monitor currently does not monitor the execution of SSIS Packages.

    It would be extremely useful if SQL Monitor would monitor the execution of the SSIS packages like it does the execution of SQL Jobs

    E.g.

    Alert if the SSIS Package Execution Fails
    Alert if the SSIS Package is taking longer than normal to Execution
    Alert if the SSIS Package fails to start

    41 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. ADD Support for GCP Cloud SQL (MSSQL managed instances)

    As Google Cloud Platform increases their market share and adds features such as managed instances for Microsoft SQL Server, it would be great to have the ability to monitor those as well.

    4 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)
  14. Quick view of whether Agent is up on all monitored servers

    If I go to the Configuration > Monitored servers tab, I can quickly see if all SQL Servers are up and running. It would be nice to also be able to quickly see if all SQL Server Agent services are up and running.

    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)
  15. Raise an Event Alert when a database is dropped

    There is currently no alert when a database is dropped or detached from a server. SQL Monitor should create an Event alert to record when the drop happened. Obviously this might be intentional (e.g. the alert you have now that records a database is offline), but it might be accidental or unknown to the DB team (E.g. a vendor drops their database).

    Because it will (hopefully) be an intentional action, and quite probably no plan to ever re-attach the database, the alert should be an event alert rather than a normal alert (the normal alert would never end)

    A…

    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)
  16. Permission granularity on server/cluster objects

    It would be great to assign a set of users in a security group a read only or any other access to a particular cluster node instead of the full cluster. It is a managed environment with shared responsibilities, so it is essential to have this granularity in permission management.

    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  ·  Carlos Eriksson responded

    Available from version 14.0.14 (July 24, 2024).

    Admins can now grant users access to specific cluster nodes. Previously, access could only be granted to the entire cluster.

  17. Remove wait type VDI_CLIENT_OTHER from the wait graph

    SQL Monitor shows high waits for SQL Server 2016+ systems that implement availability groups configured for automatic seeding. Since a multiple system processes called VDICLIENTWORKER are left running by design. This wait tends to be the top wait in an AG configuration and erroneously indicates a problem that does not really exist.

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  18. Update the password of the account with powershell module

    I do not want to use the base monitoring account, to monitor the different databases. So I need to use a separate account for that. In order to regularly be able to rotate the password of this account, I would need the PowerShell module be updated with a function to update the password.

    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)
  19. Include SQL comments in Top Queries search

    I use Entity Framework Core to interact with a SQL Server database, which comes with the ability to "tag" queries with extra searchable information for troubleshooting purposes.

    This extra information is in the form of SQL comments, like so:

    -- SPARK: PartyRepository.PartySearch

    It would be very valuable to be able to search for this data, but unfortunately it appears that comments are excluded from Top Queries search, even though the data is there in SQL Monitor query data.

    11 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)
  20. Clone a report and change the server name globally within it

    I have crafted a report for my servers. I understand there's some behind-the-scenes scripting I can do to replicate a report, but the GUI could provide a "Clone Report" option, allowing me to change the server name reference on all the widgets. Sure would make deploying one extra server easy.

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

Suggestions

Categories