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.
686 results found
-
Alerts for high virtual log file count
Alert on high transaction log virtual log file count. Also being able to configure the thresholds to be alerted on.
4 votes -
Report from Primary server in HA Group, even after failover
In a High Availability Group we have reports configured against the Primary server. When there is a failover, the reports should still be against Primary but are no longer, so need to be edited. Ideally, we should have reports that are always running against Primary, even when it switches to another server.
4 votes -
Click to open analysis from alert window
For some alerts, I like to see not only what happened before, but also what happened since. Some examples are disk space, or database file usage. The latter for example has a nice graph of the file usage up to the moment the alert triggered. But when I look at it the next day in the office, I also want to see what happened since - did the file continue to grow, has it been stable since, or was this a peak and is less space used now?
Currently that means going to the Analysis tab, selecting the correct server…4 votes -
SQL Server Agent : Check the status of Agent XPs Server Configuration Option
Subject : SQL Server agent
Context : At this time, SQL monitor only check the status of the windows service to monitor the SQL Server agent.
but do not check Agent XPs Server Configuration Option.As a result, you could have a started agent, not able to launch any jobs and sql monitor will not raise an alert.
Solution :
- add a check of the column valueinuse in the sys.configurations table to ensure that Agent XPs is enabled when the agent service is started.
SELECT * FROM sys.configurations WHERE name LIKE 'Agent XPs'
4 votes -
User Defined Analysis Templates
Wouldn't it be nice to have the option of saving a view of multiple counters under Analysis?
4 votes -
date format
I'd like to have an ability to set date format according to the country where the monitored SQL server is in, e.g. USA where date format is MM/dd/yyyy vs UK as dd/MM/yyyy. Also, why not to read and set date format off of the monitored server? Please make it configurable and country compliant so to speak..
Thanks,
Yuriy4 votes -
Add custom alerts with exiting out of the box metrics
I would like to create custom alterts on existing out of the box metrics. I want to set an alert if for example PLE is going under a certein threshold. Without creating an additional custom metric.
4 votes -
Estate Page - Disk Usage - Show Actual with Allocated
There's plenty of real-estate to include a column for database file rows that shows the true "USED" space, not the Allocated space.
Right now, SQM is predicting data drive exhaustion at 16 days hence:
Fake "Used": 5,634.5 GB Capacity: 5,959.4 GB Fake "% Used": 95% Time until full: in 16 daysSadly, Untrue, from a "Used" perspective - only true from an Allocated perspective!
When I drill into that drive, THIS is the truth:
Used: 4,752.6 GB Capacity: 5,611.7 GBPlease promote this "USED" as a higher-level total, and use it as a projection - i.e., retain a history of…
4 votes -
Set Maintenance Window by Group
We do maintenance by class of server (DEV, QA PRD) and update an entire group during one maintenance window. It would be nice to be able to select a group like "Production" and set one maintenance window instead of setting it for each server. And since we do maintenance on the second Sunday for one group and the third Sunday for another we can't set a window and forget it. We have to set it before the weekend there will be work done and then clear it on the following Monday. More scheduling flexibility would be a wonderful addition.
4 votes -
ADD Support for GCP Cloud SQL (MSSQL managed instances)
As Google Cloud Platform increases their market share and adds features such as managed instances for Microsoft SQL Server, it would be great to have the ability to monitor those as well.
4 votes -
Change management for all changes made to your application and a report for the manager to review this change
Change management for all configuration change made in SQL Monitor and a report for the manager to review this change
4 votes -
Groups to which emails can be added and removed so that this group will be added in alert setting . this help if any change in DBA join o
Groups to which emails can be added and removed so that this group will be added in alert setting . this help if any change in DBA join or leaving the company . Otherwise will need to update all the alert type . Exchange sever groups cant be used if these type of notification email are forwarded from SMTP servers outside their infra .
4 votes -
Automatic failover when GEO replication is set up for PaaS servers
It would be great to have a feature to monitor automatic failover when GEO replication is set up between PaaS servers.
It is quite useful information to understand if failover occurs.
4 votes -
Configure job duration unusual alerts to ignore negative variances
Typically (although there are exceptions) I'm not concerned if a job has a high negative variance compared to baseline. One other way to satisfy this would be another suggestion already in here, allowing for more configurable options such as a floor/ceiling variance .
4 votes -
Display parameter list in the query plan form
It would be great to be able to see the parameter list from the query plan in the "Query Plan" form without having to download the plan and traversing the XML file.
It would save time troubleshooting problematic queries.
4 votes -
Shorten the focus window from 15mins to 1min
I want to be able to apply a shorter timescale to the focus window, 15mins is far too long on a very busy system.
I would like to be able to put a start / end date/time instead of selecting a time and then x hours before that
4 votes -
Report that shows top 50 long running queries across the estate
Submitting an enhancement request to expand the reporting capabilities for long running across the entire estate. The report tile only show a handful. It would be very useful to be able to run a report listing the top 25, 50, etc long running queries across the entire SQL estate. The data is available somewhere but instead of going into each instance a consolidated report would be greatly beneficial is order to identify queries for performance review. We are also going through an upgrade and are identifying queries to benchmark for before and after performance to ensure there is no degradation.
4 votes -
Add User Settings feature
Add a User Settings feature that will hold all user preferences, as different DBAs / users have different ways in using SQL Monitor. For example - (1) ability to display on the Overviews page only desired health levels (Critical, Warning, etc), or named group, or base monitor, or any combination, rather than load all servers from all groups from all base monitors. I really don't want to know that I have 265 healthy out of 275 servers - this will speed up loading of the Overviews page. (2) any other user preference.
4 votes -
Avg. lock wait time alert
Be able to have the Avg. lock wait time metric as a configurable alert.
this metric is already available in the analysis tab, but we can't define alert on it.
Avg. lock wait time
The average wait time (in milliseconds) for each lock that could not be satisfied immediately and had to wait for resources.Equivalent PerfMon counter: SQLServer:Locks - Average Wait Time (ms)
4 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
- Don't see your idea?