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
733 results found
-
Filter alerts by Comment
Add back in the filter options, the filter on Have/Doesn't have Comment.
Add the possibility to search by comment.Wold be great if there was some sort of "Tags" that you can apply to an alert and to filter based on those tags.
11 votes -
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!
-
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
-
Customizing alerts without loosing inherited settings
Would be great to have the possibility to customize alerts on lower levels without loosing the inerited "customizations".
Otherwise there is the need to "copy" all the exclusions made on higher or highest level to the level that should be customized...
In example : i want to add a keyword for a specific query on Database Instance without loosing all the exceptions made for backup and so on.7 votes -
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 -
Notification
Generate Notification Per Alert (optional) and Show in windows
when Browser is Close.
And then Send Text Message To User Mobile Number1 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 -
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 -
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).
5 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 votes
Daniel 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.
-
MONITORED INSTANCES
Hello good day
When you enter the Global Dashboard session, it stays loaded and shows the blank page.Annex image of the page.
1 voteApologies that this was overlooked when the problem was reported. We believe this bug was fixed shortly after and are closing this suggestion.
If you believe this bug is still valid, please raise it on the SQL Monitor Support Forum at https://forum.red-gate.com/categories/sql-monitor-7
-
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 -
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 -
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 -
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 -
Add button to hide new grouping and use old grouping
Although the grouping seemed interesting at first, it means now our servers don’t fit on our screen anymore.
I would suggest adding a button to the "Group by" header that says "no headers" (or maybe a checkbox somewhere).
This button (or checkbox) would show the "old" layout again with the grouping on the left side as here: https://www.red-gate.com/wp-content/uploads/2019/10/SQL-Monitor.png
There is much more horizontal screen real estate than there is vertical; because of these new grouping headers we now need to scroll to see our DEV servers.
I am fully aware I can click the headers to…
3 votesHi Andy.
Thanks for the feedback. Groups can be opened and closed and the card sizes can be changed to control the number of instances visible. We feel that it’s important to show the group headings on the dashboard.
Thanks,
Neil
(Lead product designer – SQL Monitor) -
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?