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.
768 results found
-
SQL Versions Page
Hi there,
We maintain a number of legacy SQL Servers that are still monitored via SQL Monitor. I regularly use the SQL Versions page to identify which instances require patching.
However, some of these servers are under a permanent patch freeze, and I’d like to update their status to “OK” so they no longer appear as needing attention.
It would be amazing if one could update the patch status for these servers within Redgate to mark them as compliant to reflect their frozen state.
3 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 -
We would like to have a log of users that did use RedGate Monitor
In that way we could create a report of the users when they did use RedGate Monitor. example a weekly or monthly report showing how many times a user did use the application.
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…4 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 -
Add additional metrics for Latency, Failover, queries categories for MongoDB
• Replicaset metrics around latency and failovers…etc. Like SQL Server.
• Something to track queries performing large scans vs seeks.
• Would be nice if the alerts (even if duplicated were broken out by platform. They are shown by SQL which I get is your primary offering, but just saying also postgressql vs seeing its PostgressSQL on Linux or MongoDB on Linux and change the alert offering to reflect those in a separate grouping like SQL.
1 vote -
Additional Overview Tab Suggestions
• OS configuration (how many sockets/cores and Memory are allocated) * SQL Server, Mongo and PostgresSQL environments Right now there are only %’s, I want to see of what.
• MongoDB Memory configuration I see SQLs but Mongo is missing. i.e. WiredTiger Cache settings
• ReplicaSet information for Mongo, along with who is the primary, secondaries and where are the secondaries seeding from, and the status.
1 vote -
Trend Analysis and Forecasting for Azure SQL Database capacity
A previous feature suggestion, https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/11122308-forecast-and-plan-disk-database-capacity, was completed in 2018. However, it does not include storage for Azure SQL Databases or Elastic Pools. While we can alert on this, we get no trend analysis or forecasting.
Selecting All Disks and All Groups on the Estate | Disk usage page gets us "No disks match your filter criteria."
2 votes -
Add Unallocated Disk Space % to the History view for a database
For Azure SQL Databases, this view currently has check boxes for DTU, CPU, Data IO, and Log IO, which are all checked by default. It would be great to add a check box for Space, which would not be checked by default and would show Unallocated Disk Space %.
1 vote -
Set default Redgate Monitor time zone
My Redgate Monitor server is on a server with the time zone set to UTC. When I open a Redgate Monitor on that server I get all the times in UTC, which is great.
When I open a Redgate Monitor on my local computer, the GUI shows the times adjusted for my timezone.
Since my team is monitoring from different locations in different time zones, we get different times depending on the timezone.
I would like an option in Redgate Monitor configuration to easily set a default time zone so all the users can see the same time zone.
9 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 -
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 -
Pull Server Certification Info
Would like to request enhancement to be able to create a report to pull Server Certificate info, and have an email sent out to notify us 30/60/90 days before hand when it will expire. Pull details like the certificate issuer, validity period, and common name from the server certificate installed on the target machine.
7 votes -
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 -
using standard user rights one should be able to create an alert suppression and only remove one if that one was made by the same user
DEVOPs team know when they have planned changes and in that case it would be good that they can create alert suppression and after the change removing that without we need to grant them admin rights
4 votes -
Improved windows range handling for Individual query monitoring
The current windows range on the new Query executions tab is fixed to 2 hours. Should be great if the length of the windows range could be customised.
At the same time make it working together with the zoom range on the History tab. This so if you have zoomed in to a certain time range on history tab then when opening Query executions the same time range should be used as the windows range. Alternatively you could use the same type of windows range and zoom range that are already used on the History tab.
4 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 -
I would like to customize the behavior when job failures happen. We get an alert on the 1st but no additional until the job is successful
I would like to customize the behavior when job failures happen. We get an alert on the 1st error but no additional alert until the job is successful. It would be nice to have the ability to allow this behavior as a default but then have the option to have specific Job Failures alert every time (mainly for jobs that run weekly or greater).
10 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
.png){kind=link}
- Don't see your idea?