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.
- or
747 results found
-
Show query history for custom date range in "Top Queries" view
In the top queries window, the history can only be searched via three date ranges:
Zoom Range,
Window Range,
All historyIt would be good to be able to search a custom date range to make the graph easier to see for a time period of interest. Window range is only three days max and all time can be too broad.
8 votes -
Get notification for when a SQL Agent job is in a retry state
Hi, it would be really useful if SQL Monitor could identify when any currently executing job steps are in a retry state. We have many such jobs and the time lost whilst they are in such a state is frustarating as if we had notification we could take action. I appreciate I can roll my solution but would be nice if SQL Monitor could do it :)
0 votes -
Show Schema Name For Each DB on Top Procedures Grid
On the Top Procedures grid, within the row data - showing the schema name within the database if it exits.
6 votes -
Analysis: allow disconnecting y-axis from 0
The base of the analysis chart is always, always 0.This is okay when looking at small scale metrics (e.g. user connections), but for large scale metrics (e.g. file size) the proportions become so large that any change is imperceptible. Good luck detecting that your 2 TB database is growing by a GB/day. I don't need to see that it wasn't 512, 1024, 1536, or 2048 GB.
It would be nice to have the option to disconnect the y-axis from 0. Ideally it would automatically scale to the range of the data in the window, with a little margin around it.
5 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 -
Alert History on new Overview - Don't show Cleared Alerts
The slide-out Alert pane is useful on the Overview IF, and ONLY IF, under normal circumstances we want to see NON-cleared Alerts, like the default filter on the Alerts page itself.
Please make this pane behave like the Alert page's filter, and allow us to re-filter, to include cleared if we want to. But at the very least allow us to set a default filter (in my case NON-cleared).
Thanks.
7 votesHi, thanks for the suggestion. The version 6.0.10 release added the ability to show/hide cleared and ended alerts from the timeline and alert sidebar on server overviews. We intend to add this to the global dashboard soon. Hopefully this solves the issue.
-
I'd like it to be more obvious that an active alert is no longer a current and unresolved issue
Whenever an issue is flagged, for example in the night, it changed the server to red. Once you click on that, the state is "active" (more un acknowledged I would say if not current). For me it is not clear if that issue is still ongoing or that it had been an issue and is now resolved.
Can it be made clear what the end time is if the alert is no longer active? (right now only start time is listed)2 votes -
Create custom user roles
We would like to create custom roles to grant granluar access to specific functions/features in RedGate SQL monitoring console. Currently, permissions can be granted on monitored objects not on functions except using existing Reporting and Viewer only roles. There is no option to grant Estate access to selected team members or groups.
6 votes -
Add Text Boxes/Areas to Reports
I have reports that I circulate from SQL Monitor. I have to edit these before I issue them to add additional information. E.g. Under the "Lock Waits/Sec" chart I have a description of what a "Lock Wait" is, what impact it has, what's an acceptable value, etc. I tried supplying a supplementary sheet with this info but the management team prefer it under each chart / metric.
1 vote -
occurrences
Please retain a "tombstone" that can be referenced to present a history of "Occurrences" for HIGH Alerts. Allow us an additional retention period so these don't hang around forever - but please don't limit the number of days, just a smallint would be good.
When Monitoring Fails and is cleared, the Occurrence disappears when DB maint nukes "old cleared Alerts". If the retention period is short, say 14 days, the history of occurrences is soon lost.
A "tombstone" would at least keep the occurrences for trending.
6 votesJust keep the alert data in the Purge settings indefinitely – it’s only the metadata of the alerts, none of the performance data, so are “tombstones” as you described
-
silence alerts for x hours
If an alert is firing repetitively for say a job failure, to be able to silence the alert for a number of specified hours (not permanently) if you know it will recover later, but you don't want to disable the job - just want the alerts to stop temporarily
12 votes -
Improved view of User Sessions
Visibility into user sessions could be improved. The current list on the instance overview, "SQL User Processes (Top 10)", is a start but needs the following to make it useful:
1) Don't limit the number of sessions shown; rather add paging controls like on the error log view, so that it would be possible to see any session for any selected time period
2) Add a columns for:
- Login (i.e. login name)
- Blocked by session Id (maybe even an icon if a session is blocking/blocked?)
3) Make it possible to sort by any column
4) Add ability to…13 votes -
Availability Group alert details
It would be great to see the server name in the mail body which is affected by the alert. Currently it is only in the subject. EG: Raised on detail i the mail body contains the primary replica, the affected unreachable replica is only in the subject.
1 vote -
Long-running query Alert - time based parameters
I need to disable monitoring long running queries at night.
My proposal is that you could add new parameter to alerts
Time from - Time to which will exclude monitoring during this time.That will help to exclude ETL - ssis, and other long rununig queries which we set up at night.
6 votes -
Filter alerts by Comment
Add back in the filter options, the filter on Have/Doesn't have Comment.
Add the possibility to search by comment.Wold be great if there was some sort of "Tags" that you can apply to an alert and to filter based on those tags.
11 votes -
Notification
Generate Notification Per Alert (optional) and Show in windows
when Browser is Close.
And then Send Text Message To User Mobile Number1 vote -
Add an index to Alert.Alert on AlertType to remove index scan
Here's the index. It really helped speed up the system (monitoring 20 servers)
USE [RedGateMonitor]
GO
CREATE NONCLUSTERED INDEX [AlertType]
ON [alert].[Alert] ([AlertType])
INCLUDE ([AlertId])
GO3 votesClosing as it’s being tracked as a bug – thanks Phil!
-
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
-
Customizing alerts without loosing inherited settings
Would be great to have the possibility to customize alerts on lower levels without loosing the inerited "customizations".
Otherwise there is the need to "copy" all the exclusions made on higher or highest level to the level that should be customized...
In example : i want to add a keyword for a specific query on Database Instance without loosing all the exceptions made for backup and so on.7 votes -
Be alerted when a database approaches it's maxiumum file size
Whether or not autogrowth is enabled, I'd like to be alerted when a database approaches it's maximum file size.
1 voteHi Jason,
The ‘Database file usage alert’ will provide this sort of alert. See https://www.red-gate.com/hub/product-learning/sql-monitor/avoid-running-disk-space-ever-using-sql-monitor.
- Don't see your idea?