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
721 results found
-
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.10 votes -
Clear Select Alerts from Dashboard when ended
I'd like the ability to close alerts from the Latest Alert board if they are ended. A checkbox in Alert Configuration to self-close alerts once Ended would be good to have
Eg: I have certain 5-minute jobs that fail once a day if their corresponding run completes I'd like the Alert to clear itself.I can configure the Alert Ended to send email notification stating its ended but it still stays active on the Alerts list in SQL Monitor.
10 votes -
Fix the column headers for the Top Queries when scrolling
On the Server Overview "Top Queries" section, it would be helpful if the header row of the table didn't scroll off the screen. I keep scrolling back up to work out if I'm looking at reads/writes/CPU Time/etc.
5 votes -
Password is blank when accessing the edit credentials in Monitored servers
Password is blank when accessing the edit credentials in Monitored servers for the monitored sql instance .
If any options need to be changed will need to update the password for the SQL and OS credentials1 voteThe password is intentionally blank. This is to prevent users that don’t have access to the server from changing these settings.
-
domain
Have the Redgate Monitor application support multiple AD domains for users. I have over 4 domains with users that want access to the application.
3 votes -
search Top Queries
I have a process that reports on stored proc outliers. When I go to SQL Monitor, it is very difficult to search the top queries to find the particular stored proc.
For instance, if I do a ctrl+f and search for "I.Invoices", the search may find that snippet in "hidden" areas (in the dropdowns) but I cannot tell where the found items are.
A query syntax search of the top queries would be extremely helpful.
9 votesQueries can now be searched. This is available from version 11.2.10.
Query search is still in preview. Please send any feedback to SQLMonitorFeedback@red-gate.com.
-
Skip warnings on Database Snapshot Backups
I'm seeing warnings about backups not getting done on snapshots. Obviously it's not looking at the type.
16 votesFixed in SQL Monitor 5.0.2
-
Remove "Configure alert" link from alert emails
This is a big issue for me because I send Job Failure alert emails to the development team, but I don't want different people configuring alerts on Redgate Monitor. Only DBA's can make changes to the monitoring configuration.
I don't think the "View full alert details" is necessary either. If developers need to see more information, they can look at the Job History.
4 votes -
Custom disk alerts in a cluster is lost when instance is moved to a new host
We often use customized disk alerts for larger disks i.e. instead of using the default alerts we might configure a High alert at 200 GB and a medium at 250 GB.
These custom alerts is not set on the instance level so when we move the instance to a new host the custom alerts will not follow the instance and the alert has to be set up again.
As our largest cluster is 9 node cluster with 23 instances and 3 disk each this cause us to configure these alerts at a maximum of 621 instead of 69 times. That…
21 votes -
Add more narrow time intervals in Reports
We are using the reports part of SQL Monitor to show them on a TV screen in a proactive way and we find this very helpful.
Now we have a question, would it be possible to include more narrow intervals like 6 h, 2 h and 30 min in the reports?
Because even if we lower the reports to 12 h and has auto refresh every 1 min it’s kind of hard to see and react on the spikes in the graphs.
An example can be seen in the attached fil - Batch request/sec report, it’s hard to spot the…12 votesThanks for this suggestion.
Version 9.0.8 has been released which has added 30 minutes, 1 hour, 2 hours and 6 hours to the Reports time filter values
https://documentation.red-gate.com/sm9/release-notes-and-other-versions/sql-monitor-9-0-release-notesWe’ll mark this as completed and welcome any further feedback you might have.
Thanks,
SQL Monitor Development Team -
Link to alert within Teams notification
I would like to see a direct link to redgate monitor alert within the teams notification. At the moment I have to search for the alert in the WebUI manually instead of clicking a direct link like it is in a mail notification with "View full alert details" button.
5 votes -
Customize Estate Version Thresholds
On the estate tab, it would be nice to customize the thresholds that define the yellow and red state. For example, a server behind on one CU might be yellow, but others red.
5 votes -
Only Alert Database File Usage on one copy of a database in Availability Group
When monitoring all instances of an Availability Group, the Database File Usage alerts on every instance. This just adds extra noise. It would be great if instead of alerting on each copy it just alerted once on the availability group somehow.
3 votes -
Configurable Thresholds Based on Time
The alerts would be more useful if we could apply maintenance or quiet periods to them.
I understand we have the maintenance window and that is perfect for things like planned downtime, index maintenance etc.
Regards,
CliveHowever, the issue I currently face is that I suppress the processor under utilised message. Like a prolonged spike in CPU activity, a massive drop off could be a concern too. However, I have a current mean of 18.6% on one example server. I can set a threshold of 15% as an example, but this would trigger alerts through the night when…
8 votes -
Webhook Filter on Alert Severtiy
Situation: After setting up a webhook of SQL Monitor to Service Now we are getting tickets of all priorities
Background: We would only like tickets to be created that are actionable
Assessment: We can enable this on the javascript side of the service now webhook to remove low priority webhook calls however it would be prefered to do it in RedGate
Recommendation: Is it possible to have the same feature that email has "Call webhooks only if alert severity is High or Medium only"
9 votesSupport for configuring the alert level at which Webhook notifications are sent was added in version 13.0.52.
In Configuration > Notification settings you can configure Webhook notifications to be sent for all levels of alerts, all high and medium alerts, or just high level alerts.
-
Retain user last selection and update current default time options to be more flexible
On the Overviews of an instance Server/Host Metrics the default selections are always the last 24 hours as well as having all 4 boxes ( CPU, Memory, Disk I/o and Waits) select.
I am constantly having to uncheck the Memory box and most individuals look at the last 6 hours or would prefer ( 1 or 3 hours) and have to change from the default last 24 hours to last 6 hours each time navigating to this page. I would like to be able to have SQL Monitor remember my last setting(s) or at least be able to change…
6 votes -
Receive an alert for the process that is blocking not the process being blocked.
We recently upgraded our SQL Monitor to version 5.1 and it appears there has been a change in the Blocking process metric. Before the upgrade we received an alert about a process that was blocking and after the upgrade it appears we receive an alert for each of the processes being blocked. We have set the threshold for 90 seconds and if there are three processes that are 30 seconds that total the 90 seconds, we receive an alert. However we don’t want to receive an alert for the 30 second blocked processes. Is there a way we can understand…
10 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 -
Globally enable/disable monitoring
We would like the ability to quickly turn off and on all monitoring and alerting globally. This would be usefull when we have major outage that we become aware of and start to work on, however alerts get generated very quickly and can overwhelm the email system or support phone. It would be great if we could continue to collect performance metrics but stop all alerts until the problem is resolved.
6 votesGo to Manage Monitored Servers, Select All, Suspend.
-
SQL USER PROCESSES (TOP 10 BY CPU) - drill down
Server hosts/matrix
Drill down
Some select's come up in mine, but I'm not able to drill down to find more details like the SQL itself4 votes
- Don't see your idea?