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
721 results found
-
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 -
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 -
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 -
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
-
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 -
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 -
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 -
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 -
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 -
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 -
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 -
Be able to give users different access to different groups
I would like to be able to give some developers Read-only access level to some servers (or server group). For example Production servers.
But give them Standard access level to other servers (or server group) so they can clear alerts for example and configure their own alerts.
1 vote -
Add option for more detailed email alert
It would be good if there were more detail levels of mail alerts.
Example: I would like to see not only block process, but also which database and object; In case of failover, I would like to see both nodes failed and active ....31 votesSQL Monitor V 3.3. has now released. This release contains improved subject lines and message bodies of alert emails to help you quickly understand problems before logging in to SQL Monitor.
Thanks,
SQL Monitor Development Team -
I would like to see a better dashboard view
One where I can see a cumulative report of ALL of the instances being monitored with average totals for cpu/memory/disks utilization, across them all. Average success to failure ratios for Scheduled jobs (backups).
27 votesWe implemented a new global dashboard in the 5.2 release, which shows an overview of all instances on one screen.
-
Delay "Performance Data" Load for MOST Alerts
For at least 99% of Alerts of Interest over the last 6 YEARS of using SQL Monitor, the lower pane's "Performance Data" is of nigh on zero use.
IF it might be of use, give us a "Load..." button next to that heading, and load it on demand.
When I'm ploughing through a hundred or so predominantly Blocking Process and Deadlock alerts, the most important information is in the Details and Processes tabs.
Page loading delays will decrease because you won't have to pull eye-candy charts that aren't read for the bulk of the time.
The "Delay..." option, for…
4 votes -
open alert link in new tab or window
When viewing an alert within the side-bar on the Overview page, clicking on the 'Go to the full details' arrow redirects the page to the intended alert. You have to then click back to see the overview page again.
It would be great for the ability to be able to open click through links on a new tab or window instead of the same window to prevent navigating away from the overview page.
6 votes -
Blocking process report does not display database name
I would like to see databasename and also starttime and endtime in the blocked process report. It qwould also bee good to be able to scale the picture in size.
7 votes
- Don't see your idea?