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
733 results found
-
Estate Page - Disk Usage - Show Actual with Allocated
There's plenty of real-estate to include a column for database file rows that shows the true "USED" space, not the Allocated space.
Right now, SQM is predicting data drive exhaustion at 16 days hence:
Fake "Used": 5,634.5 GB Capacity: 5,959.4 GB Fake "% Used": 95% Time until full: in 16 daysSadly, Untrue, from a "Used" perspective - only true from an Allocated perspective!
When I drill into that drive, THIS is the truth:
Used: 4,752.6 GB Capacity: 5,611.7 GBPlease promote this "USED" as a higher-level total, and use it as a projection - i.e., retain a history of…
4 votes -
Produce a long running queries report ordered by average execution time
I have been tasked with identifying queries with the longest average execution time so that they can be targeted for optimization. In the server overview this can be done in the top queries section, however this obviously only shows queries for that instance.
In the reporting tab I can create a report for long running queries, but it is based around total execution time. It would be useful if this could be ordered by average execution time.
A query that runs 100,000 times and takes 10ms will have a higher overall execution time than one that runs 50 times and…
1 vote -
Every alert should be able to be cleared
I recently ran into an issue where a specific alert ("Monitoring error") could not be cleared. Support staff told me this is by design.
I thnik this is bad design. Every alert, no matter how serious, no matter how breaking, should be clearable.
Whatever the issue is, once I am aware it is up to me to decide whether I want to continue to be alerted or not. If I know I'll fix it later, or I know I won't (or can't, as was the case for me) fix it, then I want to clear it.
By not…3 votesHi Hugo,
I’m sorry to hear that you’ve experienced issues with this. There is a setting within ‘Configuration > Display settings’ (see screenshot) to not force errored instances to display red on global overview.
It sounds like this is the issue that you’ve experienced. If you activate this setting then monitoring errors will not behave in this way on the Global dashboard.
Neil Turner
(Lead designer – SQL Monitor) -
Wider parameters for reports
Incorporate ability to run reports for a group of monitored servers for a longer duration. For example: Report of unreachable status on 12 different servers for the past year.
1 vote -
PaaS dbs on an instance appear seperately
Hi Redgate Support,
While adding PaaS SQL servers, each database appears individually. Will this change in near future where they appear together with other database on the instance like they do on-prem and on IaaS.1 vote -
Analysis: allow disconnecting y-axis from 0
The base of the analysis chart is always, always 0.This is okay when looking at small scale metrics (e.g. user connections), but for large scale metrics (e.g. file size) the proportions become so large that any change is imperceptible. Good luck detecting that your 2 TB database is growing by a GB/day. I don't need to see that it wasn't 512, 1024, 1536, or 2048 GB.
It would be nice to have the option to disconnect the y-axis from 0. Ideally it would automatically scale to the range of the data in the window, with a little margin around it.
2 votes -
Report Email Attachment Name
Name the pdf attachment something other than "AttachedReport".
The report has a title and a date which could be used to name the attachment. That would really simplify the process of saving the reports for baseline purposes.
e.g. "Server2ProcessUtilization20180308.pdf"3 votesReleased in SQL Monitor v13.0.5.
-
User Defined Analysis Templates
Wouldn't it be nice to have the option of saving a view of multiple counters under Analysis?
4 votes -
1 vote
-
If a job fails the alert should not be cleared until the job has run successfully again
If a job fails the alert should not be cleared until the job has run successfully again. It doesn't make sense clearing the alert just because a job has been restarted. The alert should remain active until a completely successful run.
4 votesThis has been changed and now works as described here. In SQL Monitor since 11.2.13 (released 26 Sep 2021).
-
add the ability to specify a default filter. I'm getting tired of having to re-select my custom filter each time I click on the Alerts tab.
When working through a huge list of alerts, if I don't remember to click on the "back" button I am forced to re-select my custom filter from the Filter dropdown list.
If would save some time if a custom filter could be specified as the default Alerts filter.
4 votesIn v3.1 the filters now persist on the Alert inbox until they are manually cleared, so you can navigate away and always return to the filtered alerts without having to reselect the filter from the dropdown list.
We hope this fixes the root of the problem that your workaround was a suggestion for. We’re interested to hear your feedback on this feature so please let us know at usability@red-gate.com. Thanks again for the suggestion and comments.
-
Show Estate Groups in the "For" Dropdowns in Reports
In the Reports section, there is a "For" dropdown that allows you to select specific instances or "Everything". It would be helpful to be able to select a Groups of instances on the report or individual tiles within the report. These groups are setup in Configuration > Estate > Groups.
For example, you could group your servers into Production/Staging/Dev, then you'd be able to setup a report that only shows Production metrics/issues.
3 votes -
Ignore Negative Custom Metric Collection
I am trying to add a custom metric based on the sys.dmosperformance_counters DMV. These are very useful for gaining Instance Level information. These counters increment as each lock is requested. I have used the “Use a calculated rate of change between collections” option which accurately depicts the graph I am trying to accomplish. The caveat is that these counters are reset to 0 when the instance is restarted. Therefore in any of my graphs, I get this huge negative value. This basically renders the metric useless because I cannot visualize any metrics once a server is rebooted.
Is…
1 vote -
Avg. lock wait time alert
Be able to have the Avg. lock wait time metric as a configurable alert.
this metric is already available in the analysis tab, but we can't define alert on it.
Avg. lock wait time
The average wait time (in milliseconds) for each lock that could not be satisfied immediately and had to wait for resources.Equivalent PerfMon counter: SQLServer:Locks - Average Wait Time (ms)
4 votes -
Add date to legend when filtering across multiple days
When we filter on the top graph across multiple days, on the legend below won't show the days, just the time.
The image is the current case.
What I would like is to have the days.
Instead of "from 08:18 to 08:19"
expected "from 18 Jun 08:18 to 19 Jun 08:19" or equivalent4 votes -
In the Global Overview screen, have a filter selection for Still Active Alerts
Once an Alert has been cleared or ended I no longer want to see it on my Global Overview screen. When I am handling lots of servers and I see lots of RED on the alert side but they have either been cleared (checked) or ended I no longer want them showing up on the global screen unless I want them too to review. This causes lots of questions from management when they walk by and see lots of RED and the Alert was handled or no longer a concern.
3 votes -
Job Duration Unusual: ability to set different thresholds for different jobs
Some jobs that take a few minutes, others routinely take a longer time to run, and so it would be useful to set different thresholds for different jobs.
The current set up allows for excluding jobs from the alert, but offers no way of still monitoring those jobs.
I only want to exclude the jobs from monitoring, only if its possible to add in another alert just for them.
The documentation seems to hint that you can configure different alerts for different jobs, but all I've found is the high medium low thresholds, and this isn't the same.
…
2 votes -
configure notifications 'per alert per object' rather than just 'per alert'
Right now we have a large number of SQL Servers across different environments such as dev, QA, production, etc. In a similar way to having multiple notification channels configured on an alert (another suggestion covers that), I'd like to be able to configure the alert notifications differently for each level that the alert is set at ... I'm away from work right now, but I think that although you can set the thresholds and filters at each group level, you cannot change the notification settings (eg, do NOT trigger SNMP alert for non-production environments). if I'm right about that,…
3 votes -
Allow use of non-administrative shares
Instance-level monitoring requires the use of the default administrative shares, which are likely to be disabled on hardened production servers.
Allowing the use of user-specified shares on a per instance basis would provide a means of getting around this restriction.
1 votesorry, can’t do – Microsoft’s APIs are too flakey
-
Add Active/Ended as SELECT drop-down options for Events
The current Alerts page Select drop-down has None/All/Read/Unread
For events, such as Disk Space, being able to Select "Ended" to get rid of the noise, helps focus on what needs to be addressed.
If the list doesn't have any Event-type row, don't offer this pair of options.
3 votesWe’ll look into this. In the meantime you can set-up a custom filter for Active or Ended events and use the ‘Select All’ to select these rows.
- Don't see your idea?