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.
687 results found
-
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 -
Have a free-text notes field for each server\instance
A notes field can be used for any useful information such as business contacts, service hours or documentation links, etc.
16 votes -
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 -
Ability to filter "TOP Queries" by login
Often we want to filter queries not only per existing options (database, parent or query) but it's useful to be able to search for a specific login.
Could you allow searching by login using "l:" or "login:"?
9 votes -
Mask sensitive data from deadlock and top queries
We want to let developers use SQL Monitor, but for that sensitive data has to be masked. Two places that come in mind where we can things like literals in WHERE clause etc are deadlock and top queries. This would ideally be combined with a security group which which the masking should apply.
3 votes -
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 -
Expiring Certificates
Would really helpful to have an alert for expiring certificates on a cert be it backup encryption ones or tde certs that are going to be expiring and we specifies how much notice we want given before the expiry
8 votes -
Monitor Cluster Shared Volumes
Under the “Analysis” section, there are cluster metrics which include four different options relating to Cluster Shared Volume usage.
• Used Bytes
• Used %
• Free Bytes
• Free %If we click on the above, we can review our CSV’s to see whether we are approaching the drives maximum capacity.
What isn’t included is the performance of the disk. For instance, under the Machine metrics section, the following is available:-• Disk avg read time
• Disk avg write time
• Disk read bytes/sec
• Disk write bytes/sec
• Disk transfers/sec
• Avg disk queue length.However, these…
10 votes -
“Longest Running Queries” in Redgate SQL Monitor Reports
I need to show more “Longest Running Queries” in Redgate SQL Monitor Reports. The layout of the report is also a bit awkward, it seems if everything does not fit into the report.
See attachment.7 votes -
Provide Managed identity as an Authentication Method to the Redgate Azure SQL DB
Support for using the managed identity of the Webserver/Applicationserver VM to authenticate over the AAD on the Azure SQL Redgate Database.
-> Maybe also Support for Azure App Service which has built-in this functionality?
3 votes -
Job Duration Unusual Alert should be 'AG aware' to avoid false positives
We are using an AG for one of our instances.
As you would expect we have the same SQLAgent jobs created on both instances in this AG, but we only want the job to execute on the primary.
In SQLAgent the jobs on both nodes of the AG have a step at the beginning which checks to see if this is the primary instance.
If it is the primary instance it will proceed to step 2 and execute the rest of the job.
If it is not the primary instance the job will terminate.
This all works fine - however…2 votes -
Ability to add notes to tracked queries
When working in an environment with multiple people is typical that each person is tracking different queries to analyse ongoing changes/improvements.
Being able to note something as "Tracked by Cláudio. Following FIX #1234" would be great.
It will give us a clue on who is working on what and reach out to that person. Or just keep small notes during the analyses.
9 votesA great suggestion. We are exploring this as part of a wider review into improving query tuning features.
-
Monitor DB2 Databases
I would like to be able to monitor DB2 databases in the same fashion as SQL Server databases.
3 votes -
Monitor Oracle Databases
I would like to be able to monitor Oracle databases in the same fashion as SQL Server databases.
3 votes
- Don't see your idea?