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
724 results found
-
ADD Support for GCP Cloud SQL (MSSQL managed instances)
As Google Cloud Platform increases their market share and adds features such as managed instances for Microsoft SQL Server, it would be great to have the ability to monitor those as well.
4 votes -
silence alerts for x hours
If an alert is firing repetitively for say a job failure, to be able to silence the alert for a number of specified hours (not permanently) if you know it will recover later, but you don't want to disable the job - just want the alerts to stop temporarily
12 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 there a way to set the minimum y value displayed in a graph OR is there a way for the collector to ignore any negative value for “rate of change”?
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 -
MONITORING ERROR (SQL SERVER DATA COLLECTION) more infromation
Is it possible to list the items that failed in the alert?
In the description for this alert it notes that one or more of the following connection methods failed:
WMI
Remote registry (PerfMon and registry access)
Remote file access is not set up (hidden administrative shares should be enabled)
SQL connectivityIs it possible to note in the alert details which one failed? It would make troubleshooting after the fact a bit easier.
1 vote -
Show alert bubbles in other metrics, too
I like seeing the alert bubbles in the main overview. It would be helpful to also be able to see them in the additional metrics shown below. Anothe option would be to align these other metrics with the main 4-metric window.
1 vote -
Add AND/OR conditions for disk alerts
We are using SQL Monitor to monitor disks and we also send these disk alerts to our NOC(24/7 monitor team) and when they receives an alert they are calling us on our On-Call service when outside office hours.
The alerts are not always relevant as the alert can be like for example:
Disk free space less than 5 % but actual space left is 300 GB, which is more than enough and no alert and phone call had to be triggered.We are trying to set custom disk alerts but as we have 1000+ disk alerts to configure it’s impossible to configure all of them.
It would be great if we could be able to create custom disk alerts using Conditions.
An example of what we would like to be able to add to SQL Monitor --> Disk Space Alert:
Disk free space < 5 % AND < 100 GB = Alert Yes
Disk free space < 5 % AND > 100 GB = Alert NoWe are using SQL Monitor to monitor disks and we also send these disk alerts to our NOC(24/7 monitor team) and when they receives an alert they are calling us on our On-Call service when outside office hours.
The alerts are not always relevant as the alert can be like for example:
Disk free space less than 5 % but actual space left is 300 GB, which is more than enough and no alert and phone call had to be triggered.We are trying to set custom disk alerts but as we have 1000+ disk alerts to configure it’s impossible…
44 votes -
show client host name for queries in top SQL
In the TOP SQL, I see login and program name, but not client host name. It would be helpful to see the client host name, too.
9 votes -
Backup overdue alert - RegEx filter
I have many non-production databases on production SQL Instance, that make no sense to backup. I know I can turn this alert off one by one on each database. RegEx filter by database name would be help.
12 votes -
Monitor SQL Server running on AHV hosts
Whilst you have added the ability to monitor vmware hosts, I would like to be able to monitor other virtualization technologies. E.g. AHV (Nutanix)
6 votes -
Customize Estate Version Thresholds
On the estate tab, it would be nice to customize the thresholds that define the yellow and red state. For example, a server behind on one CU might be yellow, but others red.
5 votes -
See the last X weeks of User transactions/SQl statments ran on the server
Have a view in SQlMonitor that can be used to do a quick search on what querys a user has run on SQL Server over the last X weeks.
For our user case we would just need the data for the last two weeks but sure if storage allows user's would like to hold the data for longer.
This is to enable some auditing functionalty to quickly find what a user has ran for reporting.
e.g.
What did user1 run yesterday,
What was run and by who over the last hourThis could also help with finding performance issues. For example user1 is reporting problems with their querys but it dosn't appear in the top 10-50 sql statments in the current view.
Exporting into csv would also be useful.
Have a view in SQlMonitor that can be used to do a quick search on what querys a user has run on SQL Server over the last X weeks.
For our user case we would just need the data for the last two weeks but sure if storage allows user's would like to hold the data for longer.
This is to enable some auditing functionalty to quickly find what a user has ran for reporting.
e.g.
What did user1 run yesterday,
What was run and by who over the last hourThis could also help with finding performance issues. For…
7 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 -
Monitor Distributed Availability Group Metrics
Monitor Distributed Availability Group Metrics, currently there doesn't appear to be any metrics tied to distributed AG. Could be as simple as using the monitoring query her:
https://tracyboggiano.com/archive/2017/11/distributed-availability-groups-setup-and-monitoring/16 votes -
Exclude a database, instance or the entire alert based on an actual alert
It would be a nice feature to be able to click on an alert and get the option to exclude future alerts:
1 - for this specific database
2 - for this specific instance
3 - for this specific alert3 votes -
Monitor Resource Governor
Possibility to monitor Resource Governor Pools:
• Show statistics on pools
• Show workload of groups: cpu, io and memory18 votes -
"Index searches/sec"
Why in SQL Server metrics there is no “Index searches/sec”.
In your description for “Full scan/sec”, you mention “The ratio of Index searches/sec to Full scans/sec should generally be no more than 1000:1.”.
It would be very useful to have this counter without having to go through performance monitor under windows8 votes -
be able to move database to another server
Sometimes I need move database to another server. I did it last time and I lost access to historical data. Moving databases is very common practice.
I think it is a big disadvantage.3 votes -
Add waits, CPU, & IO to the "sort by" options on the Global Dashboard.
Currently there are only two choices to sort by for the Global Dashboard screen:
Name & Severity
It would be nice to add more options, as they are displayed in the tile view. The options of course would be waits, CPU, & IO.
25 votes -
compare different times in analysis graph
We have upgraded SQL and changed servers for one system It would have been nice to compare in the same graph different timeslots and different machines
3 votes -
Query Plan Regression
Ability to track queries and alert when query plan regresses or duration increased beyond a given threshold.
6 votes
- Don't see your idea?