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.
686 results found
-
In SQL Monitor, I want to use a variable description in a custom alert.
Some custom metrics could be about things like a specific disk, job or DB-object. At this moment it's not possible to specify those in a generic Alert.
If besides the metric value a descriptive value was allowed, it would be possible to parse the descriptive value into the Alert.3 votes -
Overlay Alerts on the Analysis page
Please add overlay alerts and annotations on the Analysis page. This would simplify the analysis and finding correlations.
16 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 -
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 -
Trigger a device check-in via powershell
We use powershell scripts to shut down and start SQL services before and after maintenance. The scripts create a suppression window before and after as well. However, if the suppression window is removed too soon after the services are up, alerts are still fired because SQL Monitor thinks the server is still down. We workaround this by adding a delay in the scripts, but it's annoying to sit and wait for it. I'd like to be able to force SQL Monitor to check in with the server before removing the alert suppression window.
3 votes -
Show/Hide metrics on Analysis page
Please add an option to show/hide selected metrics on the Analysis page. Something similar to the Reports graph would do.
13 votes -
Monitor SSRS
Monitor Reporting services
3 votes -
Monitor Azure SQL Read Scale-out Database
I would like to monitor the Read Scale-out Azure SQL DB that gets created when on Business Critical tier.
We are moving our Read queries to this database using "ApplicationIntent=ReadOnly" specified in the connection string. SQL Monitor allows to configure the primary for monitoring but provides no options to add a connection string when adding a server so am unable to add the secondary read-only DB for monitoring.26 votes -
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 -
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 -
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 -
Automatic validation of regex for Long-running query configuration
When applying regex filters for long-running queries, a malformed expressions causes the page to just drop the error and not take the save action.
My suggestion is to just implement a basic regex validation and prompt/indication on error.2 votes -
Clear Select Alerts from Dashboard when ended
I'd like the ability to close alerts from the Latest Alert board if they are ended. A checkbox in Alert Configuration to self-close alerts once Ended would be good to have
Eg: I have certain 5-minute jobs that fail once a day if their corresponding run completes I'd like the Alert to clear itself.I can configure the Alert Ended to send email notification stating its ended but it still stays active on the Alerts list in SQL Monitor.
10 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 -
Under Estate section: display last date/time server and/or instances on each server were restarted
I want to know what SQL Server Services are running/stopped on each server and be able to alerted if said servers are stopped.
11 votes -
Disable specific alert for some time
Make it possible to ignore a specific alert for a specific server for x amount of time. Sometimes there is something going on for say half a day and you do not want to miss out on other errors but just that specific one.
2 votes -
FCI alerts should refer to the DB instance and not to the active node
For various alerts that are actually assigned to nodes of a Windows FailOver cluster (no AlwaysOn), the alert display shows the active nodes as the source. For example, "Disk average read time" Node1 -> E: instead of the cluster role SQL instance -> E:.
I can more quickly deduce from the name of the DB instance which DBs or which applications could be affected. The names of the nodes are numbered and meaningless.
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
- Don't see your idea?