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.
695 results found
-
Current Activity (sp_whoisactive) History
I would love to see snapshots of current activity (sp_whoisactive) taken on a regular cadence (e.g. every 5 minutes would be very useful for troubleshooting).
So in the current activity tab I can select a snapshot time from a dropdown of taken snapshot times. Backwards/Forward buttons advancing to the next/previous snapshot would very powerful.Having the top queries and waits etc. is super useful, but being able to see a snapshot of the active running queries around an incident would add a lot of value.
Appreciate that is potentially generating a significant volume of data so appropriate retention/default capture options/server…
2 votes -
Show "HostPID" on deadlocks
Add "Hostname" and "Hostpid" detail to blocking processes and long running queries in RedGate, this information is available deadlocks.
This would help us to identify the process causing the blocking to further investigate fixes vs trying to work out the process from the SQL code, which can often look similar to other queries.
2 votes -
Feature for Integration of Redgate Monitor with Share point
Integration with SharePoint to display the dashboard without needing to login
1 vote -
Possible AI usage for Alerts in Red Gate Monitor
The alert system for Red Gate Monitor could be improved with some more intelligence. For example Full backup jobs and differential backups, weekly full, daily differential. Of course the differential will take a lot more time just before the full backup in comparison with the differential backup just after the full backup. If Monitor could "learn" the environment and only give alerts when things are really off then this would be much better.
4 votes -
Datawarehouse Database for older data
There should be an option to transfer older data to a datawarehouse database and still seamless be accessible from the Red Gate Monitor tool. This way the primary database can be small and quick in normal day to day use.
2 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 -
compare query metrics across instances
I would like to be able to compare query metrics across SQL Server server instances.
We have a number of environments - Dev / QA / UAT / Production
the data generally increases in volume and gets more "real" the further up the chain we go which can mean something that performs well against the "small data" on the dev server can become an issue when it hits UAT which has real volumes of data
It would be useful to be able to compare a query across instances so if we release a feature which comprises of a number of…
5 votes -
see a greater time range in the Overview
Often customers would like to see a broader overview, eg a whole week or a classic working week (Mon-Fri). It would be great if we can extend the overview to 5 or even 7 days.
4 votes -
Support Monitor Ubuntu with another port ( not port default 22)
Dear Development Team,
Currently, I'm using SQL Server running on Ubuntu ( with SSH port 5678). I can't connect to OS Linux via SSH port 5678. I don't see where to input the port (not the default port). I want the Team to enhance the feature allow to the input SSH port.I have created an issue to discuss here (https://productsupport.red-gate.com/hc/en-us/requests/305026)
Thanks,
Khoa.Nguyen2 votes -
more results per page
Results per page. Increase the number of results per page or in the waits section there is a checkbox for maximum 50 results too custom number
1 vote -
Grant user access down to SQL instance or database level
Currently the lowest level we can grant users access to cluster level. In multi-instance clusters this gives too much. Need to scope user access to instance and database level.
1 vote -
Webhook Filter on Alert Severtiy
Situation: After setting up a webhook of SQL Monitor to Service Now we are getting tickets of all priorities
Background: We would only like tickets to be created that are actionable
Assessment: We can enable this on the javascript side of the service now webhook to remove low priority webhook calls however it would be prefered to do it in RedGate
Recommendation: Is it possible to have the same feature that email has "Call webhooks only if alert severity is High or Medium only"
8 votes -
Longest queries which are running on each server.
Right now we are getting only 4 queries. Also, if we check Database, these are only the system databases, Actual databases are not considered here.
Our requirement is to get the Longest queries which are running on each server. After getting these details performance optimisation team is going to check those queries and try to optimise them. Can we get these details?1 vote -
Customize email alert recurrence to receive it more often
Have an option to change how often I want the email alerts to come. Let's say I want to track the alert for every, and I mean every, SQL job failure. Everytime a job fails, even when I intentionally fail it, I want to receive a mail.
3 votes -
Set a custom alert for a individual tracked query
We can track query's from the analysis page - good for when you want to see how a query changes over time. What would be even better would be to be able to set an alert on a tracked query on any metric but for example, the execution time so we can get an early alert if it is taking a long time to execute and it's business critical
1 vote -
contained
Add support for Contained Availability Groups (CAG) in SQL Server 2022
This is actually a feature that broke with the new version. There is no ability to monitor SQL Agent Jobs.3 votes -
Produce a long running queries report ordered by average execution time
I have been tasked with identifying queries with the longest average execution time so that they can be targeted for optimization. In the server overview this can be done in the top queries section, however this obviously only shows queries for that instance.
In the reporting tab I can create a report for long running queries, but it is based around total execution time. It would be useful if this could be ordered by average execution time.
A query that runs 100,000 times and takes 10ms will have a higher overall execution time than one that runs 50 times and…
1 vote -
Add Top Waits info for PostgreSQL
Re: PostgreSQL Monitoring
Please add the ability to show wait stats by wait type as you have for SQL Server.
3 votes -
Show login and client hostname/IP address for Top Queries on PostgreSQL
Re: PostgreSQL Monitoring
Please add information about the connection that the queries (in the Top Queries section) were executed on, specifically the client machine hostname/ IP address and the login name.
4 votes -
Job failing Alert option for number of consecutive failures in a row
I have some SQL Agent jobs that run every 2 minutes and legitimately fail occasionally to circumstances outside our control.
I need to be alerted if the job is constantly failing, e.g. failed 5 times in a row, but I do not care about one off failures.Having a customisable option for individual jobs to alert only after X consecutive failures would be fantastic.
3 votes
- Don't see your idea?