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.
43 results found
-
Add scheduling for monitoring suspension and resumption
Using Azure SQL Database in serverless mode with an auto-pause is a useful feature to save money when the db is not in use. SQL Monitor keeps the db from sleeping overnight.
Suggest addition of scheduling for Suspend/Resume operations, similar to alert suppression scheduling.
3 votesHi, you should be able to use the SQL Monitor API (see https://documentation.red-gate.com/sm/api) to schedule suspending/resuming monitoring for your Azure SQL Databases.
-
Password is blank when accessing the edit credentials in Monitored servers
Password is blank when accessing the edit credentials in Monitored servers for the monitored sql instance .
If any options need to be changed will need to update the password for the SQL and OS credentials1 voteThe password is intentionally blank. This is to prevent users that don’t have access to the server from changing these settings.
-
Add button to hide new grouping and use old grouping
Although the grouping seemed interesting at first, it means now our servers don’t fit on our screen anymore.
I would suggest adding a button to the "Group by" header that says "no headers" (or maybe a checkbox somewhere).
This button (or checkbox) would show the "old" layout again with the grouping on the left side as here: https://www.red-gate.com/wp-content/uploads/2019/10/SQL-Monitor.png
There is much more horizontal screen real estate than there is vertical; because of these new grouping headers we now need to scroll to see our DEV servers.
I am fully aware I can click the headers to minimize the content but…
3 votesHi Andy.
Thanks for the feedback. Groups can be opened and closed and the card sizes can be changed to control the number of instances visible. We feel that it’s important to show the group headings on the dashboard.
Thanks,
Neil
(Lead product designer – SQL Monitor) -
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.
-
Another Field to Change the Display Order of Servers on the Dashboard
On the dashboard, server instances are currently ordered by two fields - Name or Severity which is selected via a drop down list. Can we have another field - Sort ID (int), to give users another way to sort? This field can either be hidden or displayed.
1 voteHi Dean,
This is currently possible by setting an alias for an instance (hover over the righthand corner for a card, click the menu icon and select ‘Alias…’).For example you might set:
1_AliasA
2_AliasBSelecting ‘Order by Name’ in the drop down will then allow you to use this ordering within a group on the dashboard.
Alternatively you can pin instances to the top of the dashboard (hover over the righthand corner for a card, click the menu and select ‘Pin to top’).
I hope that helps.
Neil Turner
SQL Monitor design lead -
Every alert should be able to be cleared
I recently ran into an issue where a specific alert ("Monitoring error") could not be cleared. Support staff told me this is by design.
I thnik this is bad design. Every alert, no matter how serious, no matter how breaking, should be clearable.
Whatever the issue is, once I am aware it is up to me to decide whether I want to continue to be alerted or not. If I know I'll fix it later, or I know I won't (or can't, as was the case for me) fix it, then I want to clear it.
By not clearing an…3 votesHi Hugo,
I’m sorry to hear that you’ve experienced issues with this. There is a setting within ‘Configuration > Display settings’ (see screenshot) to not force errored instances to display red on global overview.
It sounds like this is the issue that you’ve experienced. If you activate this setting then monitoring errors will not behave in this way on the Global dashboard.
Neil Turner
(Lead designer – SQL Monitor) -
MONITORED INSTANCES
Hello good day
When you enter the Global Dashboard session, it stays loaded and shows the blank page.Annex image of the page.
1 voteApologies that this was overlooked when the problem was reported. We believe this bug was fixed shortly after and are closing this suggestion.
If you believe this bug is still valid, please raise it on the SQL Monitor Support Forum at https://forum.red-gate.com/categories/sql-monitor-7
-
Allow Groups to be created on Instance name rather than server name
For multiple instance hosts, each instance can have a separate functional purpose. However groups do not allow instance level granularity. It would be useful to have distinct instances from the same host in separate groups.
30 votesTags can be used to indicate functional purpose for instances. See https://documentation.red-gate.com/sm/adding-and-managing-monitored-servers/applying-tags-to-monitored-servers.
-
handle case insensitivity with regex
We can configure some alerts to be ignored based on names/objects that are matched using reguler expressions.
Regex is case sensitive, but to avoid having to put all possible combinations in the regex boxes, could that be handled internally by SQL Monitor - for example by uppercasing (or lowercasing) all text before comparing?1 voteHi,
SQL Monitor supports all standard .NET regex characters, and uses the IgnoreCase option. All regular expressions are therefore case-insensitive.
Thanks,
Neil Turner
(SQL Monitor product designer) -
Add Clear, Unclear, Read, Unread buttons to the end alerts list.
Add Clear, Unclear, Read, Unread buttons to the end alerts list.
I like to have 100 alerts per page and its very unpleasant to clear several alert that are on the end of the page.6 votesThe ‘Clear’, ‘Unclear’, ‘Read’, ‘Unread’ and ‘Add Comment’ buttons are pinned to the top of the alert inbox list. The buttons are therefore always available as you scroll down the alert inbox.
-
Classic Dashboard Mode
The new global dashboard is great but it is harder to read at a glance then the old dashboard. Please add in a classic dashboard option.
4 votesRefers to very old version of SQL Monitor (2016).
-
A Comprehensive Manual for SQL Monitor
Currently there is a serious lack of information about SQL Monitor and that's bad for everyone and not just the user base for DPA. Therefore DPA needs a head to toe, top-down comprehensive manual that details every single aspect of DPA from the metrics it captures to the settings it uses and every single function/feature no matter how insignificant needs to be documented in a single manual/guide. When complete there should not be any part of DPA that is not detailed in this manual. While I can see no reason for why something this comprehensive would not be made available…
1 voteFor SQL Monitor, in addition to the official documentation (https://documentation.red-gate.com/display/SM5/SQL+Monitor+5+documentation), there is a very comprehensive guide written up on SimpleTalk:
https://www.simple-talk.com/sql/sql-tools/sql-server-performance-troubleshooting-with-sql-monitor-5/
For DPA on the other hand, I think the good people of Solarwinds are better equipped than us Redgaters to document their tool ;)
-
removed an evicted node
I would like the ability to remove an evicted node from a cluster. As of today, we have one in such a state and there is no option to manually remove just that single node from "Manage Servers".
1 vote(reason: bug report)
Hi Matthew, SQL Monitor should automatically remove evicted nodes after a short period of time – if it doesn’t please contact support and we’ll do our best to resolve the issue
-
Specify databases for custom metric using wildcards
We have multiple databases for each of our clients - each type of databases uses the same schema and follows a consistent naming convention. For example:
XXXXMain
XXXXExtra
XXXX_ManagementYYYYMain
YYYYExtra
YYYY_ManagementI want to add a custom metric that only applies to "_Main" schema so in order to choose databases to collect from I need to specify each database explicitly. This proves challenging as the number of clients grows and we add more servers / instances to our environment.
It would be preferable if i could instead use some form of wildcard to specify databases…
4 votesA bit of an edge case that would make things a lot more complicated for all users
-
have help page on server where red gate installed . server can not get to internet
have help pages on server where red gate installed . server can not get to internet to get help info as it is secure site
1 votemuch of our help cross-references external sources, so an offline help would be less valuable (and increase the installer size)
-
Compact mode
The new "touch friendly" layout is annoying and wastes a lot of screen real estate. Please add a compact mode.
2 votesSorry, we and most users disagree
-
Option to display time zone with time display.
Example:
Long-running query Server1 2:05 AM (UTC-5)
Blocking Server2 8:15PM (UTC+2)etc.
Thanks
1 voteAll times are shown in accordance to the browser’s timezone
-
have the Time Range drop down keep it's selected value
There's a small bug in the analysis screen. When you choose a time range from the drop down list, it always changes the value to Custom. The dates update properly, the graph shows the right data, it's just the drop down always says "Custom".
Example in screen shots below, I choose 24 hours, the drop down says Custom (1 day). It should say "24 hours"
3 votesThanks for raising this – we’re tracking this as a bug internally. I’m not actually declining it.
-
Index on msdb..backupset
One of my servers has a db with many filegroups and does log backups every 5 min. For this reason the msdb..backupset table is very big and SQL Monitors query
SELECT DBNAME(DBID([databasename])) AS [DBNAME(DBID([databasename]]))], MAX([backupfinishdate]) AS [MAX([backupfinishdate]])], MAX([backupstartdate]) AS [MAX([backupstartdate]])], [type] AS [[type]]] FROM msdb..backupset WITH ( NOLOCK ) WHERE DBID([databasename]) IS NOT NULL GROUP BY DBNAME(DBID([database_name])), [type]reads ~3,500 pages per execution (CLUSTERED INDEX Scan) -> one of the TOP 10 queries (at least in the night :-)).
The following index…
1 voteSorry, we can’t add indexes to our users’ production servers to speed up our queries!
-
Latch Wait Time Explanation
In SQL Monitor 4.0, the explanation refers to sys.dmdboperational_stats which does not actually exist.
Should this be sys.dmdbindexoperationalstats?
4 votes(not actually declined, but we are tracking this separately as a bug)
- Don't see your idea?