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
-
Increase SQL Monitor email Alerts to larger than 400 KB
We have some alerts for important servers that require you to login to SQL Monitor to see the full details because they exceed 400 KB. The alert currently reads:
"Details
Details omitted because they exceeded 400KB. Please log into SQL Monitor to view them.
View full alert details
Configure alert"Please increase this value so that we can see the full alert details within an email instead of having to login to SQL Monitor to see them.
Thank-you!
3 votes -
Improved windows range handling for Individual query monitoring
The current windows range on the new Query executions tab is fixed to 2 hours. Should be great if the length of the windows range could be customised.
At the same time make it working together with the zoom range on the History tab. This so if you have zoomed in to a certain time range on history tab then when opening Query executions the same time range should be used as the windows range. Alternatively you could use the same type of windows range and zoom range that are already used on the History tab.
4 votes -
Licensing Clusters
Since only one SQL server is active in an Active\Passive cluster, you should not require multiple Monitor licenses.
50 votesCurrently, we are offering a 50% discount for passive cluster nodes. We’ll continue to review our pricing structure over time.
Why do we charge money for passive nodes at all? Covering your passive nodes with monitoring is necessary to ensure that when a failover occurs, the passive node is in a healthy state, and the failover will be able to succeed. However, passive nodes don’t (usually) have complex performance characteristics, hence the discount.
-
AWS FSx drive status
In our company we are using AWS FSx drives for our SQL Server databases. The FSx drives are not real drives, they are more like a shared folder, I'm wondering if there is a way to add those drives on SQL Monitor so we can check disk space and get alerts. AWS has been adding more features for FSx drives to be used on SQL Servers. Right now the only way to monitor that is using AWS console or alerts, which are not very friendly and only available for some system administrators.
7 votes -
we dont allow ping to cross vlans so i cannot add servers to monitor
we dont allow ping to cross vlans so i cannot add servers to monitor
1 vote -
SQLMonitor consider the SQL Server cluster name as an instance
SQLMonitor consider the SQL Server cluster name as an instance
9 votesThis can be set within Display settings ('Failover Cluster Name Display') for a SQL Monitor configuration.
-
Control Alerts Using Metadata
CONTEXT: We have a maintenance and backup solution which uses SQL Server as a backend to determine what databases to perform the tasks against, and at what time.
PROBLEM: Some databases do not have maintenance tasks running against them, but still have alerts which appear in SQL Monitor for them (e.g. Index Fragmentation). I don't want to manually exclude these from SQL Monitor, as the number of databases fluctuates, particularly on our testing and development environments.
EXAMPLE SOLUTIONS:
- Provide a means of easily enabling/disabling/changing alerts dynamically using a stored procedure.1 vote
Daniel Rothig
responded
For your usecase I recommend modifying the maintenance window metadata instead:
UPDATE s SET MW_IsEnabled = 1, —or 0 to enable alerts again MW_Start=0, —midnight MW_Duration=864000000000, —24 hours MW_Monday = 1, MW_Tuesday =1, MW_Wednesday=1, MW_Thursday=1, MW_Friday=1, MW_Saturday=1, MW_Sunday=1 FROM [settings].[SqlServers] s INNER JOIN [settings].[Clusters] c ON c.Id = s.ParentId WHERE c.Name = ‘hostname’ AND s.Name = ’’ —Set to SQL Server name or leave empty for unnamed instancesA restart of the base monitor service will be required after the change
-
SQL Monitor currently does not have customization on scheduling for custom metrics
SQL Monitor currently does not have customization on scheduling for custom metrics- only per min\5 min\hour basis.
the option to setup your own schedule could be given to users and setup your own frequency or metric collection.15 votes -
Feasibility of selecting databases across the sql instances to create custom metrics
Imagine we are planning to create a new custom metric which we wish to use across several instances but one specific set of databases. its currently impossible and will be one to have.
3 votes -
Report showing least or busiest server.
I would like a report that uses the historical data collected by SQL Monitor that would show the least busy or busiest servers so that I will be able to plan where to put additional workload, or re-distribute work load.
3 votes -
add LDAP/NTLM authentication so that Windows domain users can log in as themselves
That's it, really - configure read-only/read-write access via Active Directory group memberships or user lists built into SQL Monitor, and allow individual users to log in using their own AD credentials.
142 votesSQL Monitor 5.0 lets you log in with your AD credentails. Admins can configure individuals or AD groups to have access to SQL Monitor, and have granular access control over which servers users can see.
-
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 -
Per database table fragmentation.....
I would like to see a a Sql Monitor "information" page that shows the "top 10" fragmented tables on a per database level.
120 votesGood idea! If this suggestion gets more traction, we’ll implement this.
-
Possible AI usage for Alerts in Red Gate Monitor
The alert system for Red Gate Monitor could be improved with some more intelligence. For example Full backup jobs and differential backups, weekly full, daily differential. Of course the differential will take a lot more time just before the full backup in comparison with the differential backup just after the full backup. If Monitor could "learn" the environment and only give alerts when things are really off then this would be much better.
4 votes -
See data in local server time
I'd like to all the data from a particular server in local server time instead of my time
2 votes -
Custom reports against alerts, queries and metrics
CONTEXT: We want to see the bigger picture arising from the data presented in SQL Monitor.
PROBLEM: Currently you can't pull together a report in the SQL Monitor UI, and the monitoring database is not particularly accessible. We need reports against:
- The metrics shown in the analysis graph
- The top queries and waits
- The alerts raised over time
- Server configuration and SLAEXAMPLE SOLUTIONS:
- Provide reporting scripts against the monitoring database
- Privide a BI interface against the monitoring database
- Priovide richer data-export functionality in the UI
- Provide a…263 votes -
Custom Metrics are specific to a base monitor without a way to copy them
I have to create all custom metrics and alerts 3 times, once in each base monitor. And there is no way in the UI to copy from one to another.
I guess this makes sense because each base monitor only knows about the groups and targets it has. But it would be a great enhancement if the UI supported copying the custom metrics from one base monitor to another.
5 votes -
Connect to Azure database via express route
Currently I'm only able to connect to Azure SQL Server (PaaS) via internet and URL servername.database.windows.net.
We have a direct connection to our Azure environment via Express Route. Therefore I want to use this also for the monitoring, but per default SQL Monitor uses external URL.
3 votes -
Forecast and plan disk/database capacity
CONTEXT: When looking after a large number of databases, we have to make sure that none of them run out of space or I/O capacity.
PROBLEM: SQL Monitor needs to show us:
• The current size of Database files (and which disks they are on) and how full they are, ideally with a forecast
• Autogrowth configuration
• Space remaining on disk, ideally with a forecast
• File and disk-level IO metrics, ideally with a forecastEXAMPLE SOLUTIONS:
• Provide this data as metrics in the Analysis Graph
• Create a Disk Overview report with this data
• Enhance…217 votesThank you for this suggestion. Version 8.0.10 released July 10th, 2018 includes a new Estate tab containing the new “Disk Capacity Planning” feature.
We hope this meets the requirements and will close this suggestion, but please do raise another suggestion if you have specific improvements you’d like to see.
Kind regards,
Adam
SQL Monitor Development Team -
Add ability to search Server Log
I would like the ability to search the error log or at least filter out some alerts. For example, we get about 45 "Log has been backed up" log entries every 15 minutes. It's very hard to actually find things on redgate without having to login to the SQL server and filter there.
8 votes
- Don't see your idea?