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.
760 results found
-
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 Monitor
https://www.red-gate.com/hub/product-learning/redgate-monitor/query-executions-in-redgate-monitor4 votes -
group similar queries
I have queries which are created by string concatenation in a legacy product.
These queries differ by some IDs in a IN clause.In SQL monitor, these queries are all shown as different queries in the "top queries" section.
I would like that all those similar queries are shown as one query in the "top queries" section so that I can better find long running/problematic queries.
6 votes -
be able to extract all alerts at once rather than extracting for individual alerts via API
Redgate Monitor API currently allows users to extract alert details for individual alert types. We need an API endpoint that can extract alert details for all alert types instead of calling the API multiple times.
10 votes -
Schema name in the Indexes tab and Top procedures tab on the overview page
In SQL server it is possible to have indexes with the same name on different tables. It is also possible to have tables with the same name on different schemas. Therefore, you can have indexes with the same names on tables with the same names on different schemas. The same is true for stored procedures.
Since there is no data on the index and stored procedure's schema in the Indexes tab and Top procedures tab on the overview page, one does not know which exact SP or index is in the table.
12 votes -
Custom Queries in Reports or Provide Queries to make own Reports
I'd like to be able to either paste in my own queries to build a report from (a la PowerBI) or, better yet, be able to access some of the code for your existing queries so I can make custom reports in PowerBI. (For instance, the Longest Running Queries summary tile is extremely limited at the moment, if I had the code I could quickly make it in PowerBI and make it do what I wanted.
I understand its Red-Gate code and therefore you'd want to keep it to yourselves, but it would deeply expand the reporting features and make…4 votes -
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.
8 votes -
Allow the reports to use all the data my retention policy allows.
Generating reports seems to limit it to 30 days of data. For trending we would like to use all the data our retention policy allows. Not sure why there is a limit.
6 votes -
Analytics Dashboard Selection Parameters
On the Analysis Dashboard there are lots and lots of Metrics. Not all of them are Availbale for ervery RDBMS. It would be good to have switches to narrow down the Metrics to SQL-Server or Postgres Parameters, e.g. if you swich on Postgres only Metrics for Postgres Servers are shown.
3 votes -
Want Estate page to report patch correctly for GDR only instances.
In the SQL Server versions page under Estate, Redgate Monitor checks for the “Latest available update” for each SQL instance. It compares the instance level with the latest patch released on the CU-path for the instance version and sets the Status column as appropriate, flagging where a patch is missing, be that CU or CU+GDR.
I would like an option to set specific SQL instances to be on the GDR-only pathway and have Redgate Monitor check and provide accurate last GDR patch and status detail for those too.
Without this change, GDR-path instances can show as "update needed" (yellow) in…
1 vote -
Security auditing
Monitor SQL Server login and database user activity to identify unused or anomalous accounts. Supports security audits, enforces the Principle of Least Privilege (POLP), and helps retire or restrict dormant or misused accounts.
The tool will collect and analyze login usage data across all servers and databases. It will:
Report accounts that have not been used within a configurable time period.
Identify accounts active in unexpected contexts (e.g., unauthorized hostnames or outside normal business hours).
Allow administrators to define thresholds or parameters for expected usage and generate alerts when violations occur.
2 votes -
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 -
Support Individual query monitoring in Azure SQL Database
This sounds like a useful feature. I wish it was available for my environment.
4 votes -
Add multiple actions for alerts based on different conditions
It would be nice to be able to configure different actions for the same alert based on different criteria.
For example, with the SQL Job failure alert - It would be very useful to be able to have these alerts go to X email address if the job contains "DBA" in the job name, and the alert go to Y email address if the job doesn't contain that text in the job name (This is just a basic example, being able to configure multiple of these types of filters would be the goal).
Right now the only possible…
3 votes -
Within the Reporting option, allow 'Alert Summary' tile the ability to select a individual servers
Within the Reporting option, allow 'Alert Summary' tile the ability to select a individual servers within an AlwaysOn cluster. Currently you can only select the cluster name.
1 vote -
Simplify alerts without mentioning product names like PostgreSQL
Few alerts in Redgate Monitor ends with "(SQL Server and PostgreSQL only)".
We don't use PostgreSQL and don't plan to do it. Would be nice to turn off that feature permanently so that, for example message like “Database unavailable (SQL Server and PostgreSQL only)” shown as “Database unavailable”2 votes -
Additional option on the Alert Suppression Windows
It would be great to have an additional option on the Alert Suppression Windows to have the ability to only stopping sending notification for new alerts and continue to send the notification for the end of alerts
I guess something like "Notification for new Alerts only (alerts will still be raised)"
The idea would be to receive the end of alert notifications for alerts that were ongoing when the alert suppression window started13 votes -
Grant access to the Security Auditing features to a specific user role or user group
As a DBA, I wish to grant access to the Security Auditing features (Permissions changes and Configuration compliance) to our security team. I do not wish the security team to have full administrator access to the Redgate Monitor installation as they are not DBAs and neither interested in nor responsible for any other parts in Redgate Monitor.
At the moment, only Redgate Monitor administrators have access to the above enterprise security features in Redgate Monitor. From a separation-of-duty perspective, the security team should not have full access as administrators to the Redgate Monitor installation.
5 votes -
Alerts should configurable to repeat until an issue is resolved
We'd like the option for alerts to repeat until an issue is resolved. For instance, we may have a custom alert to tell us when a DBCC CheckDB hasn't been performed in >24hrs. For that we'd perform the check once per day and expect to get an alert every day that the problem continues. Without the alert recurring it's very easy for it to slip through the cracks and get missed.
Another example is blocking. We have some databases where we monitor blocking via SQL Agent and when a block occurrs for 1m or more, we send emails every 30s…
6 votes -
Filtering on a Postgres Aurora Cluster based on Node
When adding a Aurora Postgres Cluster to be monitored, if it has multiple nodes, say a reader/writer. Can we get a feature that will show only the metrics related to that specific node. Say I want to see only the CPU/Memory/Throughput for the writer node only and vice versa for the reader node.
1 vote -
Tracked queries only available to admins
Tracked queries are only available for Administrators. Would it be possible to adjust the permission for Standard users to allow for this feature? At the moment we are forced to assign admin roles more broadly than we’d like because of insufficient granularity of permissions.
And this feature (especially if combined with some metadata as highlighted in https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/46675642-ability-to-add-notes-to-tracked-queries ) is a shame to not allow standard users to utilize.3 votes
- Don't see your idea?