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
716 results found
-
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 -
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 -
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 -
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
-
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 -
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 -
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 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 -
Alert for full filegroup
if a database is a fixed size (max size set), or if the db is initially set to be the full size of a disk, there is no alert to let us know that the database is full.
for instance - if T: drive contains tempdb (and only tempdb) and we've sized it to take the whole drive. we've done funky sizing and growth settings so we can get an alert when the db grows, but once its grown and the temp objects are cleared, we're unlikely to get another disk warning, because the DB will already be taking 100%…
6 votes -
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 -
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 -
Be able to see in the overviews panel how much RAM my monitored instances are consuming just like I can see CPU and Disk IO for example.
I want to monitor how much RAM my instances are consuming while I'm in the overviews panel and even though I can go to a specific panel for checking this specific counter it'd be useful to havr it in the single overviews panel and not moving back and forth.
2 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 -
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 -
Allow custom scopes in OpenID Connect authorization request
Currently SQL Monitor only sends the scopes "openid profile".
In my usage the "groups" scope is needed as well.Make this parameter configurable to support any number of custom scopes.
3 votesYou can configure OpenID Connect scopes by running a script on your SQL Monitor repository. See Authenticating with OpenID Connect documentation (https://documentation.red-gate.com/sm11/adding-sql-monitor-users/authenticating-with-openid-connect) for more details.
-
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 -
Attach Custom Documentation To Alerts
I'd like to be able to customize things like an alert that job X has failed with a link to our own documentation on how to troubleshoot that job. It would be even better if these links could carry forwards into the slack notifications but even just having them on the alert page in SQL monitor for that particular alert would be immensely useful.
6 votes
- Don't see your idea?