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.
218 results found
-
Recognize Low Alerts visually in overview
Low Alerts show as blue dots on the Latest Alerts panel, but in the overview they show Green like Healthy.
Especially when showing Small Tiles (we monitor 60+ instances) they do not stand out from Healty ones (see the attached examples).For that reason I dont use many Low Alerts.
It would be more consistent to use blue in the overviews also.4 votes -
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.
-
Job Duration Unusual: Threshold higher than 100%
Currently when configuring different threshold in the "Job Duration Unusual" alert we are limited to a maximum of 100% of the baseline. So for example if I wanted an High alert when a job is 5 times the baseline it's not currently possible, I'm limited to 2x.
7 votesAs of version 10.0.9, it is possible to enter thresholds over 100% for the job duration unusual alert.
-
Show Job name instead of ID in query related alerts
This is a follow-up on: https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/1865305-show-job-name-not-job-id-value-for-job-related-ale
The job ID was replaced by the job name in Job Failing, Job Duration, Job Cancelled alerts but I would like to see the same for query related alerts, specifically Long-Running query but the comments in the other item also mention Block Process and Deadlocks.
12 votesThis is available in v 13.0.54.
-
See on the overview page incase of a AlwaysOn or a windows cluster which node is the active\primary
We have several windows clusters and AlwaysOn clusters. It would be very helpful to see on the overview page which node is active.
It can be easily done by adding a color to the AG icon on the tile.
I know that it can be seen on the cluster overview but I really think it belongs on the Overview page.
29 votes -
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
-
Monitor Azure Managed Instances
Redgate Monitor still does not appear to fully support Azure Managed Instances. As our primary business is about to move across solely to Azure Managed Instances, this is now a seriously high priority for us.
We are heavy users of Redgate Monitor for our business, so this is now starting to be become a bit of a worry for us.
46 votesWe're now supporting Azure Managed Instances.
If there is something you think we're missing from this feature, please let us know at SQLMonitorFeedback@red-gate.com
-
Wire up Notifications to MS Teams (in addition to Slack)
Wire up Notifications to MS Teams (in addition to Slack)
12 votesNotifications can be sent to Microsoft Teams using Webhook notifications. See https://documentation.red-gate.com/sm/metrics-alerts-and-notifications/configuring-alert-notifications/setting-up-webhook-notifications/custom-webhook-messages for an example custom message to use for Microsoft Teams.
-
Don't check Agent status for Express Edition
Whenever I add a server to the monitoring that is Express Edition, I get alerted that the SQL Agent service is not running.
Well d'uh. It's Express Edition. The Agent service cannot run on it.Instead of always giving me this alert and then having me go in and disable it for yet another server, why not change the logic to not raise this alert at all when the edition is detected as Express?
3 votesThis was fixed in version 9.0.10 released on May 1st https://documentation.red-gate.com/sm9/release-notes-and-other-versions/sql-monitor-9-0-release-notes
Please update to the latest version and let us know if that does not solve the issue for you.
Thanks
SQL Monitor Team -
Commit to supporting Linux in some way
Linux is the future of sql server. If you've not deployed SQL 2019 AlwaysOn on Kubernetes I'd highly suggest you do. The install is lightning fast compared to clunky Windows installers of the past. I really feel like Redgate is taking a slow poison by not getting on this sooner. Honestly most of the metrics in sql monitor come from the internals of sql. All we really need from Linux is probably free disk space and cpu.
18 votes -
Add 2017 CU14 to Estate view
Currently SQL Monitor shows the latest SQL Server 2017 version to be CU13 yet the latest is CU14. This should show the latest version.
1 voteHi Mark,
Thanks for bringing this to our attention. This has been fixed and should now resume automatically updating once per day as long as the SQL Monitor website is still running.
If you need to manually update, you will find the instructions here: https://documentation.red-gate.com/sm9/estate/versioning-and-patching
Thanks again,
SQL Monitor Development Team -
SQL Agent jobs with a 'cancelled' status are incorrectly flagged as 'Job failing' in the Alert Inbox
With Always On related SQL Agent jobs, an initial job step is added to check whether the target database is Primary/Secondary on the cluster node. If 'Primary', then continue with subsequent job steps, if 'Secondary' then stop and do not attempt any further job steps. In circumstances where the job is stopped the last run outcome is shown as 'Canceled' - however, SQL Monitor shows these particular status jobs as 'Job failing' in the Alert Inbox. The job hasn't really failed and has been stopped in a controlled way. Can the status of these job be correctly identified please?
11 votesThanks for this suggestion, and for the additional comments which helped us decide quickly what solution to implement.
Version 9.0.13 released 23rd May includes a new Job cancelled alert (off by default) and stops the existing Job failing alert being raised for cancelled jobs.
We hope this meets requirements and will mark it as closed, but please do raise further suggestions for any improvements you would like to see.
Thanks,
SQL Monitor Development Team -
In the Estate view you are 2 CU's behind for SQL Server 2016.
Currently SQL Monitor shows the latest SQL Server 2016 version to be SP2 CU4 yet the latest is SP2 CU6. This should show the latest version.
1 vote -
Support SAML for Web Single Sign-On (SSO)
SQL Monitor should be able to support Enterprise Single Sign-On using SAML. Is this on the roadmap?
57 votesMarking this as completed - support for OpenID Connect (OIDC) was added in v11.2 in June 2021 which enables SSO (and hence multi-factor auth) via a wide range of authentication providers.
-
Have more flexibility in Maintenance Window Schedules
We do OS and SQL Server patching one Sunday a month for dev and QA and the following Sunday for production. I think if maintenance windows scheduler looked more like setting a schedule in an agent job it would be perfect for setting these kinds of maintenance windows. And if we could drive setting / modifying maintenance windows via T-SQL that would be even better.
7 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
-
suppress emails during maintenance window
Allow the ability to suppress all alert emails during a maintenance window. Right now we have ~65 SQL servers and during windows when the OS team is patching and rebooting the servers we can receive 100's of emails as the servers go up and down. It would be great if we could set a schedule or at the very least a single use window when emails don't get sent.
2 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
-
Read Only users should not view Analysis page.
When restricting "Read Only" users they can still see all servers when viewing the "Analysis" page. I think this should also exclude any servers not explicitly defined in the Managed Users page.
1 voteThanks for this suggestion. This has been fixed in Version 9.0.6 (although I would suggest updating to the most recent version, v9.0.7 at time of writing) when we fixed the issue SRP-11791: AD user can see names of servers they don’t have access to fixed for Analysis and Backups.
Hopefully this completes this suggestion.
Thanks,
SQL Monitor Development Team -
Hide Nonrelevant Metrics
The addition of Azure metrics has made the selection of metrics within the analysis page less efficient; as there are now twice as many items to pick from, many with the exact same name. In my environment, there are no Azure databases being monitored, so these metrics only serve as a clutter. It would be nice if metrics were hidden that aren't applicable to the list of monitoring SQL Servers.
12 votes -
Remove wait type VDI_CLIENT_OTHER from the wait graph
SQL Monitor shows high waits for SQL Server 2016+ systems that implement availability groups configured for automatic seeding. Since a multiple system processes called VDICLIENTWORKER are left running by design. This wait tends to be the top wait in an AG configuration and erroneously indicates a problem that does not really exist.
10 votesThanks for this suggestion.
Version 9.0.8 has been released and now excludes VDI_CLIENT_OTHER from the waits
https://documentation.red-gate.com/sm9/release-notes-and-other-versions/sql-monitor-9-0-release-notesWe’ll mark this as completed and welcome any further suggestions you might have.
Thanks,
SQL Monitor Development Team -
Monitor SQL instances running in AWS RDS
Enable SQL Monitor to add AWS RDS instances as monitored servers
101 votesAmazon RDS SQL Server instances are now supported from SQL Monitor 11.
See https://documentation.red-gate.com/sm11/adding-and-managing-monitored-servers/adding-servers-for-monitoring/add-amazon-rds-sql-server for more details.
- Don't see your idea?