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
724 results found
-
Resizing Reports
It would be quite good if you could edit the size of the report and stretch to make it easier to read. Currently (may be an option to) the data over a 7 days period for example is condensed.
1 vote -
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 that information useful, so maybe you know another way to inform the DB owners with these alerts with existing functionality.
Thanks.
Best,
Jose.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 -
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 -
Get notification for when a SQL Agent job is in a retry state
Hi, it would be really useful if SQL Monitor could identify when any currently executing job steps are in a retry state. We have many such jobs and the time lost whilst they are in such a state is frustrating as if we had notification we could take action. I appreciate I can roll my solution but would be nice if SQL Monitor could do it :)
1 vote -
Get notification for when a SQL Agent job is in a retry state
Hi, it would be really useful if SQL Monitor could identify when any currently executing job steps are in a retry state. We have many such jobs and the time lost whilst they are in such a state is frustarating as if we had notification we could take action. I appreciate I can roll my solution but would be nice if SQL Monitor could do it :)
0 votes -
Add a description for users in the manage users for active directory
In some environments, the user login doesn't necessarily match the true user's name. This would help navigate what the user is assigned to that specific account.
1 vote -
Exclude System Databases (and potentially other user databases) from backup alerts
We would like the ability to exclude system database from the backup alerts, as we do not back them up. We have a system in place to script out security and sql agent jobs/schedules for each of our systems nightly. We also have been leveraging the dbatools PowerShell stack as a way to automate server migrations and other automation activities. Also, our tier one systems are in availability groups. Lastly, we do not backup everything in our lower level environments, as we perform nightly database refreshes for the majority of our systems. However, we do have some testing databases that are not refreshed and we do back them up daily (simple mode in lowers).
We would like the ability to exclude system database from the backup alerts, as we do not back them up. We have a system in place to script out security and sql agent jobs/schedules for each of our systems nightly. We also have been leveraging the dbatools PowerShell stack as a way to automate server migrations and other automation activities. Also, our tier one systems are in availability groups. Lastly, we do not backup everything in our lower level environments, as we perform nightly database refreshes for the majority of our systems. However, we do have some testing databases that…
15 votes -
Job Duration Unusual: ability to set different thresholds for different jobs
Some jobs that take a few minutes, others routinely take a longer time to run, and so it would be useful to set different thresholds for different jobs.
The current set up allows for excluding jobs from the alert, but offers no way of still monitoring those jobs.
I only want to exclude the jobs from monitoring, only if its possible to add in another alert just for them.
The documentation seems to hint that you can configure different alerts for different jobs, but all I've found is the high medium low thresholds, and this isn't the same.
This combined with the Median duration based on last 10 run times, is swamping us with alerts.
Some jobs that take a few minutes, others routinely take a longer time to run, and so it would be useful to set different thresholds for different jobs.
The current set up allows for excluding jobs from the alert, but offers no way of still monitoring those jobs.
I only want to exclude the jobs from monitoring, only if its possible to add in another alert just for them.
The documentation seems to hint that you can configure different alerts for different jobs, but all I've found is the high medium low thresholds, and this isn't the same.
This combined…
2 votes -
Export a Databases report to Excel including Name, Availability, Transactions/sec and Database size for any time period
In SQL Monitor I want to export a Databases report to Excel including Name, Availability, Transactions/sec and Database size for any time period. You can see this data and screenshot it, but it would be much more professional, useable and positive for management if I could deliver it in Excel instead of combining screenshots.
1 vote -
Suppress Free Space monitor (Azure Hyperscale DB)
When using Azure Hyperscale DB - the DB auto grows - therefore the Free Space monitor needs to be silenced/ignored forever (except if you about to hit the max of 100TB!)
5 votes -
Alert for full filegroup
if a database is a fixed size (max size set), or if the db is initially set to be the full size of a disk, there is no alert to let us know that the database is full.
for instance - if T: drive contains tempdb (and only tempdb) and we've sized it to take the whole drive. we've done funky sizing and growth settings so we can get an alert when the db grows, but once its grown and the temp objects are cleared, we're unlikely to get another disk warning, because the DB will already be taking 100% of the disk.
If we could get an alert on the error below - it would allow a greater degree of flexibility when databases fill up (due to fixed size or expired disk space alerts)
Could not allocate space for object 'dbo.#wak' in database 'tempdb' because the 'PRIMARY' filegroup is full
if a database is a fixed size (max size set), or if the db is initially set to be the full size of a disk, there is no alert to let us know that the database is full.
for instance - if T: drive contains tempdb (and only tempdb) and we've sized it to take the whole drive. we've done funky sizing and growth settings so we can get an alert when the db grows, but once its grown and the temp objects are cleared, we're unlikely to get another disk warning, because the DB will already be taking 100%…
6 votes -
Filter for Database with no Tlog backup
On the Estate->Backup page, it would be great to have an additional drop-down option for 'DBs without Tlog"
2 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 -
Understanding what caused the Diskspace alert
When viewing a disk space alert, it would be very useful to view the disk space usage for the drive the alert is raised for?
Ideally I'd like to to be able to get to the page: the Estate | Disk usage | [and filtered for the Specific Server: Drive:]
I understand that on the detail page of the server, you can see the growth of the databases for the selected time period, but its not always db files that cause the alerts.
3 votes -
Ignore failing jobs using regex
the config for JOB DURATION UNUSUAL alerts allows the use of regex to filter the jobs to ignore.
this functionality would be very useful for FAILING JOBS alerts
6 votes -
Frequency of the customer metric
It would be useful if we can specify frequency less than 1 minute in the custom metric. Because sometime we need to check any metrics more than once a minute.
3 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 -
It would be a great feature to have SQL Monitor suggest efficiency recommendations. The way that vperformance tuning settings based on acon
It would be a great feature to have SQL Monitor suggest efficiency recommendations the way that vRealize Ops Manager does, which is basically a tool you point at the environment and it shows you efficiency recommendations. Rather than having to perform time consuming manual analysis.
1 vote -
Monitor individual CPU cores and not just avg CPU as a whole
AVG CPU is not enough of an indication of how things are going - There could be an entire numa node maxed at 100% while other nodes are almost idle and it will drag the avg down.
As per here: https://forum.red-gate.com/discussion/comment/162141#Comment_162141
6 votes -
Alert for the jobs that is sucessful but with warning or a step level having issue
Alert for the jobs that is successful but with warning or a step level having issue . currently this is only shown as warning in the Estate > Backup tab
1 vote
- Don't see your idea?