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
-
Bring back the ability to list fragments of T-SQL to reduce Blocking Process alerts, please
By FAR the largest number of abject NUISANCE Blocking Process alerts I get across 17 servers is due to a simple "How is fragmentation going?" query from a 3rd party product (Idera Defrag Manager).
Looks like this:
use [DBName] declare @indexId int declare @dbId int declare @tblId int declare @partitionId int set @partitionId = 0 select @dbId = ISNULL(DBID(),-1) if @dbId=-1 RAISERROR( N'Database does not exist or permission denied: %s', 16, 1, '[DBName]' ) else begin select @tblId = ISNULL(OBJECTID('[DBName].[dbo].[TableName]') ,-1) if @tblId=-1 RAISERROR( N'Table does not exist or permission denied: %s', 16, 1, '[DBName].[dbo].[TableName]' ) else…
3 votesVersion 6.0.16 has now been released and this includes the ability to add regular expression filters to blocking process alerts. We hope this completes your suggestion.
Thanks, SQL Monitor Team
-
On the main dashboard please maintain a consistent ordering.
Dashboard element sorting should be fixed preferably in alphabetical order. The whole idea of a dashboard should be to provide an at a glance view of the state of your server set. When you change the order from servername when all is green to some other order because something has triggered an alert on a server I have to spend extra time figuring out which server has an issue because the sort order has changed.
1 voteVersion 6.0.11 has now been released and amongst the enhancements is the ability to fix the servers in alphabetical order (Oder by: Name).
If you have any feedback, email sqlmonitorfeedback@red-gate.com
Thanks,
SQL Monitor Development Team -
Force re-check of index fragmentation alert
The index fragmentation alert is checked only once per week, because of the load is causes on the system. I am fine with that.
However, I would like to have the option to force an immediate re-check for a specific database - for instance by adding a "re-check" button to the alert window.SCENARIO: The index fragmentation check runs on Saturday and triggers an alert on one database. On Monday I check the alert but I know that the weekly index defragmentation job runs on Sunday, so it is likely that the problem is already fixed. But I like to…
16 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 -
global dashboard should handle multi-level groupings
Currently the global dashboard presents the SQL instance tiles according to their top-level group. So if I have 3 servers grouped such as:
App1
Prod
Svr1
Dev
Svr2
App2
Prod
Svr3it will present these under 2 groups: App1 and App2. This is fine if you're viewing all servers.
However when I filter the view to only show servers in the App1 group, I'd like the tiles to be grouped using the next level of grouping if there is one (in this case "Prod" and "Dev")
18 votes -
Add a summary tile for deployments to a database
I'd like to see a summary tile for deployments to a database by SQL Compare and SQL Change Automation.
Also it would be good if alerts can be created for these events.3 votes -
Save metrics used on Analysis page and enable quick way to select them from GUI
I find myself selecting the same SQL metrics when monitoring or analyzing issues.
It would be nice if I could save metrics and settings for them and next time just select them from the drop-down.19 votes -
Save alert email addresses
I monitor a large enterprise and forward hundreds of alerts using cut/paste. If recent addresses were retained, it would save a lot of time.
1 vote -
Link to alert within Teams notification
I would like to see a direct link to redgate monitor alert within the teams notification. At the moment I have to search for the alert in the WebUI manually instead of clicking a direct link like it is in a mail notification with "View full alert details" button.
2 votes -
Be able to see and dissect alerts for deadlocks on the AWS RDS platform.
Currently, SQL Monitor does not raise deadlock alerts for AWS RDS database instances. I'd like this functionality to be added, as it's a major feature and selling point for the product.
The current workaround we're using is a combination of AWS performance insights and a SQL script. A "single pane of glass" would be much more efficient.
1 vote -
Allow custom metrics to be optionally created as "event" alerts rather than default "continuous" alerts.
I have installed the "Used/available database space increased alert" which alerts when defined thresholds of used space have been exceeded. However, once activated, the alert remains in an active state with no additional notifications (easily missed). I'd prefer to have this metric run daily and notify each time a threshold is exceeded.
20 votes -
create user permissions script
provide the sql to run for users to use during install to assign permissions to the back end database use and the monitored db use
obviously explain about the SysAdmin problem with your product
https://forum.red-gate.com/discussion/80787/required-permissions-changed-after-upgrade
https://forum.red-gate.com/discussion/80448/new-permissions-needed-for-monitoring
https://documentation.red-gate.com/display/SM7/Permissions7 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
6 votes -
Improvements to Alert Notifications when you have multiple alert thresholds
You can configure alerts in Regdate Monitor to have different thresholds (low, medium, high). The problem is that all notifications have to go to the same email address(es).
We'd suggest an improvement to allow diffent notification methods for each level. For examples, send low alerts go to one email address and medium/high go to a different email address.
This would allow us to send the more critical alerts via OpsGenie/Jira.
3 votes -
flexible disk configuration
Currently the configuration for disk space monitoring in “RedGate Monitor” only gives the option to check on the number of bytes that is still free on the disk (in GB or MB).
Ideally one should check on the number of bytes in combination with the % free space.
The reason for this is that percentage hugely differs depending on the total size of the disk. On a small disk one would like to extend the disk when it is 80% FULL, where as on a much bigger disk, 20% space might still be many GB’s and to early…4 votes -
Command Line Install
I'd like command line installation to be an available option for SQL Monitor as I want to automate and script it, rather than having to do it manually
1 vote -
Check both full and differential backups for the overdue alert
As it is, the backup overdue alert will not check if a differential backup has been run.
Example: We have a database with simple recovery model that is set up to make a FULL backup every week, and a differential backup every day. If the alert level is set to "more than one day" then it will be triggered even though the diff backup has been run, indicating that it is not overdue.
We could set (and do that) the alert level to check only for "more than 7 days", but then we will not be notified if a diff…
26 votesThank you for this suggestion, and apologies for not updating sooner.
We believe this was solved when the Differential Backup Overdue alert was added in Version 8.0.7 (May 2018) . This alert is raised when entries for a differential or full backup in the [msdb].[dbo].[backupset] system table are older than the time you specify.
We will mark this as completed but please do let us know if you have any further feedback.
Thanks,
The SQL Monitor Development Team -
Record queries terminated by the client
We use an ADO client with a query timeout of 30s by default.
These queries are not being captured by SQL Monitor. If they were, it might highlight the cause of why they are taking so long.
For context, we have a query that regularly takes a couple of seconds to execute, but every hour or so exceeds the 30s timeout and we would really benefit from SQL Monitor to capture those to help diagnose why.
1 vote -
Limit the number of backup entries listed for Estate Backup details
When viewing the backup details of a database in the Estate Backup view, the number of backups listed severly impact the usability. It seem to retrieve all backups done and stored in the SQL monitor DB or in msdb. As we have frequent log backups, this list is very long and heavy to retrieve and display.
1 vote -
Long-running query alert - add an option to exclude queries based on the USER running it
This alert already has the options to exclude queries (via RegEx) based on the process name or SQL commands/objects used. I miss a similar option for excluding queries based on the user running the query.
An example: let's say you have a job that runs SSIS job steps using a proxy->credential->dedicated domain user. The SSIS packages run loads of SQL queries, some taking a long time - but that might be expected and OK (let's say the job is a nightly ETL process for a DW). Without excluding queries based on that user (simple but effective!) you could get a…
64 votesThis was added in version 10.1.2 – you’ll see the option in the Long Running Query alert configuration screen if you update to that version or later. Thanks for the suggestion (and also to everyone who added comments)!
- Don't see your idea?