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.
711 results found
-
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 -
Custom disk alerts in a cluster is lost when instance is moved to a new host
We often use customized disk alerts for larger disks i.e. instead of using the default alerts we might configure a High alert at 200 GB and a medium at 250 GB.
These custom alerts is not set on the instance level so when we move the instance to a new host the custom alerts will not follow the instance and the alert has to be set up again.
As our largest cluster is 9 node cluster with 23 instances and 3 disk each this cause us to configure these alerts at a maximum of 621 instead of 69 times. That…
21 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…
7 votes -
Command Line Install
I'd like command line installation to be an available option for SQL Monitor as I want to automate and script it, rather than having to do it manually
1 vote -
Raise an Event Alert when a database is dropped
There is currently no alert when a database is dropped or detached from a server. SQL Monitor should create an Event alert to record when the drop happened. Obviously this might be intentional (e.g. the alert you have now that records a database is offline), but it might be accidental or unknown to the DB team (E.g. a vendor drops their database).
Because it will (hopefully) be an intentional action, and quite probably no plan to ever re-attach the database, the alert should be an event alert rather than a normal alert (the normal alert would never end)
A similar…
6 votes -
Find Queries / Stored Procs whose Performance has Decreased Over Time
In preparation for changing the database compatibility level for our primary database to 2014, we would like to see which queries and stored procedures are performing poorly after the switch is made in the staging environment. While I can do this to a limited extent by looking at top queries in Red Gate Monitoring, I was wondering if there was an automated way to alert on this. For example, alert on any stored procedures / queries that appear in the top 100 costliest queries by duration / CPU usage, whose average duration / CPU usage has more than doubled since…
28 votes -
Be able to monitor Basic Availability Groups. Currently Basic Availability Groups are not supported
Be able to monitor Basic Availability Groups. Currently Basic Availability Groups are not supported
30 votes -
see Lock Escalations/sec as available metric in analysis graph
The customizable analysis graph does not include the option to display Lock Escalations/Sec (\SQLServer:Access Methods\Table Lock Escalations/sec). I like to compare this to baseline to regression-test releases. In conjunction with waits\locks, it can also warn the user that an index is no longer being used (as would happen if Entity Framework began searching a varchar column for an nvarchar value).
1 vote -
Estate Backup Emailed Report
I really like the new backup feature in the estate section; however, I would love to have this emailed on a scheduled basis. If the email could have a graph like the first sheet and the spreadsheet attached, it would be great.
40 votes -
Slack notification in more detailed
Slack notifies the alert, would be great to view complete details in slack specific to notified. This helps giving access to development for a slack channel to look into Long Running Query corresponding to database. without giving full access
8 votes -
add more custom notifications
Execute HTTP Action :
This notification method executes a GET request or sends any POST, PUT, or PATCH data to a custom URL. You can execute specific actions on a web server or control any web service that accepts commands via one-time HTTP requests. Whenever a notification of this kind is triggered, the HTTP action is sent.Execute Program:
With this notification method, you can execute a script or a program as an external process. It can be a Windows executable file or a BAT, CMD, or PowerShell file. You can use EXE, COM, BAT, CMD, VBS, or PS1 files.
11 votes -
Limited Estate functionality for unlicensed server
I would like to have very very basic estate functionality for servers without a Monitor license (I'm thinking Express instances on developer's station, sandbox instance without any real databases, etc.).
It would only be to keep visibility on them, so that we don't need to keep an inventory in a separate source. If the edition and version could be included that would be even better but of course nothing about disk usage / backups / jobs, etc.
I realize that this is essentially asking for something for free but I would venture that keeping visibility on all instances might lead…
12 votes -
Manage Scheduled SQL Monitor Reports from one overview page.
It's easy to set up a new report and schedule for SQL monitor reports. But once schedules are created it's difficult to manage them.
Have an overview page that would allow you to see all that has been scheduled .... giving options to:
1) Delete individual schedule (e.g. following server decommission or server no longer monitored).
2) Edit individual report schedule ... e.g. change time / frequency and for a particular type of report change the target server for that report ... i.e server replaced, being able to move report from reporting on original server report created for to replacement…1 vote -
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…
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 -
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 -
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 -
Query Plan Regression
Ability to track queries and alert when query plan regresses or duration increased beyond a given threshold.
6 votes -
Integrate with Policy Based Management
It would be really good to integrate with Policy Based Management to raise status alerts in SQL Monitor, that way we could breakout more complex Instance status
9 votes -
slack
Auto resolve slack after alert status is ended or cleared
6 votes
- Don't see your idea?