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.
766 results found
-
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 -
DatabaseName custom message parameter addition for Custom Webhook messages
I would like to share with the developers the alerts for the different databases we have in the same server instance. I noticed for custom webhook messages. It looks like the option was there (like monitoredEntity.azureSqlDatabaseName).
One of the SQL instances we have is a shared instance with multiple databases so the owner of the database can know exactly what database is failing
Right now I have the following custom message
{
"text": "{{alert-severity}}: An alert of type \"{{alert-name}}\" has been \"{{alert-status}}\" for {{alert-target-name}}.\r\nVisit {{alert-url}} for details."
}
Where I cannot specify which database is that alert for. I consider…
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 -
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 -
LDAPS Support for user authentication for Redgate SQL Monitor
LDAPS Support for user authentication for Redgate SQL Monitor . Now organization want to make the ldap communication to be more secure and moving to LDAPS communication . LDAP will be discontinued soon . When can this be implemented
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 -
see username and hostname in "top 50 queries" and "top 10 waits"
In SQL Monitor, I want to see username and hostname in "top 50 queries" and "top 10 waits"
Please add username and hostname in "top 50 queries" and "top 10 waits." These two columns will be useful to trouble shoot SQLs that are causing troubles
Thanks,4 votes -
save monitoring data of a specific day
When having performance related issues on environments we'd like to be able to "save" the data of a specific day or days in order to do a proper root cause analysis, even over a longer period of time.
Due to aggregation of data we're now seeing issues arise that after a certain period we're no longer able to access detailed monitoring data of that day through SQL Monitor. Being able to access this data in SQL Monitor helps us correlate this data against other monitoring systems even after aggregation.
Our suggestion would be to add a save button for a…4 votes -
Alert Type for Polybase Service
Standard Alert Type for monitoring of the Polybase service status analogous to the other services (Browser, IIS, Agent, Full-Text, etc. )
4 votes -
Set a configurable delay to send the Resolved/Ended emails
Sometimes the emails sent by SQLmonitor to PagerDuty are delayed for some minutes
In this case it can happen that PagerDuty received the "Resolved/Ended" emails before the "Raised" emails because this one has been delayed for too long and because the alert was resolved after 1 or 2 minutes...
When it happening the alert is never closed and generate a useless phone call
So to fix this issue we would like to delay all the "Resolved/Ended" emails send by SQL monitor to be sure that PagerDuty received the "Raised" emails before "Resolved/Ended" emails4 votes -
Long-Running Query Alert - Occurrences tab to refer only to instances of that query
In the long running query alert, the occurrence tab shows a history of occurrences of the long running query alert. These alerts are the history of any long-running query rather than just the query in the alert
It would be helpful to be able to see a long running query alert and see just the alerts for that query to be able to quickly understand whether this query is a regular problem, or something new.
I appreciate it is possible by highlighting the time period in the server overview page, finding the query and then viewing the query history but…
4 votes
- Don't see your idea?