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
741 results found
-
Recognize Low Alerts visually in overview
Low Alerts show as blue dots on the Latest Alerts panel, but in the overview they show Green like Healthy.
Especially when showing Small Tiles (we monitor 60+ instances) they do not stand out from Healty ones (see the attached examples).For that reason I dont use many Low Alerts.
It would be more consistent to use blue in the overviews also.4 votes -
Database File Usage Alert - Autogrowth
Database File Usage Alert : Please consider autogrowth! So far, this alert is of no help.
3 votesSQL Monitor v7.1.18 added an option to disable database file usage alerts when autogrowth is enabled. The setting can be found on the configuration screen for the database file usage alert.
Thanks for helping us improve this feature with your suggestion.
SQL Monitor Development Team
-
Have the RG tempdb table indexed
The RGAllObjectsv4 table in tempdb currently accounts for 7 of the top 20 missing index suggestions on our production server via the built-in report in SSMS. Can this be indexed by RG so that the indexes will be reapplied when the server or service is restarted? I've attached the list of suggestions.
2 votes -
Group alerts into a hierarchy
I want to be able to group alerts into a hierarchy so that for instance when a server goes offline, all of the other alerts generated such as instance unavailable are not generated.
3 votes -
Setting Maintenance Window via API service
That would be very nice if there as an API service which we would use to set maintenance window for a given sql host or a group of hosts.
7 votesThanks for this suggestion. SQL Monitor 10 now allows teams to suppress alerts, or just their notifications, over certain periods using alert suppression windows. Windows can be set-up using SQL Monitor, or via the API. Please see the example Scripts within Configuration for more details.
We hope this meets requirements and will mark it as completed. Please raise further suggestions for any improvements you would like to see.
Thanks,
SQL Monitor product team
-
Analysis graph exclude set times over long time range such as 28 days
It would be great to be able to set exclusion times such as the "maintenance windows" when index maintenance activities take place such as every day between 12pm-2am in our case. During these times disk queue length will be predictably high due to the maintenance activities taking place.
When viewing graph analysis for a 28 day period for disk queue length you see peaks which are from the maintenance activities and these events end up skewing the overview of BAU activity.
It would be great to be able to define an "exclusion time window" in the analysis report window…14 votes -
Long Running Open SSMS Transaction
Would be really helpful to have an alert that can alert on long running open SSMS transaction and the alert can return the user running it and query being run and on what server we often see it when users forget to commit or role back there transaction.
4 votes -
Another Field to Change the Display Order of Servers on the Dashboard
On the dashboard, server instances are currently ordered by two fields - Name or Severity which is selected via a drop down list. Can we have another field - Sort ID (int), to give users another way to sort? This field can either be hidden or displayed.
1 voteHi Dean,
This is currently possible by setting an alias for an instance (hover over the righthand corner for a card, click the menu icon and select ‘Alias…’).For example you might set:
1_AliasA
2_AliasBSelecting ‘Order by Name’ in the drop down will then allow you to use this ordering within a group on the dashboard.
Alternatively you can pin instances to the top of the dashboard (hover over the righthand corner for a card, click the menu and select ‘Pin to top’).
I hope that helps.
Neil Turner
SQL Monitor design lead -
Have option to keep the base instance name in display for availability groups
We have the option to choose between Windows cluster name and FCI network name for FCI. However, in an Availability Group scenario, every instance is being show by the cluster name first, which is obviously the same for all of them. This makes it difficult to identify the correct one when you need to look at a specific instance. Would like to add this as a configuration option so that clustered AG servers we can also choose whether to use cluster name or instance name as display
6 votes -
Restrict the read only role to only the "Overview" page.
I've explored using Read Only views for SQL Monitor and they work great, while really parring down the amount of information that the user can see. However, is there are way to lock it down even further so that they can only see the homescreen with the colored status on the specified SQL Instances? Essentially only allowing them to see status without drilling down into the instance itself and viewing waits, disk, CPU etc.
This could be used by management, etc.
5 votes -
Please remove the 20 character size limitation from the Alias feature
Given that actual server named instances can be longer than 20 characters (even if they are truncated on the display), it makes no sense to limit an alias to 20 characters. Please significantly extend this limitation.
3 votes -
In the email alert for custom notifications I would like to execute an ad-hoc query that shows me the results.
This will allow me to write a custom metric alert and see the results of the alert inside the email alert. Example where I monitor one log file with various items the custom alert message can give me context on what errors are written to the log inside of the email
3 votes -
Be able to send the SQL Audit data to a SIEM tool
The existing SQL Audit information in Redgate Monitor is an invaluable amount of security information which can be useful for Security professionals who use a SIEM tool such as SentinelOne. Currently Redgate Monitor allows us to export. It would be great to see this as a feature.
1 vote -
deadlock
Add the ability to customize deadlock alerts. I want to able to ignore alerts if the deadlock was on table XXXXX or produced by stored procedure YYYYYY
or have different alert levels depending on the database and table.45 votesThanks for this suggestion. We will close this now as there have been no new comments since we released the new filters.
However, please do raise new suggestions for anything you feel hasn’t been addressed, so we are able to consider them as we continue to improve SQL Monitor.
Thanks,
SQL Monitor Development Team -
Move machine between Groups using Powershell
This is possible with the UI, however this does not work for a Machine.
$base = Get-RedgateMonitorBaseMonitor | Where-Object { $_.Name -match '2112' }
$inst = Get-RedgateMonitorMonitoredObject -BaseMonitor $base -Type Machine -Name "devsql0001"
$group = Get-RedgateMonitorGroup -Path 'TestGroup' -BaseMonitor $base$instance.Group = $group
$instance | Update-RedgateMonitorMonitoredObject
HandleApiError : The remote server returned an error: (405) Method Not Allowed.
At C:\ps1\RedgateMonitor\RedgateMonitor.psm1:6008 char:9
+ HandleApiError -ErrorRecord $_ -URL $Uri -Method $Method
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Write-Error], WebException
+ FullyQualifiedErrorId : WebCmdletWebResponseException,HandleApiError6 votes -
Allow configuration of Fragmentation Alerts down to Table for EXCLUSIONS
The Fragmentation Alert for a database only permits on/off and low/medium/high with page count configurations.
This is far, far too high a level to be useful.
The Alert needs, at the very least, INCLUSION and EXCLUSION capabilities by table within database. An overall fragmentation low/medium/high and pages would be OK to START WITH, but It would be great to be able to go to each index and state the fragmentation limits and even whether to monitor it.
In my case, I use Idera's excellent Defrag Manager, so when I see this alert, I check that Defrag Manager is doing its…
5 votes -
It would be grand if I could change the time format.. 12 hour clocks just don't sit right with me.
It would be grand if I could change the time format.. 12 hour clocks just don't sit right with me.
35 votesWe have just released version 6.0.7 and this update means the clock can now be displayed in either 12 or 24 hour format – this can be toggled at Configuration > Display settings.
Thanks for your patience.
SQL Monitor Development Team
-
kill sql spids
in other monitoring tools (Idera) i can see active sql connections and they are doing. i also have a option to kill the process if i decide. dose your product have this ability
37 votes -
Allow extended email addresses "xxx<myemail@yyy.com>" or custom prefixes for subject line
I send my alerts to a tech-staff group and would like to add specific text for end users to filter all SQL monitor emails against. Either allowing extended email address like "xxxmyemail@yyy.com"
or some global prefix that can be added to subject (or body for that matter). Right now I don't see any reference to redgate or sql monitor to distinguish it from other monitoring email I receive.1 vote -
Analytics Dashboard Selection Parameters
On the Analysis Dashboard there are lots and lots of Metrics. Not all of them are Availbale for ervery RDBMS. It would be good to have switches to narrow down the Metrics to SQL-Server or Postgres Parameters, e.g. if you swich on Postgres only Metrics for Postgres Servers are shown.
3 votes
- Don't see your idea?