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. Monitor Azure SQL Read Scale-out Database

    I would like to monitor the Read Scale-out Azure SQL DB that gets created when on Business Critical tier.
    We are moving our Read queries to this database using "ApplicationIntent=ReadOnly" specified in the connection string. SQL Monitor allows to configure the primary for monitoring but provides no options to add a connection string when adding a server so am unable to add the secondary read-only DB for monitoring.

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

  3. Easily identify which base monitor is hosting a monitored SQL Server host

    In a multi-base monitor configuration it is a bit cumbersome to identify which base monitor is hosting a given entry on the overview page. Yes, one can search all the SQL Server host machines on each base host, but that takes time. It would be better to have an entry in overviews that identifies where it is hosted.

    5 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. Monitor SQL Server running on AHV hosts

    Whilst you have added the ability to monitor vmware hosts, I would like to be able to monitor other virtualization technologies. E.g. AHV (Nutanix)

    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)
  5. Subject line change on Alerting .Include TargetObject name instead of Base monitor server

    Dear team ,
    We are successfully integrated SQL Monitor with halcyon monitoring Via SNMP traps. Business rules in Halcyon generates the ticket in SD and it comes to DBA's for action.
    we are happy that setup is working as expected but we wanted to have a TargetSystem name in subject line of the alerts instead of coming as base monitor server name where SQL monitor hosted . This will let us take a quick glance on high priority systems rather than less priority .
    Subject line should include target Object instead of base monitor server name (which is default…

    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)
  6. 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 →
  7. SQL Server Agent : Check the status of Agent XPs Server Configuration Option

    Subject : SQL Server agent

    Context : At this time, SQL monitor only check the status of the windows service to monitor the SQL Server agent.
    but do not check Agent XPs Server Configuration Option.

    As a result, you could have a started agent, not able to launch any jobs and sql monitor will not raise an alert.

    Solution :

    • add a check of the column valueinuse in the sys.configurations table to ensure that Agent XPs is enabled when the agent service is started.

    SELECT * FROM sys.configurations WHERE name LIKE 'Agent XPs'

    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)
  8. 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

  9. New Licensing for Azure SQL Databases

    If you are going to start licensing by the number of Azure SQL Databases, at least provide the option of adding and removing databases from the Azure SQL Server.
    I have three databases on one Azure SQL Server that are costing me licenses, however two are data warehouses and one is paused. If they are not being monitored, why am I being charged for a license?

    1 vote
    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.

    The ability to add/remove individual licenses for Azure SQL Databases has been implemented in version 8.0.22, released on 13th November.

    We hope this meets your requirements and will mark this suggestion as completed, but please do let us know if you have any further feedback.

    Thanks,
    SQL Monitor Development Team

  10. Set default Redgate Monitor time zone

    My Redgate Monitor server is on a server with the time zone set to UTC. When I open a Redgate Monitor on that server I get all the times in UTC, which is great.

    When I open a Redgate Monitor on my local computer, the GUI shows the times adjusted for my timezone.

    Since my team is monitoring from different locations in different time zones, we get different times depending on the timezone.

    I would like an option in Redgate Monitor configuration to easily set a default time zone so all the users can see the same time zone.

    9 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)
  11. Add option(s) for manual purging of data (use case: removed instances, deleted databases)

    CONTEXT: When you remove a machine from monitoring in SQL Monitor / delete a database from an instance / rename a database... - data stays in the SQL Monitor database (e.g. machine/instance/database is still visible on the Analysis tab), at least until relevant monitoring data is purged.

    PROBLEM: If you have some purge settings set to "do not purge", that data never goes away. Sometimes that is OK (you want the history retained), sometimes it's not (bloats the SQL Monitor database, unneeded entries on the Analysis page...).

    EXAMPLE SOLUTIONS:
    Add options to manually (on demand) delete data for…

    27 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)
  12. that DevOps team that can only monitor their own database can also suspend them without having administrator rights

    at the moment when people have administrator rights within Redgate Monitor they can suspend their databases but also all other databases we monitor. we would like to be able to grant teams rights to only be able to suspend the databases that they use and have rights to see within Redgate Monitor.

    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)
  13. Add an option to alias the server names.

    In a multi-server environment it would be very helpful to be able to assign an alias to the server name. So at a glance you can see something like - 192.168.1.1 (Company A OLTP)

    Merged idea: Longer descriptions for Servers, Databases etc

    48 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

    Closing this suggestion as the server alias work was completed in v5.2.2.

    However, there is not currently a way to alias cluster/machine names, so if that is important please raise it as a new suggestion as we could look to address it if there is demand.

    If you are experiencing problems with server aliases, please let us know via the support forums.

    Thanks

  14. Unlicensed Databases

    If a license is removed for a database, a banner at the top of the page shows up saying, "You have unlicensed servers. Unlicensed servers will not be monitored and will not raise alerts. Manage licenses | Manage monitored servers". And, on the "Configuration > Monitored servers" page the databases show with a red x, as Unlicensed, and a Manage licenses link.

    It is good that licenses can be removed for individual databases, however it would be better to be able to remove the databases once they are unlicensed, so that we…

    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. list, and get alerts from the SQL Monitor API.

    Add possibility to list, and get alerts from the SQL Monitor API.

    This so we more easily can share and distribute alerts to a users that shouldn't have access to SQL Monitor.

    In my org we have a lot of developers, and a lot of different databases that are hosted on the same clusters, I want the possibility to send more direct alerts and messages to these users.

    42 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. Replication Monitor

    Create a replication monitor type dashboard show status and current latency etc.

    40 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)
  17. Monitor Partitioned Tables in SQL Server

    Be able to monitor and alert on sql paritioned tables. Such as if a retention of a table is 30 days and it retains data greater then 30 days, I should be able to get an alert. Be able to get alert on things like if older partitions are not merging or new partitions are not splitting or data being stuck in one partition...etc Able to see growth and changes in the partitions...

    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)
  18. Exclude System Databases (and potentially other user databases) from backup alerts

    We would like the ability to exclude system database from the backup alerts, as we do not back them up. We have a system in place to script out security and sql agent jobs/schedules for each of our systems nightly. We also have been leveraging the dbatools PowerShell stack as a way to automate server migrations and other automation activities. Also, our tier one systems are in availability groups. Lastly, we do not backup everything in our lower level environments, as we perform nightly database refreshes for the majority of our systems. However, we do have some testing databases that…

    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)
  19. be able to move database to another server

    Sometimes I need move database to another server. I did it last time and I lost access to historical data. Moving databases is very common practice.
    I think it is a big disadvantage.

    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)
  20. Only Query Serverless Azure SQL Databases if they are Online and not Paused

    As mentioned in the below post, SQL Monitor will keep serverless Azure SQL databases from pausing and saving us the money they are supposed to. I would like the Azure SQL monitoring piece to be rewritten to use the Azure API to determine both if the Azure SQL DB is serverless or not and if it is AND paused, don't run any queries that would wake it. Yet if it is NOT paused, get info about it and update SQL Monitor.

    https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/45670060-exclude-serverless-databases-from-monitoring

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

Suggestions

Categories

Feedback and Knowledge Base