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.
765 results found
-
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 -
Add CPU time to Individual query monitoring
Should be great if we can get CPU time column added to the new Query executions tab.
CPU time is in addition to logical reads/writes important when looking and performance of the different queries.
9 votes -
Add custom banner to the logon page
Basic authentication is sufficient for simple installations for few users. But security recommendations require a custom banner be displayed at the logon page. It will be nice if Redgate Monitor can do that without using OpenID or other external authentication methods.
1 vote -
Grant Web Client Access for Specific Elastic Pool, Instance or Database
We can currently share the web console out at the Server, Cluster or Replica level.
I would like more granularity and be able to share at lower levels:- SQL Server Instance
- Azure SQL Elastic Pool
- Azure SQL Database
We are a very large IT department with people dedicated to individual systems/databases.
I would prefer to hide things they don't own.3 votes -
View top queries, stored procs, top waits, index usage at estate level on Azure SQL
You can currently only view the top stats at DB level for Azure SQL. We run a multi-tenanted SaaS application where all DB's are identical across the estate, so to be able to compare offending stored procs, indexes etc. across the board would be incredibly helpful.
4 votes -
DataRetention setting and Performance troubleshooting data per technology because needs may be different
Possibility define DataRetention setting and Performance troubleshooting data per technology because needs may be different between sqlserver, postgres , mysql, etc, and improve disk space of seacrh engine queries.
7 votes -
Search by Query hash in Top queries
As discussed in https://forum.red-gate.com/discussion/91306/search-by-query-hash-in-top-queries/p1?new=1
it would be very useful to be able to search by Query hash in Top queries.Scenarios:
- for complex (and parametrized) queries it may not be enough to be searched by QueryText, DatabaseName or ParentObjectName;
- if queries impact is also investigated and tracked in external systems the QueryHash may be (the only common) field to quickly identify and find that query in Redgate Monitor.7 votes -
Track Aborted Sessions
The ability to view aborted sessions, either an alert or space on the overview page in a similar way to the TOP 10 queries.
Attached is the offering from SolarWinds.
8 votes -
SQL Versions Page
Hi there,
We maintain a number of legacy SQL Servers that are still monitored via SQL Monitor. I regularly use the SQL Versions page to identify which instances require patching.
However, some of these servers are under a permanent patch freeze, and I’d like to update their status to “OK” so they no longer appear as needing attention.
It would be amazing if one could update the patch status for these servers within Redgate to mark them as compliant to reflect their frozen state.
3 votes -
Deploy the latest API when updating Redgate Monitor
I would like when installing the latest version of Redgate Monitor to have an option for it to deploy the latest version of the API as well to a location. The last few times I have done the install I have not updated the API right away as it been a set and forget thing. Comes the evening when it runs it fails due to the versions not being the same.
I have checked within the Program Files and 2/3 of the files are not there. (RedgateMonitor.psd1 and RedgateMonitor.psm1), so I cannot just have it import via that way.4 votes -
Data retention - auto shrink if SQL
Recently engaged with redgate support about this and was advised to raise on here.
When changing data retention settings within Monitor and reducing the timeframe, it does free up space within the database but it isn't released.
Adding a routine within Monitor to run a shrinkfile against the database would be an ideal solution, but even adding a button/form within Monitor to set up a SQL agent job to do this in a standardised way would be fantastic as a quality of life, as if you're reducing the retention it's usually going to be because of disk space constraints.
2 votes -
We would like to have a log of users that did use RedGate Monitor
In that way we could create a report of the users when they did use RedGate Monitor. example a weekly or monthly report showing how many times a user did use the application.
3 votes -
flexible disk configuration
Currently the configuration for disk space monitoring in “RedGate Monitor” only gives the option to check on the number of bytes that is still free on the disk (in GB or MB).
Ideally one should check on the number of bytes in combination with the % free space.
The reason for this is that percentage hugely differs depending on the total size of the disk. On a small disk one would like to extend the disk when it is 80% FULL, where as on a much bigger disk, 20% space might still be many GB’s and to early to extend…4 votes -
Monitor an Azure SQL Database geo-replicated secondary database
We have geo-replication set up for many of our production databases, and we have some processes and users that use that for executing read-only queries. We have alerts set up in Azure Monitor for simple things like when CPU % exceeds 95% for more than 2 minutes. We would like to use Redgate Monitor to identify the workload that is causing that (Top SQL). However, when we try to add the secondary server, Redgate Monitor cannot find any databases in it.
4 votes -
Add additional metrics for Latency, Failover, queries categories for MongoDB
• Replicaset metrics around latency and failovers…etc. Like SQL Server.
• Something to track queries performing large scans vs seeks.
• Would be nice if the alerts (even if duplicated were broken out by platform. They are shown by SQL which I get is your primary offering, but just saying also postgressql vs seeing its PostgressSQL on Linux or MongoDB on Linux and change the alert offering to reflect those in a separate grouping like SQL.
1 vote -
Additional Overview Tab Suggestions
• OS configuration (how many sockets/cores and Memory are allocated) * SQL Server, Mongo and PostgresSQL environments Right now there are only %’s, I want to see of what.
• MongoDB Memory configuration I see SQLs but Mongo is missing. i.e. WiredTiger Cache settings
• ReplicaSet information for Mongo, along with who is the primary, secondaries and where are the secondaries seeding from, and the status.
1 vote
- Don't see your idea?