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
756 results found
-
Estate Licensing - Align with Microsoft HA/DR Licensing policy
Estate licensing appears to tally all licenses for servers in an WFC/HA config. 3 node cluster 4 cores, 12 licenses (when it should be 8). Please provide the process to identify an HA or DR node, which will allow the Redgate Estate portal to align with Microsoft SQL Licensing: https://download.microsoft.com/download/e/2/9/e29a9331-965d-4faa-bd2e-7c1db7cd8348/SQL_Server_2019_Licensing_guide.pdf.
3 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 -
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 -
Pass tags through the webhook json
I would like something like {{Target-tag}} to pass through the webhook, this will allow us to better spilt the alerts to the correct team on the other side so that 1 team isn't having to get all the alerts, but using other integrations and wrokflows with something like a tag we can spilt the alerts to different teams based on target and severity, but also with shared servers the tags will allow us to spilt those alerts as well.
3 votes -
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 -
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.
-
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 -
User Defined Analysis Templates
Wouldn't it be nice to have the option of saving a view of multiple counters under Analysis?
4 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 -
1 vote
-
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 -
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.
-
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 -
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).
-
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 -
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 -
Exclude queries from Blocking Alerts based on the blocked process rather than the blocking process
I want to be able to "mute" blocked process alerts based on information about the process being blocked rather than the process doing the blocking.
Currently, we can exclude queries based on the process name, query text, login name, database name of the blocking process, however the same level of exclusion cannot be made for the blocking process
I want to be able to exclude blocking alerts where the query being blocked is an Intellisense query. These could be identified by the process name but currently that only applies to the process doing the blocking
I think this probably should…
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
- Don't see your idea?