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
-
Change Processor Utilization per instance
Currently i have 4 instances which are part of an availability group and run maintenance as various times. although different maintenance windows would be nice to have the flexibility of changing Processor Utilization per instance rather than per cluster.
6 votes -
Display on TV screen
Hi, We run Yodeck boxes to display content on TV's
This has a scripting function to pass some logon details
It would be good if I could have a read only view of the server dashboard or help identify the submit button to script it
Ive tried - Only the password is enteredtype("""#password""","""MYPASSWORD""")
click("""#remember-password""")
click("""#submit""")5 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 -
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
-
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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
-
data purging - add a flush/reset button
it would be nice to have the possibility to clean/empty all data from sql monitor. for instance since we were trying different alert options etc... there's a lot of stuff which are not needed anymore. i mean after fine tuning the system i'd like to "start over" with a clean history even if we lose the old logs...
3 votes -
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 -
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 -
have more flexibility with user permissions.
I'd like to be able to customize permissions. For instance, I would like an AD group to have the ability to set and remove alert suppressions (operational) but not have admin access to the monitor (administrative).
2 votes -
Index Analysis -- Index Object Filtering
Index Object Filtering -- Ability to Exclude Objects.
It would be nice to be able to exclude the RedGate indexes, or exclude specific databases, or other specific objects. Currently, filtering is more inclusion based but frequently exclusion is easier.
1 vote
- Don't see your idea?