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.
788 results found
-
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 to…
10 votes -
Clear Select Alerts from Dashboard when ended
I'd like the ability to close alerts from the Latest Alert board if they are ended. A checkbox in Alert Configuration to self-close alerts once Ended would be good to have
Eg: I have certain 5-minute jobs that fail once a day if their corresponding run completes I'd like the Alert to clear itself.I can configure the Alert Ended to send email notification stating its ended but it still stays active on the Alerts list in SQL Monitor.
10 votes -
Who ran the query and what time
I would like to see in sql monitor who was the person that ran the query and what time the query was run.
10 votes -
“Longest Running Queries” in Redgate SQL Monitor Reports
I need to show more “Longest Running Queries” in Redgate SQL Monitor Reports. The layout of the report is also a bit awkward, it seems if everything does not fit into the report.
See attachment.10 votes -
Monitor Cluster Shared Volumes
Under the “Analysis” section, there are cluster metrics which include four different options relating to Cluster Shared Volume usage.
• Used Bytes
• Used %
• Free Bytes
• Free %If we click on the above, we can review our CSV’s to see whether we are approaching the drives maximum capacity.
What isn’t included is the performance of the disk. For instance, under the Machine metrics section, the following is available:-• Disk avg read time
• Disk avg write time
• Disk read bytes/sec
• Disk write bytes/sec
• Disk transfers/sec
• Avg disk queue length.However, these…
10 votes -
Only Query Serverless Azure SQL Databases if they are Online and not Paused
As mentioned in the below post, SQL Monitor will keep serverless Azure SQL databases from pausing and saving us the money they are supposed to. I would like the Azure SQL monitoring piece to be rewritten to use the Azure API to determine both if the Azure SQL DB is serverless or not and if it is AND paused, don't run any queries that would wake it. Yet if it is NOT paused, get info about it and update SQL Monitor.
10 votes -
In AzureSQL, I would like Redgate Monitor to not "keep awake" systems which are set to "sleep".
Within AzureSQL you can set SQL Servers to be Serverless and also to "sleep after" a time window. This means you can save money for systems which are not heavily used.
I think Redgate Monitor needs to have a "light touch" mode for such systems where it will firstly check the config and say "ok, this server is asleep, I dont need to look at it" before reporting maybe in the infomration status "system asleep". When the system wakes up, it should monitor as normal.
This is a cost saving exercise since, after adding Redgate to our Legacy AzureSQL servers,…10 votes -
I would like to customize the behavior when job failures happen. We get an alert on the 1st but no additional until the job is successful
I would like to customize the behavior when job failures happen. We get an alert on the 1st error but no additional alert until the job is successful. It would be nice to have the ability to allow this behavior as a default but then have the option to have specific Job Failures alert every time (mainly for jobs that run weekly or greater).
10 votes -
Search by Query hash in Top queries
As discussed in https://forum.red-gate.com/discussion/91306/search-by-query-hash-in-top-queries/p1?new=1
it would be very useful to be able to search by Query hash in Top queries.Scenarios:
- for complex (and parametrized) queries it may not be enough to be searched by QueryText, DatabaseName or ParentObjectName;
- if queries impact is also investigated and tracked in external systems the QueryHash may be (the only common) field to quickly identify and find that query in Redgate Monitor.10 votes -
be able to extract all alerts at once rather than extracting for individual alerts via API
Redgate Monitor API currently allows users to extract alert details for individual alert types. We need an API endpoint that can extract alert details for all alert types instead of calling the API multiple times.
10 votes -
Tracking Aborted Queries and Memory Grants in Redgate Monitor / Azure SQL Managed Instance
After contacting Red-Gate support, I understand that individual query monitoring for Azure Managed Instance is currently not supported nor on the roadmap. Is it possible to add this feature to an upcoming release of Red-Gate Monitor?
TL;DR Below
The article below mentions the ability to track cancelled or aborted queries. This would be particularly helpful for Azure SQL Managed Instance.
Tracking Aborted Queries and Memory Grants in Redgate Monitor
https://www.red-gate.com/blog/tracking-aborted-queries-and-memory-grants-in-redgate-monitor• Cancelled or aborted queries – immediately see when a query fails to complete, whether due to timeouts, user cancellation, or connection issues
Query Executions in Redgate Monitor
https://www.red-gate.com/hub/product-learning/redgate-monitor/query-executions-in-redgate-monitor10 votes -
The ability to pull ALL job names
from an instance view their statuses have a high level overview of the success to failure ratios on the jobs listed. Then the ability to export the results to different formats (csv/pdf/html)
9 votes
Daniel Rothig
responded
-
More options for Custom Metric Frequency
Would it be possible to have a custom option for the Custom metric gathering, as it stands the data can be collected at intervals of 1,5,10,30,60,1440 minutes
it would be nice to be able to select a custom value and values less than a minute, the standard metrics that are gathered appear to be gathered every 20 seconds which isn't an option here
Thanks for your time and concideration
Ste9 votesDaniel Rothig
responded
Note that you can currently hack an arbitrary “seconds” value into the SQL Monitor database – but changing the Custom metric configuration via the UI will reset the collection interval to one of the default values.
-
Monitor if all SQL Server related Windows services are running, especially Redgate SQL Backup Agent.
I have found that backup jobs fail, due to SQL Backup service not running. Knowing that the service has stopped would be a great metric to have. This could then be extended to monitor other Windows services.
9 votes -
Add "not started within X minutes" delay before SQL Agent status alert raised
In an unpredictable maintenance window environment, as in, SQL Monitor's abilities in the window setting arena are inadequate, there are a reasonable number of times when SQL Agent is restarted with good reason.
As alerts are tied to pagerduty, it's a one size fits all Alert at present, which isn't helpful.
If a "delay emitting Alert for X time periods" could be added to this Alert, the short-duration bounces will go un-alerted, which really helps on call personnel to avoid unnecessary awakenings for "it is of no matter" Alerts.
In my case, there are 24 recorded incidents of this Alert,…
9 votes -
Generate Notifications using a RESTful API Call
Considering the various ways that your customers may want to receive notifications, the ability to make calls to a RESTful API would be a big win.
9 votes -
Use base monitor service user account to authenticate with vcenter
When monitoring a vcenter deployment, it would be nice if the base monitor service could just delegate the credentials it is running as rather than entering them in the username and password boxes inside sql monitor.
9 votes -
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 -
Shift Click to select multiple alerts
Add the possibility to select multiple alerts by using Shift + Click.
This was possible in the versions before alert grouping.9 votes -
temporary alert configuration
I have a SQL Agent job that is failing daily. I have already alerted the dev who is repsonsible. I now have two options:
1. Change the alert setting at the job level to not raise an alert when this specific job fails. Saves me from irrelevant alerts, but one day the dev will fix the problem and I will probably forget that I should turn this back on.
2. Leave the alert setting as is and spend a half-minute or so each day to clear the alert. Not a good use of my time and very annoying,Please consider…
9 votes
- Don't see your idea?