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.
791 results found
-
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 -
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 -
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 -
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 -
Uncover hidden tuning opportunities by toggling graphs to a different scale
Two problems, one suggested solution: First, too often something important to us is hidden, because the graph showing the critical metric is skewed by another event. In order to show the peak of that event, the graph is scaled such that other activity is just a flat line at the bottom. Second, graphing multiple measures in a single graph, when their scales vary widely, makes interpretation difficult--for a contrived example, imagine plotting CPU (scales to 100) and batches per second (scales to tens of thousands for our web site). A tool for tuning MongoDB provides a beautiful solution, by allowing…
2 votes -
groups
Group properties.
I am using groups to group databases by application /development group. Then use tags to determine prd, dev, uat etc.What would be really useful would be able to add properties to a group such as the developer name to contact when i see poor queries
2 votes -
"Whats new" should link to the relevant release notes under "New features" tab
It currently only shows up the the release currently running, not what is in the new release. I have to search the web site to find out whether there is anything in the release that I care about enough to upgrade.
2 votes -
2 votes
-
Additional column for each statement with the total duration including the wait time
On the history dashboard, I would like to have an additional column in the top queries area in which the duration including the duration of the wait events is displayed for each statement.
So far I have assumed that these are already included in the existing duration column. In context with a service request, I understood that this is not the case.
At first glance, I need the actual total duration without manually adding the waits statement by statement.
2 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 -
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 -
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 -
Simplify alerts without mentioning product names like PostgreSQL
Few alerts in Redgate Monitor ends with "(SQL Server and PostgreSQL only)".
We don't use PostgreSQL and don't plan to do it. Would be nice to turn off that feature permanently so that, for example message like “Database unavailable (SQL Server and PostgreSQL only)” shown as “Database unavailable”2 votes -
update MS teams channel alerting to send alerts to various channels and not just a single channel
Much like when using SMTP alerts, can you add the ability to specify an alternative channel for alerts sent from a specific server or group of servers.
for example, if I have 2 groups of severs,
- producion alerts to channel 1
- non-productions server alerts to channel 2the core issue is we have multiple "products" monitored (production and non-production) and
we don't want the noise from the first product to be visible to the second, or third products.Currenly we use email groups for this but with changes in O365 we are under pressure to stop using SMTP.
2 votes -
Lead blocker/blocking alert
I'd like to request an enhancement to Redgate Monitor's blocking alerts.
Currently, alerts are triggered when the total blocking time across all blocked sessions exceeds a threshold. For example, if three separate blocking events last 20, 25, and 30 seconds, an alert may fire because the combined blocking time exceeds 60 seconds.
Instead, I would like the option to alert on a lead blocker that has been continuously blocking other sessions for a specified duration. For example, if a single session blocks others for more than 60 seconds, the alert would trigger.
This would reduce noise from multiple short-lived blocking…
2 votes -
Add % CPU Usage column for the "User SQL processes (top 10 by CPU usage)" section.
On the Overview page for the SQL Server instance there is a section: User SQL processes (top 10 by CPU usage) that show current SPIDs that are utilizing CPU resources. This section should show the actual % of CPU usage for that SPID.
1 vote -
Collect SQLServer:Memory Manager counters.
This would be especially useful for SQL 2012 where counters have been removed from the buffer manager exist in the memory manager counters. For SQL Server 2012, I have observed that there is a memory leak and this is revealed by observing the Memory Manager Optimizer Memory (KB) counter.
1 vote
Daniel Rothig
responded
Hi, we’re monitoring a few of those out of the box and the rest can be covered via the custom metrics feature – check out sys.dm_os_performance_counters
-
UI global overiew - add tickerbox with unread alerts
To get a instant view of the unread alerts and their context/importance it might be a good idea to create a tickerbox at the leftmenu of the global overview page.
Currently to know what kind of alert has occured, I have to zoom in/navigate everytime to the alert page.
Layout example: Grouped by server, level, category, datetime
As addition it might be an option to create a tickerbox hide option .
1 voteDaniel Rothig
responded
(Gathering feedback)
Hi brendo, how would you expect the tickerbox to behave if there is a large volume of alerts incoming? Would you expect to always see the x most recent ones, or would you like to be sure that all alerts show up in this tickerbox over time?
-
MS DTC down alert....
I would like to see an Alert if MS DTC (the DTC service) has stopped\failed or doesn't restart after a reboot.
1 vote -
Add plus/minus tolernaces for unusual job durations
Allow different tolerances to the plus and minus percentages for the "Job Duration Unusual". In some circumstances (especially when there may be a lot of data coming in and the disks are extremely busy), I don't mind a deviation of a few hundred percent positive in the deviation. But a negative deviation of 90% would likely indicate some of the expected data was missing (thus a problem).
1 vote
- Don't see your idea?