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.
765 results found
-
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 -
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…
31 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.
43 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 -
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 -
Show login or user in the Top 10 Queries
Include login or user id information in the Top 10 Queries. This could help identify if a user is running an ad-hoc query.
53 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 -
Estate Disk Usage Emailed Report
It would be great if we could schedule an emailed report of the disk usage estate section.
11 votes -
Group sql server instances at the instance level, not at the server/cluster level
I would like to control the group that an individual sql server instance is in, rather then having to group things at the server/cluster level. The group views and control over alerting is great, but in the event that the same cluster/server hosts a dev and production instance, or multiple instances that are managed by different members of a DBA team,the usefulness really suffers.
14 votes
- Don't see your idea?