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
-
Add other Red Gate tools to SQL Monitor as licensed modules
It would be useful if the following tools were additional modules that could be added to the web interface to SQL Monitor;
SQL Backup Pro
Index ManagerFor example, upon receiving a no database/log backup alert it would be great to just click into another section of SQL Monitor to then diagnose/fix the issue rather than using an external application. Additionally the capability within Index Manager would sit well in SQL Monitor as a logical extension for the fragmented index alert.
This would allow SQL Monitor to be the primary place that a DBA would need to go in…
11 votes -
View stats for queries across databases and / or servers
Given that one has multiple similar databases, recieving the same queries, having same indexes and so forth. Currently one are able to view top-queries on server and database level, but what would be very valuable is to see the same information across databases on a server and across servers where one would then match the query on a content of the query itself. Then one could pinpoint globally what queries that has high io / cpu / ... even tough they on a individual db-level is not "high"
1 vote -
I am making reports in the Red Gate SQL Monitor. I am organizing them by databases in AGs. This is difficult because when selecting what dat
I am making reports in the Red Gate SQL Monitor. I am organizing them by databases in AGs. This is difficult because when selecting what database to monitor it is either ALL on server or an individual one. I have to put a new line for each database I want. Could you please also include "ALL in AG xxx". This way I do not have to add a line for each database in the AG I am monitoring, and if I add or take away a database from that AG then it will automatically be done on the…
1 vote -
Monitor repliction
Monitor replication (same as replication monitor)
5 votes -
Monitor database total space usage not by individual data files.
I have many databases that we are monitoring for space which have multiple datafiles. Usually most the datafiles are full but at least 1 of the files is able to autogrow. Sometimes autogrow has reached its max limitation and sometimes we have turned it off once the file reached the largest size we will allow it. Our goal is to monitor so the database does not run out of space. We currently get alerts for the files that are full, we know some are full, we aren't worried about them, we still have 1 or 2 files we allow…
10 votes -
Monitor SQL instances running in AWS RDS
Enable SQL Monitor to add AWS RDS instances as monitored servers
101 votesAmazon RDS SQL Server instances are now supported from SQL Monitor 11.
See https://documentation.red-gate.com/sm11/adding-and-managing-monitored-servers/adding-servers-for-monitoring/add-amazon-rds-sql-server for more details.
-
exclude databases from alerts with a named pattern
Some of our databases are named "XXX_Database", the "XXX" indicating that it should not be monitored. It would be nice to exclude those from alerts based on a given naming pattern.
22 votes -
where is sql server database mirror status
i want see sql server database mirror status
10 votesWe’ve seen mirroring to be used by a vanishingly small portion of our userbase, and it’s not growing.
However, you can create Custom Metrics and alerts to get the same information into SQL Monitor
-
Monitor Windows 2012 R2 CSV Volumes (Cluster Share Volumes IO/space and other metrics)
CSV Volumes have their own windows performance counters and can be used by resources owned by any of the Windows Cluster
43 votes -
Exclude individual databases entirely from scope
There are some databases (including the RedGateMonitor database) that i do not want to see reported with alerts. I want the ability to omit certain databases entirely from the scope of monitoring and leave all other databases on that machine in the scope of monitoring/alerts.
2 votes -
SQL Server agent job alert
Say somehow the sql server monitor wasn't enabled and some job failed on one of the monitored servers that time; when the SQL Server monitor comes back online I would appreciate, it showing this error, in the same manner, the monitor tool shows the overdue alerts for Integrity check, backups etc
1 voteWe decided against this in order to avoid a scenario where users are greeted by an onslaught of Job Failure alerts when they add a new monitored server
-
Offer SQL Monitor as a Saas model
Would be great to offer sql monitor on a Saas model. $50 per server per month for example.
Purchasing software upfront is expensive for small/medium companies. This also offers more flexibility to add and remove licenses in line with how companies add and remove new servers.9 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 -
Use (Group) Managed Service Account Credentials for Server Monitoring
Allow the use of managed service accounts (MSA and gMSA) as credentials when monitoring servers.
Given the high-level permissions required to fully monitor servers, this would provide a higher level of security to match.
48 votes -
TempDB Percentage Free Space Monitor/Alert
Common practice is to put TEMPDB files on a dedicated disk and size TEMPDB to fill the entire disk.
When TEMPDB grows unexpectedly it can quickly use all the space on the disk and is a common cause of SQL Server issues.
We have great observability about TEMPDB issues in SQL Monitor now but no default alerts.
We have some metrics we can alert on such as TEMPDB Free Bytes, but a literal value is not much use in a mixed environment where some servers have 1TB+ TempDB databases and some have only 30GB.
We collect a custom percentage…
5 votes -
Monitor Resource Governor
Possibility to monitor Resource Governor Pools:
• Show statistics on pools
• Show workload of groups: cpu, io and memory18 votes -
Monitor Azure Managed Instances
Redgate Monitor still does not appear to fully support Azure Managed Instances. As our primary business is about to move across solely to Azure Managed Instances, this is now a seriously high priority for us.
We are heavy users of Redgate Monitor for our business, so this is now starting to be become a bit of a worry for us.
46 votesWe're now supporting Azure Managed Instances.
If there is something you think we're missing from this feature, please let us know at SQLMonitorFeedback@red-gate.com
-
Alerts in SERVER Time Zone, NOT Browser!
Back in June 2016, I added the following to the now-defunct "Previous version" SQL Monitor Forum. The responder said it was in the Q for the next sprint, no promises as to its inclusion. DISAPPOINTMENT/FRUSTRATION continues to be experienced 6 MONTHS later!
Alerts at SERVER time, NOT UTC! PLEASE!
For the love of all DBA's with servers in multiple time zones (yes, this happens), for goodness sake STOP emailing the time of the Alert based on the SQL Monitor's Regional Settings.
In 2016, this statement from the page at https://documentation.red-gate.com/display/SM5/Alerts, is nigh on unbelievable, "All alert times…
27 votes -
Save and Export/Import sql monitor settings
Setting up custom alerts and servers is quite a bit of work. For example some jobs are more important than others. A different set of people get notified for some jobs. I have setup custom alert settings on many of the jobs this way. recently I had to move monitoring host to a different server and replicating same settings took me a lot of time. hence need ability to be able to export settings from one server and import to another. May be this will work through the monitoring database but I had to change the database…
69 votes -
Specify databases for custom metric using wildcards
We have multiple databases for each of our clients - each type of databases uses the same schema and follows a consistent naming convention. For example:
XXXXMain
XXXXExtra
XXXX_ManagementYYYYMain
YYYYExtra
YYYY_ManagementI want to add a custom metric that only applies to "_Main" schema so in order to choose databases to collect from I need to specify each database explicitly. This proves challenging as the number of clients grows and we add more servers / instances to our environment.
It would be preferable if i could instead use some form of wildcard to specify …
4 votesA bit of an edge case that would make things a lot more complicated for all users
- Don't see your idea?