Suggestions
Welcome to the Redgate SQL Monitor feature suggestions list. Tell us how we can improve SQL Monitor by voting on these suggestions or by submitting your own ideas.
This is the easiest way to make an impact on SQL 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 — often the SQL Monitor team will initially stay quiet about new suggestions to see what you have to say!
If you have any questions visit the SQL Monitor forum.
201 results found
-
Change "Blocking Processes" icon
To quicker navigate through the menus when collapsed, better distinct icons would be helpful.
2 votes -
Geeting listener name in AG info
Would it be possible to get the SQL Server AlwaysOn AG listener name in the SQL Monitor dashboard?
3 votesThis is available from version 12.1.16.
-
Add alias with powershell module
We install our sql server automatically via powershell, so we also add them there to the monitoring. We would like to safe us work, by giving the server a custom alias while adding to the monitoring as it can be done through the website.
6 votes -
Fix Alert Screen to not move up and down
When you are working on the alerts tab, once you click the checkbox and clear alerts the green check shows up that the alert was successful. But that makes the page move up and down, so if you are already trying to click other alerts the page is moving and you click the wrong thing.
1 vote -
Allow custom scopes in OpenID Connect authorization request
Currently SQL Monitor only sends the scopes "openid profile".
In my usage the "groups" scope is needed as well.Make this parameter configurable to support any number of custom scopes.
3 votesYou can configure OpenID Connect scopes by running a script on your SQL Monitor repository. See Authenticating with OpenID Connect documentation (https://documentation.red-gate.com/sm11/adding-sql-monitor-users/authenticating-with-openid-connect) for more details.
-
Seconds left out in the error log time
the seconds not displayed in the error log time . This gives some difficulty to check some event using Redgate .
1 voteSeconds will appear in the error log time on the Server Overview page from v11.2.4.
-
If a job fails the alert should not be cleared until the job has run successfully again
If a job fails the alert should not be cleared until the job has run successfully again. It doesn't make sense clearing the alert just because a job has been restarted. The alert should remain active until a completely successful run.
4 votesThis has been changed and now works as described here. In SQL Monitor since 11.2.13 (released 26 Sep 2021).
-
Azure AD modern authentication for SQL Monitor
Be able to login into Redgate SQL Monitor using AAD with multi-factor authentication
13 votesThis has been possible since v11.2, by authenticating using OpenID Connect. That version was released June 2021 (apologies for it taking until now to close off this UserVoice issue). See here for more details: https://documentation.red-gate.com/sm/adding-sql-monitor-users/authenticating-with-openid-connect.
-
filter webhook notifications
I would like to be able to filter which webhook notifications get sent out via an option in alert settings - notifications.
e.g. for each alert, we have the option to send an email to a default address, an alternative address, or don't send an email for this alert.1 voteAs of SQL Monitor 11.1.8 Webhook notifications can be enabled and disabled for an alert type within alert settings (see screenshot).
-
Azure ad intergration
My wish is that my users can sign-in with azure user account.
19 votesThis can be achieved by using OpenID Connect authentication with Azure Active Directory. See https://documentation.red-gate.com/sm/adding-sql-monitor-users/authenticating-with-openid-connect and https://docs.microsoft.com/en-us/azure/active-directory/fundamentals/auth-oidc for more information.
-
Be able to identify Base Monitors by a user friendly name in a MSP Solution
For example in the "Manage Servers" screen, when using a MSP Solution, it's only possible to view the actual names entered on the Base Monitor Configuration page.
Without having to resort to a DNS work-around for this issue, it would be nice to add the option to use a "Display Friendly name" instead of the name of the Base Monitor Server.
That way, people who don't know which individual server belongs to which individual client or base monitor, can easily identify them based on their displayname.2 votesThis is now possible from version 11.0.4
-
Webhook notifications need to be configurable at an alert level
While Webhook notifications is a cute idea, it has no value to me if I can't customize what alerts get it. Please add a Webhooks column to the individual alert settings.
20 votesAs of SQL Monitor 11.1.8 Webhook notifications can now be enabled and disabled for alert types.
This can be done within the alert settings page for each alert type (see screenshot).
-
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.
-
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
- Don't see your idea?