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.
186 results found
-
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.
-
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.
-
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).
-
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.
-
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.
-
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).
-
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).
-
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.
-
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 -
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
-
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.
-
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.
-
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
-
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.
-
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 -
Job duration taking too long - triggering WHILE job is still running
CONTEXT: If a job is taking a long time (outside of some predefined threshold), we want to be alerted about it. That’s often an actionable alert – we could decide to stop the job, we could let the users know that report XY will be late as a consequence etc. One step further is being alerted on the job STEP level as well.
PROBLEM: Current alert “Job duration unusual” is triggered AFTER the job completes, if it meets the alert's criteria. We need an alert to trigger WHILE the job (or job step) is still running, but the criteria is…
118 votesAs of v10.0.4 the Job Duration Unusual alert is raised while jobs are still running, so marking this as completed. Thank you very much for the feedback.
-
PLEASE PUT BACK THE OPTION TO SELECT MULTIPLE ALERTS
is anyone as frustrated as I am about the removal of selecting multiple alerts and adding a comment in one swoop?
At least make it an admin option so that it can be turned on or off
We are wasting so much time every day trying to clear alerts and it is unproductive
26 votesThanks for letting us know this was important to your workflow.
Version 8.0.23 has now been released and includes the return of the ability to add comments 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 so will mark it as completed.
-
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 -
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
- Don't see your idea?