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.
710 results found
-
Monitor Disk Overallocation
Recently we ran into disk space issues on a server. Looking into that, it was discovered that a 10TB database had 3TB in "Unused" space. That is the space was allocated to a table, but the table needed to be reorganized to recover the space. sp_spaceused shows this space, and a disk report of top tables clearly showed the Unused space. This was not something that Redgate noticed. Going back over our estate, we discovered there were more such databases where we could recover space. This could also be noted at an individual file level. Reorganizing that one database has…
2 votes -
Email queuing
Basically, I would like email to queue up in SQL Monitor. In the event an email fails to send (account locked out, mail server down, etc), having the email just fail to send is not the desired result. When problems are resolved, the email should send.
For example, lets say IT is doing scheduled maintenance on the email server and during that window one of the SQL instances shuts itself down due to an error (for arguments sake, lets say out of disk). SQL Monitor will see it go offline and try to send out the alert but fail because…7 votes -
see an administrative web-based log viewer
Having the ability to review logs in a web-based interface is useful for administrators of a tool so we can diagnose and remedy some problems without needing to reach out to support. The downside is the log needs to be filterable or multiple log files need to exist.
An example of a log that would be useful would be an email log. In the event an email fails to send, I'd like to know why without needing to download the entire log in a zip, extract the zip locally, and browse through it when I am looking for a specific…2 votes -
A way to showcase all SQL Statements running for a specific time frame
A way to showcase all SQL Statements running for a specific time frame. This is will be helpful to investigate any issue that occurred in the past.
5 votes -
Suspend Monitoring of Individual Cluster Nodes
Alert suppression windows can be applied to groups, clusters, instances, and machines - including individual cluster nodes. Howerer it seems it is only possible to suspend monitoring for instnaces or clusters not individual nodes,
We recently had a hardware fault and it would have been helpful to suspned monitoring of a specific node whislt the engineer resolved the fault.
6 votes -
Long-running query Alert - time based parameters
I need to disable monitoring long running queries at night.
My proposal is that you could add new parameter to alerts
Time from - Time to which will exclude monitoring during this time.That will help to exclude ETL - ssis, and other long rununig queries which we set up at night.
6 votes -
Add User Settings feature
Add a User Settings feature that will hold all user preferences, as different DBAs / users have different ways in using SQL Monitor. For example - (1) ability to display on the Overviews page only desired health levels (Critical, Warning, etc), or named group, or base monitor, or any combination, rather than load all servers from all groups from all base monitors. I really don't want to know that I have 265 healthy out of 275 servers - this will speed up loading of the Overviews page. (2) any other user preference.
4 votes -
Be able to schedule a maintenance window with the possibility to use an offset.
Be able to schedule a maintenance window with the possibility to use an offset. Say every 3rd tuesday of the month + 12 days.
5 votes -
Top 50 Queries should ignore queries that runs with explicit "waitfor"
The query that runs with explicit "waitfor" should not be included in the top 50 query report.
7 votes -
Service Level Agreement Metric Report
The following contract metrics are common to many US Government clients. It would be very helpful (and a real time-saver) if SQL Monitor had report that could provide the below listed SLA's in a monthly email to an editable distribution. The report should be .pdf or .xlsx format, with layout intended to communicate to executive audiences. The setup for the report should allow comparing baseline dates. Thanks in advance for considering this idea.
- List of database instances
- Database uptime
- Components that are reaching capacity
- Computer resources growth
- Reserve capacity
- Throughput I/O
23 votes -
Control the delay before getting "Error on Base Monitor"
We have perhaps a unique use case where one of our Base Monitors is at a remote site with a very high latency (700+ ms). Monitoring works surprisingly well since one of the later updates but unfortunately we are getting regular “Error on Base Monitor” emails (10+ per day) even though the connection itself is stable (just very slow).
We would like to be able to control the delay before that error is raised, I’m guessing that slightly increasing this "timeout" would fix all our issues.3 votes -
Add counter [forwarded_record_count] to Analysis page
As you describe in this article: https://www.red-gate.com/simple-talk/sql/database-administration/sql-server-heaps-and-their-fragmentation/
forwarded-record-count From sys.dm-db-index-physical-stats
Please add forwarded-record-count to Analysis page
Thanks guys!
14 votes -
Detailed Memory usage breakdown
I would like to see a breakdown of memory usage. For example, how much memory is used by the plan cache, how much for the buffer pool, etc.
Also, a breakdown of memory usage per database.8 votes -
list, and get alerts from the SQL Monitor API.
Add possibility to list, and get alerts from the SQL Monitor API.
This so we more easily can share and distribute alerts to a users that shouldn't have access to SQL Monitor.
In my org we have a lot of developers, and a lot of different databases that are hosted on the same clusters, I want the possibility to send more direct alerts and messages to these users.
42 votes -
Please add granular details on memory and processor usage
Please add granular details on memory and processor usage to display resources used by each individual process
2 votes -
Display maintenance windows on timeline
When looking at the timeline graph with the CPU/IO/Waits stats it would be very nice to see the maintenance windows, for example as a difference background color.
This would help immediately recognize why IO is spiking for example. I realize that can also be accomplished with the Baseline for regular maintenance but I don't see it as mutually exclusive since a maintenance window can be configured at any time.3 votes -
Availability Group alert details
It would be great to see the server name in the mail body which is affected by the alert. Currently it is only in the subject. EG: Raised on detail i the mail body contains the primary replica, the affected unreachable replica is only in the subject.
1 vote -
Report that shows top 50 long running queries across the estate
Submitting an enhancement request to expand the reporting capabilities for long running across the entire estate. The report tile only show a handful. It would be very useful to be able to run a report listing the top 25, 50, etc long running queries across the entire SQL estate. The data is available somewhere but instead of going into each instance a consolidated report would be greatly beneficial is order to identify queries for performance review. We are also going through an upgrade and are identifying queries to benchmark for before and after performance to ensure there is no degradation.
4 votes -
Have a parameter for status/severity colour
when using slack notifications messages are automatically coloured red/green for failed, ended.
Like a lot of companies we're migrating to Microsoft Teams and whilst we can use the Webhook stuff to reproduce most of the slack alert for Teams we're not able to colour code the alert based on status. Having a new parameter for status-colour and severity-colour would really allow us to clean this up.
2 votes -
Have a custom message added to alerts
When an alert is emailed, I want to place an action (possibly including an html link) as a comment on the alert.
This would allow the recipient of the alert to solve the issue directly.
6 votes
- Don't see your idea?