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.
765 results found
-
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 -
Link to alert within Teams notification
I would like to see a direct link to redgate monitor alert within the teams notification. At the moment I have to search for the alert in the WebUI manually instead of clicking a direct link like it is in a mail notification with "View full alert details" button.
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 -
Control Alerts Using Metadata
CONTEXT: We have a maintenance and backup solution which uses SQL Server as a backend to determine what databases to perform the tasks against, and at what time.
PROBLEM: Some databases do not have maintenance tasks running against them, but still have alerts which appear in SQL Monitor for them (e.g. Index Fragmentation). I don't want to manually exclude these from SQL Monitor, as the number of databases fluctuates, particularly on our testing and development environments.
EXAMPLE SOLUTIONS:
- Provide a means of easily enabling/disabling/changing alerts dynamically using a stored procedure.1 voteDaniel Rothig
responded
For your usecase I recommend modifying the maintenance window metadata instead:
UPDATE s SET MW_IsEnabled = 1, —or 0 to enable alerts again MW_Start=0, —midnight MW_Duration=864000000000, —24 hours MW_Monday = 1, MW_Tuesday =1, MW_Wednesday=1, MW_Thursday=1, MW_Friday=1, MW_Saturday=1, MW_Sunday=1 FROM [settings].[SqlServers] s INNER JOIN [settings].[Clusters] c ON c.Id = s.ParentId WHERE c.Name = ‘hostname’ AND s.Name = ’’ —Set to SQL Server name or leave empty for unnamed instancesA restart of the base monitor service will be required after the change
-
Click on CPU part of the server block on global dashboard (version 5.2) leads me to serveroverview instead of graph
I would suspect to go to the graph (analysis tab) after I click on the CPU part of a serverblock (in Global Dashboard), instead of the server overview
1 vote
- Don't see your idea?