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
741 results found
-
Add additional metrics for Latency, Failover, queries categories for MongoDB
• Replicaset metrics around latency and failovers…etc. Like SQL Server.
• Something to track queries performing large scans vs seeks.
• Would be nice if the alerts (even if duplicated were broken out by platform. They are shown by SQL which I get is your primary offering, but just saying also postgressql vs seeing its PostgressSQL on Linux or MongoDB on Linux and change the alert offering to reflect those in a separate grouping like SQL.
4 votes -
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
-
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 -
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 -
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 -
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 -
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 -
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 -
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 -
increase or decrease the fill factor
Dear team.
I see some explanation on the sql Monitor live Demo tool which seems incorrect:
Check also: The fill factor percentage of the tables in your indexes. If enough space for index expansion is available on data pages, the potential for page splits is reduced. The default fill factor value setting is 0 (100%), which means that pages are filled to capacity. If you increase the fill factor, additional free space is left in the indexes after they are rebuilt or reorganized, helping to prevent excessive page splitting
increase should be decrease: the higher the fill factor the less…
4 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 -
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 -
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 -
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 -
comment markdown
CONTEXT: I use comments on alerts raised by SQL Monitor to document root cause of the triggered condition and resolution action.
PROBLEM: Comments only support plain-text. When creating/reviewing comments, it's often useful to add links for more detailed descriptions of the cause of the alerts, and links to ticketing systems for resolution steps. Simplified bulleting/numbering and bold/italicized text would also be helpful for breaking up monotonous text.
EXAMPLE SOLUTIONS: Add Markdown (http://daringfireball.net/projects/markdown/) support to addition/review of comments. A couple implementations for examples of usage:
- StackOverflow (http://stackoverflow.com/editing-help)
- GitHub (https://help.github.com/articles/github-flavored-markdown/)
4 votes -
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 -
Share alerts via Email
The ability to share alerts details via Email from the "Alert Details" page.
Sometimes we don't want to share a direct link to the monitor.
E.G
Click "share" which will open a mailto: with the relevant alert details.1 vote -
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 -
Access custom metrics via the Enterprise API
We need to visualize metrics on central dashboards - the Enterprise API is PERFECT for that - except it currently does not support access to custom metrics.
Custom metrics are one of the most powerful things Redgate Monitor has - we really need the ability to access ALL of our information outside of the Redgate tool itself.
2 votes
- Don't see your idea?