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.
791 results found
-
Displaying the actual names of the disks and not just the Volume Number for the Disk space alert
In SQL Monitor when you are using the disk space alert in conjunction with multiple volumes on different mountpoints SQL Monitor tends to display just the HardDisk Volume number in the alert, this is extremely unhelpful as it means you have to log on to the physical server, launch diskmgmt.msc and match the disk thats alerting to take any action. Is it possible to just display the mount point name as opposed to the Disk Volume Number? This would be extremely helpful and would give a wealth of information instantly.
20 votes -
Monitor Resource Governor
Possibility to monitor Resource Governor Pools:
• Show statistics on pools
• Show workload of groups: cpu, io and memory20 votes -
Monitor SQL Fabric from Redgate Monitor
As our company leans into Microsoft Fabric, we'd love to continue utilizing Redgate's tools, but unfortunately, they're mostly incompatible. Our highest priority is the ability to monitor Fabric SQL from within Redgate Monitor, closely followed by Redgate Toolbelt functionality within SSMS. We love Redgate and we're moving into the future with Fabric. Please help us remain a dedicated customer and not have to look for additional tools. We love Redgate!
20 votes -
Add capability to export Alert information in csv, xml format for analysis
It would be good to be able to export Alert information for downstream analysis of frequency and timings for Alerts. E.g. Deadlocks over a period of several weeks - allows to identify hotspots and trends for certain Alerts
19 votes
Daniel Rothig
responded
(Gathering feedback)
Hi, is frequency analysis something that we could offer in-app, or would you specifically prefer to export the data first?
-
Custom metric: alert when value changed
I want to be alerted if someone creates or deletes a database. The metric itself is easy (select count(*) from sys.databases - executed for the master DB on all servers).
But in the alert setting I can only define that it should trigger if the new result is abover or below a set value but not for value changed (compared eigther to the previous value or the "baseline").
So I have to create two metrics / alerts for DB drop (below) and create (above) AND have to define / modify the number of databases as alert threshold for each server…
19 votes
Daniel Rothig
responded
-
allow analysis graphs to update with realtime data without having to manually refresh them
We have SQLmonitor analysis graphs running on wallboards to show us data that is useful to us, but we continually need to click the button to "jump to present", as the timeline does not update as more data is collected to show the most recent history. We want the graph to move automatically to match the current time of day.
Maybe a "play" button that would allow thye display to automatically refresh the graph along the timeline and a pause button should you want to drill deeper into a certain time period when investigating issues. Having the graph update automatically…19 votes -
Customise Email Settings For Each Alert Setting
It would be great if you could have an override on each alert to allow for a customised email setting just for that alert.
Currently an alert can have a different email address BUT it only uses the default settings, if I wanted to fine tune for that alert I can't.
Thanks, Steve19 votes -
Force re-check of index fragmentation alert
The index fragmentation alert is checked only once per week, because of the load is causes on the system. I am fine with that.
However, I would like to have the option to force an immediate re-check for a specific database - for instance by adding a "re-check" button to the alert window.SCENARIO: The index fragmentation check runs on Saturday and triggers an alert on one database. On Monday I check the alert but I know that the weekly index defragmentation job runs on Sunday, so it is likely that the problem is already fixed. But I like to…
19 votes -
Monitor Hyper-V hosts
https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/2936441-identify-if-virtualization-hosts-are-congested is closed, so I'm opening a new suggestion - please add the ability to monitor Hyper-V hosts, similarly as we can currently monitor VMware hosts.
19 votes -
Monitor Table Growth and get projections
It would be nice if in the Estate tab under disk usage, we could dig deeper and see table growth and projected growth over time.
19 votes -
Save metrics used on Analysis page and enable quick way to select them from GUI
I find myself selecting the same SQL metrics when monitoring or analyzing issues.
It would be nice if I could save metrics and settings for them and next time just select them from the drop-down.19 votes -
Add multiple actions for alerts based on different conditions
It would be nice to be able to configure different actions for the same alert based on different criteria.
For example, with the SQL Job failure alert - It would be very useful to be able to have these alerts go to X email address if the job contains "DBA" in the job name, and the alert go to Y email address if the job doesn't contain that text in the job name (This is just a basic example, being able to configure multiple of these types of filters would be the goal).
Right now the only possible…
19 votes -
Baseline machine metrics across cluster failovers
CONTEXT: Using the Analysis graph for historical performance analysis of machine metrics on a cluster that failed over at least once
PROBLEM: Machine metrics are collected per node. Baselines of only one node can be shown at a time, and so no baseline view of performance on the "active" component can be synthesised.
EXAMPLE SOLUTIONS:
• Enable multiple simultaneous baselines
• Implement synthetic (bimodal) baselines across cluster nodes
• Provide synthetic metrics for entites on the "active" component of a clusterWhat do you think about these solutions? Got another idea? Let us know in the comments!
18 votes -
Reduce false positives due to log shipping / Mirroring
On secondary server for log shipping/mirroring false positives can be generated for overdue backups/databases unavailable. If these technologies are used for DR purposes then having the checks ignored is unsafe. It is trivial to filter these out with the below code and I'm sure there is something similar in place for Availability Group databases already.
SELECT *
FROM sys.databases
WHERE name NOT IN (SELECT secondarydatabase FROM msdb.dbo.logshippingsecondarydatabases UNION SELECT dbname(databaseid) FROM msdb.sys.databasemirroring WHERE mirroringrole_desc = 'MIRROR')18 votes -
global dashboard should handle multi-level groupings
Currently the global dashboard presents the SQL instance tiles according to their top-level group. So if I have 3 servers grouped such as:
App1
Prod
Svr1
Dev
Svr2
App2
Prod
Svr3it will present these under 2 groups: App1 and App2. This is fine if you're viewing all servers.
However when I filter the view to only show servers in the App1 group, I'd like the tiles to be grouped using the next level of grouping if there is one (in this case "Prod" and "Dev")
18 votes -
Allow custom metrics to only run on primary node of an AG
Allow configuration of a custom metric to only run on the primary node of an availability group.
18 votes -
Customize Disk Space alert for C: drive on all servers
SQL Monitor allows me to set global settings for Disk Space alerts, and then override for a complete server group, for all disk of one single server, or for a specific disk.
What I want is to have different settings for the system drive (C:) as compared to the other drives, Currently I need to set this for each individual C: drive, so one change per server.
Please make it possible to specify global settings (applying to all disks on all servers), and then add an override for C: on all servers.
18 votes -
Add Cname as a connection string instead of instance name
RGM usually connects with the instance name it automatically pulls down via the WMIC commands it runs on the nodes -There may be times were you have set the systems up that all connection certificates used the CNAME set up rather than the instance name for connection
Adding the ability to replace the instance name with a CNAME for connection will allow RGM to connect to the server securely18 votes -
See disk percentage free/used to Machine overview page
It would be useful to see disk percentage free/used on the machine overview page next to the used / allocated column. This would give us a quick idea of how full the machine's disk is percentage-wise without having to do the math elsewhere.
17 votes -
View queries against specific database in real time
View all running queries against a specific database with the details of the query and its duration.
This will help in monitoring a specific query in any particular time
17 votes
- Don't see your idea?