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
-
Allow maximum number of email notifications in a 24-hour period alert to be sent to another email address
Currently if too many alerts for a particular object are received an alert email is sent noting that no more emails will be sent. I want to be able to specify that email is sent to a different address than the default.
For example, we may get a large number of deadlocks. after the first 150 the alert emails are silenced. We configure deadlock alerts go to our normal email address because generally they aren't urgent, however when 150 or more are received there is a definite problem that needs to be reviewed. That should go to our pager email…
9 votes -
FORCE "Estate" refresh re Actual Disk Space
Just freed-up 55GB on tempdb drive. F5 on the Estate page, Disk Usage tab, and SQM still says 11GB. Clearly WRONG!
Give us the ability for FORCE a disk usage re-calc.
9 votes -
Integrate with Policy Based Management
It would be really good to integrate with Policy Based Management to raise status alerts in SQL Monitor, that way we could breakout more complex Instance status
9 votes -
show client host name for queries in top SQL
In the TOP SQL, I see login and program name, but not client host name. It would be helpful to see the client host name, too.
9 votes -
Add the ability to report/analyize Index fragmentation
I would love to see the ability to see the Index Fragmention results in the report/anayize feature. I have been fighting index fragmention but cant really tell how much it has improved.
9 votes -
Add filtering to the Top 10 Queries/Waits lists
So first, this is a request for more general filtering than the 2 requests I see already exist for filtering by database (which I believe you can get to by clicking the database name further down the page, but would certainly be more convenient on the top 10 lists directly).
The primary use case that I was looking to do but couldn't was sort by averages, but set a minimum execution count. The goal being to find my worst queries that are not just one off things that aren't likely to be repeated. I think there would be a LOT…
9 votes -
We would like to send slack messages to different channels depending on the server.
We have multiple teams who are ultimately interested in what is wrong with their platform, The posting to a single slack channel is good, however giving an option to send only messages from certain servers to specific channels would improve our customer engagement. currently the main channel is ignored by the all teams except the dba's as the chaff from other servers can cause disinterest, or interest when no reason for a team to investigate.
9 votes -
In the backup check would like it if we could select the times of the backup to then show that group
in the Estate > backup page you are able to see issues such as RPO 1 week. it would be good to be able to click on this to then show the backups listed (fade the not appropriate backups).
9 votes -
Report to identify alert overrides
We are using the alert categories "Host machine alerts", "Instance Alerts", "SQL Server alerts", and "Availability Group alerts" for our SQL Server environment. We have defined general thresholds for the alerts w/in each category. We then have situations where we override the alerts for a monitored object in an alert subgroup or the monitored object itself because the general alert threshold(s) don't make sense for the sub group or the object. It would be very useful to have a report which shows where we have performed these alert overrides. A report showing where an alert is overriden or a report…
9 votes -
Alert "regarding "instance alerts" - Cluster failover - for Postgres"
for Alert "regarding "instance alerts" - Cluster failover - for Postgres", would like to have it available on the individual server level and not just the monitoring group. That way we can customize our notification accordingly.
9 votes -
Set default Redgate Monitor time zone
My Redgate Monitor server is on a server with the time zone set to UTC. When I open a Redgate Monitor on that server I get all the times in UTC, which is great.
When I open a Redgate Monitor on my local computer, the GUI shows the times adjusted for my timezone.
Since my team is monitoring from different locations in different time zones, we get different times depending on the timezone.
I would like an option in Redgate Monitor configuration to easily set a default time zone so all the users can see the same time zone.
9 votes -
Alerts should configurable to repeat until an issue is resolved
We'd like the option for alerts to repeat until an issue is resolved. For instance, we may have a custom alert to tell us when a DBCC CheckDB hasn't been performed in >24hrs. For that we'd perform the check once per day and expect to get an alert every day that the problem continues. Without the alert recurring it's very easy for it to slip through the cracks and get missed.
Another example is blocking. We have some databases where we monitor blocking via SQL Agent and when a block occurrs for 1m or more, we send emails every 30s…
9 votes -
Have a standard metric for Data space used
There is currently an out of the box metric or Log Space Used, but there isn't an equivalent Data Space Used.
I get that it's a bit trickier if you have multiple data files, (even just adding them up as one metric). We have databases that we want to pro-actively allocate space for but it's hard to do without a metric to tell us when it's getting full.
8 votes -
Configurable Thresholds Based on Time
The alerts would be more useful if we could apply maintenance or quiet periods to them.
I understand we have the maintenance window and that is perfect for things like planned downtime, index maintenance etc.
Regards,
CliveHowever, the issue I currently face is that I suppress the processor under utilised message. Like a prolonged spike in CPU activity, a massive drop off could be a concern too. However, I have a current mean of 18.6% on one example server. I can set a threshold of 15% as an example, but this would trigger alerts through the night when typically…
8 votes -
Include Custom SQL Code in alerts
When creating custom alerts, I would like to be able to include information that can be retrieved by running a SQL query.
One example is using the pre-built Failed SQL login custom alert that is available to setup. The alert notifies when this event occurs, but it fails to include information like which login failed, etc.
It would be nice to be able to build part of the e-mail body in the alert to include some critical data that can be queries using T-SQL.
8 votes -
Select what alerts i want to receive by Slack, the same way it happens by Email
Slack messages are a little annoying when all the alerts are sent by them.
I would like to configure the alerts i want to receive on slack. Today this is possible to configure in the e-mail option.8 votes -
Improve alert troubleshooting by showing sql server error log
When viewing an alert it may be helpful to see the error log for the server for the surrounding time. RAISERROR can log to the error log, so this info could be useful to see.
8 votes -
Job execution in overview graphs
It would be nice if you in the Overview graphs could see SQL Agent Jobs, just like long running queries, deadlocks etc.
It could be good for troubleshooting high disk IO, CPU etc, if you could see that a job has started running at a point.I've tried to illustrate my idea in the attached file.
8 votes -
be able to show basic SSIS monitoring graphs/sparklines on the overview page (Buffers spooled, Buffers in memory, rows read,...).
There is currently no SSIS monitoring in SQL Monitor. You can add custom metrics for performance counters available through SSISDB but these can only be seen on the Analysis page and only after you have selected all of them.
It would be nice to be able to select SSIS as an option for a server and then see these counters as graphs/sparklines on the overview page.
8 votes -
Comments in alerts list
Show the comments or at least the first 50 symbols of a comments in the Alerts list.
8 votes
- Don't see your idea?