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
716 results found
-
Add CPU time to Individual query monitoring
Should be great if we can get CPU time column added to the new Query executions tab.
CPU time is in addition to logical reads/writes important when looking and performance of the different queries.
9 votes -
File Usage per File Group within the DB
Want to be able to set database file usage per drive level on the server level. But there are many times when a vendor created db, they have multiple data files mdf/ndf and have them set to limits. So i was wondering can we get even more granular. I want to be able to drill down to the database and select a particular file group and say ignore this drive, it has meet its capascity and even though its 100% filled data is no longer being written there. And the reason behind that is there can be multiple data files…
5 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 -
Correct Database file usage alerts with In-Memory/Filestream Filegroups
The Database file usage alerts in V 8.2 are great, however they do not work correctly with Filestream filegroups. per https://forum.red-gate.com/discussion/comment/153592 they are not supported.
Please either add support for these filegroup types or disable them by default so we are not spammed by alerts for something that's not valid.
Thanks,
-Luke.6 votes -
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 -
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
-
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 -
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
-
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 -
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 -
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 -
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 -
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 -
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 -
Allow customisation of query execution threshold for Individual query monitoring
Individual query monitoring is currently either only catching or possible only displaying queries longer then 5 seconds. Should be great if it was possible to customise this threshold.
5 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 -
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 -
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
.png){kind=link}
- Don't see your idea?