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.


In Redgate Monitor, I want to...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • or

733 results found

  1. Tracking Aborted Queries and Memory Grants in Redgate Monitor / Azure SQL Managed Instance

    After contacting Red-Gate support, I understand that individual query monitoring for Azure Managed Instance is currently not supported nor on the roadmap. Is it possible to add this feature to an upcoming release of Red-Gate Monitor?

    TL;DR Below

    The article below mentions the ability to track cancelled or aborted queries. This would be particularly helpful for Azure SQL Managed Instance.

    Tracking Aborted Queries and Memory Grants in Redgate Monitor
    https://www.red-gate.com/blog/tracking-aborted-queries-and-memory-grants-in-redgate-monitor

    • Cancelled or aborted queries – immediately see when a query fails to complete, whether due to timeouts, user cancellation, or connection issues

    Query Executions in Redgate …

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  2. 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)
    Close
    Close
    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)
    Close
    Close

  3. “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)
    Close
    Close
    You have left! (?) (thinking…)
    2 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)
    Close
    Close

  4. 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)
    Close
    Close
    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)
    Close
    Close

  5. 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)
    Close
    Close
    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)
    Close
    Close

  6. In AzureSQL, I would like Redgate Monitor to not "keep awake" systems which are set to "sleep".

    Within AzureSQL you can set SQL Servers to be Serverless and also to "sleep after" a time window. This means you can save money for systems which are not heavily used.
    I think Redgate Monitor needs to have a "light touch" mode for such systems where it will firstly check the config and say "ok, this server is asleep, I dont need to look at it" before reporting maybe in the infomration status "system asleep". When the system wakes up, it should monitor as normal.
    This is a cost saving exercise since, after adding Redgate to our Legacy…

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 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)
    Close
    Close

  7. 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)
    Close
    Close
    You have left! (?) (thinking…)
    2 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)
    Close
    Close

  8. Select different purge data ranges depening of what group a server belongs to.

    We have different data retention requirements depending on what server is being monitored, but currently only 1 purge setting is available which covers all servers. An example of what I'd like to see would be to select to purge data older than 14 days for production/critical servers and a much shorter retention of data for test/development servers. This would be controlled by what group a server was a member of.

    30 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  9. Add COMPARE BASELINE option to the Reports in SQL Monitor

    In SQL Monitor 6.0.17.6667 the new Reporting feature is terrific, however I would like to see the addition to add the COMPARE BASELINE option to the Reports like Analysis option currently has. This would allow us to see if measurements like CPU, user connections etc are in line with a baseline of, say last week or way off.

    31 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 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)
    Close
    Close

  10. 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!)

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  11. Custom metrics in Analysis tab - allow grouping by metric type (machine / SQL Server instance / database)

    In Analysis tab in the metric choice window all custom metrics are currently grouped together and sorted alphabetically. I'd like to see them grouped by type similar to the out-of-the-box metrics (machine / SQL Server instance / database) - the type could be a new parameter for each custom metric, manually entered / changed.
    That would help when one has a lot of custom metrics.

    The result:
    - Machine metrics
    - SQL Server metrics
    - Database metrics
    - Custom machine metrics
    - Custom SQL Server metrics
    - Custom database metrics
    - (maybe also this: Custom uncategorized metrics)?

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    6 comments  ·  Admin →
    declined  ·  Daniel Rothig responded

    we have found that this is not how people use custom metrics in general, so adding this split by default would go against the practices of most of our users – the best workaround for those that do have this split is to add a prefix to their custom metric name – they are ordered alphabetically

  12. Add alerting for replication performance

    Include an alert to monitor replication performance. i.e based on the latency reading that you can view in Replication Monitor. The counters for this are "SQL Server Replication LogReader: Delivery Latency" and "SQL Server Replication Dist.: Delivery Latency". I'd like to be able to set the alert priority based on this.

    81 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    4 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)
    Close
    Close

  13. Activity monitor is showing "Blocked By" sessions that are not showing up in SQL Monitor

    Is there an issue with the blocking information in SQL Monitor or are there certain types of blocks that are excluded? We are seeing blocks displayed in the SSMS Activity Monitor that are not being displayed on the SQL Monitor Overview page for Blocked Processes.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  14. Replace SERVER identifier with a hosts file friendly name

    As the ALIAS feature isn't working consistently across all pages and, in particular, email alerts, the means to replace the name of a monitored server is needed.

    E.g., if someone, not a DBA or person familiar with SQL Monitor, set up each server as an I.P. address, or an equally meaningless Rackspace device ID, it is unreasonable to assume that I.P. or RS device translation to named server, which in our case is a customer name+nature combo, is held in every recipient's brain, or that we should carry around a pocket-sized hosts file printout...

    If a simple…

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  15. new altert for service state of PowerBI Reporting Services PBIRS like "SQL Server Reporting Service status (2017+)"

    In addition to SQL Server Reporting Services SSRS, we have more and more PowerBI Reporting Services PBIRS.
    For SSRS since 2017 there is a separate alarm "SQL Server Reporting Service status (2017+)" in Redgate.
    This tells us when an SSRS is no longer running. This also works.

    However, as far as I can tell, this alert does not cover PBIRS.
    Recently, customers increasingly want PBIRS instead of SSRS and unfortunately we do not currently see the status of the PBIRS service in Redgate and do not receive an alert if this service is not running.

    We know that PBIRS and…

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  16. Uptime of my SQL server database servers

    I need to be able to account for yearly uptime for my SQL server estate and also receive proactive alerts when they are shutting down.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    completed  ·  AdminLiam Prescott (Product Design, Red Gate Software) responded

    An uptime summary tile, which shows all the servers in the estate sorted by uptime in ascending order, was added in version version 14.0.21 (August 20, 2024). 

    The "instance unreachable" will be fired when a monitored server shuts down.

  17. In the Estate view you are 2 CU's behind for SQL Server 2016.

    Currently SQL Monitor shows the latest SQL Server 2016 version to be SP2 CU4 yet the latest is SP2 CU6. This should show the latest version.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →

  18. I want to be able to apply tags to SQL servers in SQL Monitor to better sort

    I want to be able to create more groups that a server is a member of. For example, I want to see all Production servers, or all servers associated with a specific team or department. I can group by only 1 item now. But, if I could tag servers, that would allow me to be more granular in my reporting.

    We do the same thing in VMware now. We can still use the same grouping structure that exists today, just create the ability to provide multiple tags to each server/instance.

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →

  19. Server & instance stats on main window

    I'd like to be able to see at a glance the basic details of my instance and the server on which it is running.

    I would love if I could see the following on the main screen:
    • SQL Server Version — SQL Server 2022 CU16 | 16.0.4150 (CU16)
    • Server Version — WS 2022 21H2 | 20348.2762
    • Instance details — 3x 3.0GHz | 12GB | 1TB (or whatever is allocated to the instance)
    • Free Space — 0.1TB of 1TB (drives will have to be chosen)
    • Instance status — SERVER\NAMEDINSTANCE
    • No. of Instances — 6…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  20. Make alert configuration levels more discoverable

    CONTEXT: In SQL Monitor, you can configure alert behaviour down to the object level (such as the Database or the Job level). This is useful e.g. when we have specific databases with different backup policies to our global configuration, since we can specifiy "special rules" for individual databases.

    PROBLEM: It is counterintuitive how to do so, and many people don't spot the left-hand drilldown navigation - this makes you think that you can only configure on the global and the server level! Also, when we have created an override, it's easy to forget so causes surprise when we…

    180 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    42 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)
    Close
    Close
1 2 … 5 7 9 … 36 37
  • Don't see your idea?

Suggestions

Categories