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 — often the SQL Monitor team will initially stay quiet about new suggestions to see what you have to say!
If you have any questions visit the Redgate Monitor forum.
683 results found
-
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 -
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 -
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 -
Estate view (SQL Server version) Discrepancies
For the SQL 2016 versions of SQL Server, we are seeing the software is flagging as "not current". However, we do have the latest SP/GDR.
This issue lies with the Azure Connect Feature which only applies to connections to Azure based on an article we read. . (https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2016/build-versions)
We do not use Azure so we feel that this should not be a required patch.
3 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 -
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…
1 vote -
Feature for Integration of Redgate Monitor with Share point
Integration with SharePoint to display the dashboard without needing to login
1 vote -
Login to SQL Monitor using a CAC
For members of the military or contractors, they login to systems using Common Access Cards (CACs). It would be great to allow users that are authorize to login to SQL Monitor, to be able to log in with just using their CAC and pin number.
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.
3 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 -
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 -
Show query history for custom date range in "Top Queries" view
In the top queries window, the history can only be searched via three date ranges:
Zoom Range,
Window Range,
All historyIt would be good to be able to search a custom date range to make the graph easier to see for a time period of interest. Window range is only three days max and all time can be too broad.
5 votes -
Pause auto-refresh when you view query recommendations.
When a user clicks on query recommendations, the auto-refresh needs to be paused. Otherwise, the recommendation pop-up window closes when Monitor refreshes.
1 vote -
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.Nguyen1 vote -
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 -
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 -
Clear RedGate Alerts automatically
Once the alert is taken care of, RedGate should send an email saying that the alert is cleared. Also, there is no need of a clear button in the web interface, it should be done automatically.
2 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
- Don't see your idea?