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
753 results found
-
Alert History on new Overview - Don't show Cleared Alerts
The slide-out Alert pane is useful on the Overview IF, and ONLY IF, under normal circumstances we want to see NON-cleared Alerts, like the default filter on the Alerts page itself.
Please make this pane behave like the Alert page's filter, and allow us to re-filter, to include cleared if we want to. But at the very least allow us to set a default filter (in my case NON-cleared).
Thanks.
7 votesHi, thanks for the suggestion. The version 6.0.10 release added the ability to show/hide cleared and ended alerts from the timeline and alert sidebar on server overviews. We intend to add this to the global dashboard soon. Hopefully this solves the issue.
-
Improved view of User Sessions
Visibility into user sessions could be improved. The current list on the instance overview, "SQL User Processes (Top 10)", is a start but needs the following to make it useful:
1) Don't limit the number of sessions shown; rather add paging controls like on the error log view, so that it would be possible to see any session for any selected time period
2) Add a columns for:
- Login (i.e. login name)
- Blocked by session Id (maybe even an icon if a session is blocking/blocked?)
3) Make it possible to sort by any column
4) Add ability to…13 votes -
Collect SQLServer:Memory Manager counters.
This would be especially useful for SQL 2012 where counters have been removed from the buffer manager exist in the memory manager counters. For SQL Server 2012, I have observed that there is a memory leak and this is revealed by observing the Memory Manager Optimizer Memory (KB) counter.
1 vote
Daniel Rothig
responded
Hi, we’re monitoring a few of those out of the box and the rest can be covered via the custom metrics feature – check out sys.dm_os_performance_counters
-
Add an index to Alert.Alert on AlertType to remove index scan
Here's the index. It really helped speed up the system (monitoring 20 servers)
USE [RedGateMonitor]
GO
CREATE NONCLUSTERED INDEX [AlertType]
ON [alert].[Alert] ([AlertType])
INCLUDE ([AlertId])
GO3 votesClosing as it’s being tracked as a bug – thanks Phil!
-
Remove single AG replica
Currently when adding an Availability Group it automatically discover and add all replicas which is great.
However sometime we might not want all replicas to be monitored, in our case it's because of limited bandwidth on a certain asynchronous node. While it is indeed possible to "Pause Monitoring" on that node, it would be nice to be able to delete it completely (using some kind of exception list so it's not re-added automatically).
6 votes -
Notification
Generate Notification Per Alert (optional) and Show in windows
when Browser is Close.
And then Send Text Message To User Mobile Number1 vote -
occurrences
Please retain a "tombstone" that can be referenced to present a history of "Occurrences" for HIGH Alerts. Allow us an additional retention period so these don't hang around forever - but please don't limit the number of days, just a smallint would be good.
When Monitoring Fails and is cleared, the Occurrence disappears when DB maint nukes "old cleared Alerts". If the retention period is short, say 14 days, the history of occurrences is soon lost.
A "tombstone" would at least keep the occurrences for trending.
6 votesJust keep the alert data in the Purge settings indefinitely – it’s only the metadata of the alerts, none of the performance data, so are “tombstones” as you described
-
Add Text Boxes/Areas to Reports
I have reports that I circulate from SQL Monitor. I have to edit these before I issue them to add additional information. E.g. Under the "Lock Waits/Sec" chart I have a description of what a "Lock Wait" is, what impact it has, what's an acceptable value, etc. I tried supplying a supplementary sheet with this info but the management team prefer it under each chart / metric.
1 vote -
ignore events triggered from SIEM vulnerability scanners..
when we run a vulnerability scan on our SQL servers we get a lot of redgate alerts, i know you can setup to ignore certain alerts and have a maintenance window but ignoring the alerts isn't an option (what if its actually a hack) and the maintenance window is dangerous for obvious reasons.
3 votes -
Be alerted when a database approaches it's maxiumum file size
Whether or not autogrowth is enabled, I'd like to be alerted when a database approaches it's maximum file size.
1 voteHi Jason,
The ‘Database file usage alert’ will provide this sort of alert. See https://www.red-gate.com/hub/product-learning/sql-monitor/avoid-running-disk-space-ever-using-sql-monitor.
-
Being able to filter "TOP Queries" by any of the columns
On the "TOP Queries" grid we can order it by any of the columns (besides "Database").
I would like to be able to filter the rows by the amounts.
Example:
Filter queries where "Execution count > 100" same for other columns.
Then apply the "order by".This way we can filter together with the "Enter search term" box.
6 votes -
see an administrative web-based log viewer
Having the ability to review logs in a web-based interface is useful for administrators of a tool so we can diagnose and remedy some problems without needing to reach out to support. The downside is the log needs to be filterable or multiple log files need to exist.
An example of a log that would be useful would be an email log. In the event an email fails to send, I'd like to know why without needing to download the entire log in a zip, extract the zip locally, and browse through it when I am looking for a specific…2 votes -
More options for Custom Metric Frequency
Would it be possible to have a custom option for the Custom metric gathering, as it stands the data can be collected at intervals of 1,5,10,30,60,1440 minutes
it would be nice to be able to select a custom value and values less than a minute, the standard metrics that are gathered appear to be gathered every 20 seconds which isn't an option here
Thanks for your time and concideration
Ste9 votesDaniel Rothig
responded
Note that you can currently hack an arbitrary “seconds” value into the SQL Monitor database – but changing the Custom metric configuration via the UI will reset the collection interval to one of the default values.
-
Filter for Database with no Tlog backup
On the Estate->Backup page, it would be great to have an additional drop-down option for 'DBs without Tlog"
2 votes -
Grant user access down to SQL instance or database level
Currently the lowest level we can grant users access to cluster level. In multi-instance clusters this gives too much. Need to scope user access to instance and database level.
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 -
Allow maximum number of email notifications in a 24-hour period alert to be sent to another email address
Currently if too many alerts for a particular object are received an alert email is sent noting that no more emails will be sent. I want to be able to specify that email is sent to a different address than the default.
For example, we may get a large number of deadlocks. after the first 150 the alert emails are silenced. We configure deadlock alerts go to our normal email address because generally they aren't urgent, however when 150 or more are received there is a definite problem that needs to be reviewed. That should go to our pager email…
9 votes -
Blocking process Hover Information should show Total Blocking Duration
The (Restored in 8.0.6) hover over the Alert List's "Last Updated" column shows the duration of the Alert itself, NOT the total time involved.
Unless you memorize the configuration of this Alert for each of its 3 severity levels, and assume they never change, and never vary by server, nor by database... you must sill open each event to see the "Total blocking duration for all descendants" published under the "Details" tab, then add that to the event duration, for which you must now do time subtraction as there is no "Duration" on the Status line... (another omission).
Having…
3 votes -
Display running SQL text instead of full batch
Hi Team,
Currently, Active Sessions displays the full batch text instead of the exact running SQL statement. It would be significantly more valuable to show the specific executing query text.
Having immediate visibility into the exact query would allow us to quickly identify blocking, long-running, or resource-intensive statements without relying on additional tools or manual investigation. This would reduce troubleshooting time, speed up incident response, and improve overall performance monitoring efficiency.
I believe this enhancement would provide clear operational benefits for teams managing busy production environments. Thank you for considering it.
6 votes -
See job history beyond one month
Currently the Estate Job page only offers a view of a day, week or month, but sometimes we need to see trends beyond one month.
Is it possible to add a variable window? Or a fixed one of a year?6 votes
- Don't see your idea?