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.
219 results found
-
I want to be able to apply tags to SQL servers in SQL Monitor to better sort
I want to be able to create more groups that a server is a member of. For example, I want to see all Production servers, or all servers associated with a specific team or department. I can group by only 1 item now. But, if I could tag servers, that would allow me to be more granular in my reporting.
We do the same thing in VMware now. We can still use the same grouping structure that exists today, just create the ability to provide multiple tags to each server/instance.
10 votes -
Webhook notification for HIGH only or High/Medium only
Just like you can do with email notifications, would like the ability to send WebHook notifications for only HIGH, or ONLY HIGH and MEDIUM alerts.
10 votesThis is available from version 13.0.52 (February 7, 2024)
Added option to send webhook notification for "All Levels", "High and Medium" or "High Only" alerts.
-
Sort filter for manage server screen.
We have many development and test servers we want in our server list but not fully monitored. They were added to Monitoring after the production boxes, so they are on top of the list.
9 votesYou can use Groups to create filtered views of the Global Overview screen – improvements to that screen will mean that you won’t need to use the Manage Servers screen to inspect your system in the future.
-
Group expensive queries by query hash
I would like to have a section where the query execution counters are aggregated per query_hash.
We use Dynamics Ax ERP and in order to avoid parameterisation issues we enabled passing company literals instead of parametres. This now leads to a single expensive query "taking up" as many of the top 10 query slots as there are companies executing this query.
Ideally it would be possible to show the top 10 query hash data on the top level and then drill into each sql handle and view the query statistics and history there.
9 votes -
SQLMonitor consider the SQL Server cluster name as an instance
SQLMonitor consider the SQL Server cluster name as an instance
9 votesThis can be set within Display settings ('Failover Cluster Name Display') for a SQL Monitor configuration.
-
Comment multiple alerts at once
I would like the ability to add the same comment to all of my selected alerts before clearing them in the Alert Inbox.
9 votesHi,
Thanks for this suggestion.
Version 8.0.23 has now been released and includes the return of the ability to add a comment to multiple alerts.
This was initially removed while developing the ability to group alerts, and it’s taken us longer than expected to reintroduce – apologies for the inconvenience this caused.
We hope this solves this suggestion. We’ll mark it as completed, but please do reply if you have any further feedback.
-
search Top Queries
I have a process that reports on stored proc outliers. When I go to SQL Monitor, it is very difficult to search the top queries to find the particular stored proc.
For instance, if I do a ctrl+f and search for "I.Invoices", the search may find that snippet in "hidden" areas (in the dropdowns) but I cannot tell where the found items are.
A query syntax search of the top queries would be extremely helpful.
9 votesQueries can now be searched. This is available from version 11.2.10.
Query search is still in preview. Please send any feedback to SQLMonitorFeedback@red-gate.com.
-
Show prefered/active node on cluster
When runnning a database instance on a cluster it would be helpful if you could see on which phusical machine (node) the database instance is active on. It would be very usefull if that information was shown on the global overview page.
8 votesThis can be seen on the Cluster overview page, in the instances grid – activeness and preferredness differ per FCI
-
Allow filter on Global Overview
E.g. exclude 'Ended' (but not yet cleared) alerts. (Gives an overview of the current state)
8 votesWe believe improvements to the dashboard in 5.2 make this no longer valid. Please open a new suggestion if you would like to see further improvements.
-
Monitoring error (SQL Server data collection) - SAVE THE ERROR LOG
When one of these occurs it is 99.999% likely that, in the middle of the night, I will NOT jump out of bed, fire up the laptop, connect to the SQL Monitor Server and look at the SQL Monitor Error Log IN THE 5 MINUTES I HAVE BEFORE THE ENTRY IS LOST! May I cite the "Description" tab in SQL Monitor: "If the alert is still Active, or it Ended within the last five minutes, you can find out more information about its cause..." So we, ANYONE THAT IS, has a mere FIVE MINUTES to react to this before "see…
8 votesCompleted in SQL Monitor 5.0.3
-
When using Windows authentication I want the read-only account/group option.
I like the windows authentication but it doesn't have the read-only option. I would like to be able to add users and AD groups where I can limit the servers, but also make the data read-only, just like the options when not using Windows Authentication.
8 votesApologies for not updating the status of this suggestion. We have supported this since version 6.0.17. When adding an AD user or group, you can now choose whether that user should be a standard or read only user (or an administrator). So you can do this, and can also choose the permission level for each individual user, rather than having to define it for the system as a whole.
Thanks for your patience,
SQL Monitor Development Team -
"CLEARED" alerts button should be renamed to "CLEAR".
On the alerts screen, there is an option to select alerts. If you want to clear the alerts selected you hit the button labeled "CLEARED".
Having the button marked "CLEARED" is confusing because it implies that the button is a filter rather than an action. It should be labeled "CLEAR" so you know you are performing an action.8 votesThanks for this suggestion.
We agree the labels were confusing so this was fixed in version 8.0.2 in March (apologies for delay in updating) when the new inbox was released. The button now reads ‘Clear’ as you suggested.
Thanks again,
SQL Monitor Development Team -
Relative-day maintenance windows
Rackspace maintenance days revolve around, for example, "Default week - Wednesday - 02:00 to 04:00", where "default week" is established in the service contract. That can change to early-week or (I forget the name) "late-week".
Current SQL Monitor Maintenance Windows are wholly inadequate to record a "Default week is 2nd week of each month, maintenance on that week's Wednesday, at (the time period)".
Without this, my PagerDuty Alerts go berserk during maintenance windows, and shy of having someone go and suspend monitoring at 2 in the morning and remember to turn it back on, it just keeps on sending out…
8 votesThanks for this suggestion. SQL Monitor 10 now allows teams to suppress alerts, or just their notifications, over certain periods using alert suppression windows. Please see What’s New in SQL Monitor 10 for more details (https://www.red-gate.com/hub/product-learning/sql-monitor/whats-new-in-sql-monitor-10).
We hope this meets requirements and will mark it as completed. Please raise further suggestions for any improvements you would like to see.
Thanks,
SQL Monitor product team
-
Allow option to exclude Integrity Check Overdue Alert for read only databases
An alert configuration option should allow
a database status to be checked when querying for last good integrity checks and read_only databases could be excluded from the alert. Even when integrity checks are performed on read only databases, the last checked date is not updated resulting in unnecessary alerts in most cases.8 votesThanks for this suggestion.
Version 9.0.7 has now been released and adds the ability to exclude read only databases from Integrity Check Overdue and Fragmented indexes alerts.
We will mark this as completed, but please do raise a suggestion if you would like to see further improvements.
Thanks,
SQL Monitor Development Team -
Ability To Alias PaaS (SQL Azure) Instances
You currently can alias IaaS instances but the option does not show up if it is a PaaS instance.
8 votesThis has been added now. Please let us know if you have any further feedback about this at SQLMonitorFeedback@red-gate.com
-
Order databases alphabetically in the Analysis view
In the analysis tab, when you select the metrics and the server, where there is a database list, the list of databases is not ordered alphabetically. It would be much easier to find the database you want to look at if it was ordered - especially on servers with lots of databases.
7 votes -
Enable changing Alert levels on Clock Skew alerts
I would like to be able to change the alert level from high to medium or even low.
It would be nice if the alert level would be set depending on the skew size, so that for example low level could mean 5 second, medium at 10 seconds and high at 30 seconds.I would like to do this, since we receive the alert occasionally from our test server (is gets cleared rather quickly so it is no big issue for us).
7 votesThanks for this suggestion. Apologies for not updating at the time, but this suggestion was completed in version 8.0.10 in July 2018.
We will mark this as completed but please do let us know if you have any further feedback.
Kind regards,
SQL Monitor Development Team -
7 votes
-
Allow filtering out certain types of wait statistics (e.g. to remove benign ones)
As the title says. See Paul Randal's query for an example: https://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/
Give us the option to control exactly which types are filtered out of results.7 votesThese are specified in the SQL Monitor database, as an entry in [settings].[KeyValuePairs]
-
Monitor SQL Server 2014 failover clusters with Cluster Shared Volumes
There is currently some trouble with monitoring a windows failover cluster with CSV - specifically, the error log is unreachable because base monitor apparently connects to the wrong network name to access files.
7 votesAs mentioned in the comments, this was completed in v5.2.7
(relevant issue was SRP-10451: Cannot retrieve log files for users who monitor SQL Server installed on a clustered shared volume).Apologies for not updating this at the time.
Thanks
SQL Monitor Development Team
- Don't see your idea?