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
-
Grant more granular report level access
I can grant report level access to a user by adding them to the Reports User role and I can restrict the servers which they see reports for.
However, this role gives the user more permissions than I would like to give - they can still view any other page - alerts, server overview etc
Can we change this so they can see the reports only?
2 votes -
Add ability to collapse the "Query details"/"Wait type"/"User memory" list under a specific query.
Often we want to screenshot the execution pattern, the graph below all these areas and because all of those occupy a big chunk of space on the screen, this becomes harder.
We end by "zoom-out", crops, or even picking multiple screenshots and doing collages.
Thanks
2 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 -
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 -
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…
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 -
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?
- Don't see your idea?