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.
736 results found
-
Additional option on the Alert Suppression Windows
It would be great to have an additional option on the Alert Suppression Windows to have the ability to only stopping sending notification for new alerts and continue to send the notification for the end of alerts
I guess something like "Notification for new Alerts only (alerts will still be raised)"
The idea would be to receive the end of alert notifications for alerts that were ongoing when the alert suppression window started13 votes -
Include SQL comments in Top Queries search
I use Entity Framework Core to interact with a SQL Server database, which comes with the ability to "tag" queries with extra searchable information for troubleshooting purposes.
This extra information is in the form of SQL comments, like so:
-- SPARK: PartyRepository.PartySearch
It would be very valuable to be able to search for this data, but unfortunately it appears that comments are excluded from Top Queries search, even though the data is there in SQL Monitor query data.
7 votes -
DataRetention setting and Performance troubleshooting data per technology because needs may be different
Possibility define DataRetention setting and Performance troubleshooting data per technology because needs may be different between sqlserver, postgres , mysql, etc, and improve disk space of seacrh engine queries.
7 votes -
Deploy the latest API when updating Redgate Monitor
I would like when installing the latest version of Redgate Monitor to have an option for it to deploy the latest version of the API as well to a location. The last few times I have done the install I have not updated the API right away as it been a set and forget thing. Comes the evening when it runs it fails due to the versions not being the same.
I have checked within the Program Files and 2/3 of the files are not there. (RedgateMonitor.psd1 and RedgateMonitor.psm1), so I cannot just have it import via that way.4 votes -
Data retention - auto shrink if SQL
Recently engaged with redgate support about this and was advised to raise on here.
When changing data retention settings within Monitor and reducing the timeframe, it does free up space within the database but it isn't released.
Adding a routine within Monitor to run a shrinkfile against the database would be an ideal solution, but even adding a button/form within Monitor to set up a SQL agent job to do this in a standardised way would be fantastic as a quality of life, as if you're reducing the retention it's usually going to be because of disk space constraints.
2 votes -
Monitor an Azure SQL Database geo-replicated secondary database
We have geo-replication set up for many of our production databases, and we have some processes and users that use that for executing read-only queries. We have alerts set up in Azure Monitor for simple things like when CPU % exceeds 95% for more than 2 minutes. We would like to use Redgate Monitor to identify the workload that is causing that (Top SQL). However, when we try to add the secondary server, Redgate Monitor cannot find any databases in it.
4 votes -
Search by Query hash in Top queries
As discussed in https://forum.red-gate.com/discussion/91306/search-by-query-hash-in-top-queries/p1?new=1
it would be very useful to be able to search by Query hash in Top queries.Scenarios:
- for complex (and parametrized) queries it may not be enough to be searched by QueryText, DatabaseName or ParentObjectName;
- if queries impact is also investigated and tracked in external systems the QueryHash may be (the only common) field to quickly identify and find that query in Redgate Monitor.5 votes -
View top queries, stored procs, top waits, index usage at estate level on Azure SQL
You can currently only view the top stats at DB level for Azure SQL. We run a multi-tenanted SaaS application where all DB's are identical across the estate, so to be able to compare offending stored procs, indexes etc. across the board would be incredibly helpful.
1 vote -
Monitoring of Azure Database for MySQL Flexible Server
With the introduction of monitoring of MysQL it should also be great if we can get monitoring of Azure Database for MySQL Flexible Server.
3 votes -
flexible disk configuration
Currently the configuration for disk space monitoring in “RedGate Monitor” only gives the option to check on the number of bytes that is still free on the disk (in GB or MB).
Ideally one should check on the number of bytes in combination with the % free space.
The reason for this is that percentage hugely differs depending on the total size of the disk. On a small disk one would like to extend the disk when it is 80% FULL, where as on a much bigger disk, 20% space might still be many GB’s and to early to extend…3 votes -
Track Aborted Sessions
The ability to view aborted sessions, either an alert or space on the overview page in a similar way to the TOP 10 queries.
Attached is the offering from SolarWinds.
6 votes -
Enhance query tagging in monitior overview.
Add extra functionality to query tagging: allow colour coding of tags, add comment text to tagged queries, enable query tagging in postgresql (I am current using postgresql monitor v14.0.34 with server deployed SQL server, SQL Azure and PostgreSQL Aurora).
Is there any timeline for this?
3 votes -
File Usage per File Group within the DB
Want to be able to set database file usage per drive level on the server level. But there are many times when a vendor created db, they have multiple data files mdf/ndf and have them set to limits. So i was wondering can we get even more granular. I want to be able to drill down to the database and select a particular file group and say ignore this drive, it has meet its capascity and even though its 100% filled data is no longer being written there. And the reason behind that is there can be multiple data files…
5 votes -
Add alias to rest api
The rest endpoint api/v1/monitored-entities should include the alias field. It would present as an empty string if the monitored entity does not have as an alias and filled in if an alias has assigned to the monitored object.
7 votes -
Have the RG tempdb table indexed
The RGAllObjectsv4 table in tempdb currently accounts for 7 of the top 20 missing index suggestions on our production server via the built-in report in SSMS. Can this be indexed by RG so that the indexes will be reapplied when the server or service is restarted? I've attached the list of suggestions.
2 votes -
Alert suppresion window by specific date every month
We do our maintenance on scheduled windows on the 20th and 21st day of every month, including weekends.
Currently, it is not possible to set up such a recurring alert suppression window.
Can you add this to the Redgate Monitor alert suppression settings?3 votes -
Want to monitor SingleStore Databases
As part of our infrastructure, we utilize SingleStore databases, and we would greatly benefit from monitoring capabilities within your platform. Given its MySQL-based architecture, we believe incorporating SingleStore monitoring into RedGate’s suite would enhance visibility, optimize performance tracking, and streamline database operations.
We kindly request that you consider adding SingleStore database monitoring at the earliest opportunity.
1 vote -
Want to monitor SingleStore Databases
As part of our infrastructure, we utilize SingleStore databases, and we would greatly benefit from monitoring capabilities within your platform. Given its MySQL-based architecture, we believe incorporating SingleStore monitoring into RedGate’s suite would enhance visibility, optimize performance tracking, and streamline database operations.
We kindly request that you consider adding SingleStore database monitoring at the earliest opportunity.
3 votes -
Add Index rebuild command into alert mail
I get sometimes Fragmented Index alerts as mail.
To fix it , I have to copy every single index name into the clipboard, switch to SSMS, write “ALTER INDEX ”, insert the index name and let SQL Prompt add the AS <table> and finally have to add the word REBUILD.
Why do you not make it simpler for me (and other customers) and add just another column that already contains the whole INDEX REBUILD command (or REORGANIZE if the fragmentation is low) to the mail / web frontent.
It's still to me, if I want to execute it or if…
3 votes -
Add ability to monitor mongodb hosted on Windows
Add the ability to monitor mongodb instances hosted on Windows - currently only Linux selfhosted mongodb instances are supported.
I suppose this will not be a very popular suggestion because most organisations are hosting mongo on Linux, but for the few that do - like us - it'd be very nice to have.
I would expect this one would be easy to implement as there already is a need to enter Windows credentials for monitoring when adding SQL Server hosted on Windows.
3 votes
.png){kind=link}
- Don't see your idea?