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.
182 results found
-
Skip warnings on Database Snapshot Backups
I'm seeing warnings about backups not getting done on snapshots. Obviously it's not looking at the type.
16 votesFixed in SQL Monitor 5.0.2
-
Disk Names in Overviews and Analysis
Disk Names in Overviews and Analysis
Hello,
I think that it will be usefull to have a same disk names in Overviews and Analysis as they are shown in the system in Disk Management.ServerData (F:)
ServerLogs (G:)
Server_System (H:)Not only F: G: H: as they are visible now in SQL Monitor.
Thank you.15 votesThis has been implemented in SQL Monitor 4.2
-
Add "Re-send Email" for an Alert
Some emails find black holes. Need option in the "Actions" dropdown to re-send an Alert email. Please pop-up the addressee dialog so we can direct/redirect to recipient list and add a custom subject to help us segregate the email into an email thread for discussion/attention.
15 votesVersion 9.0.7 has now been released and adds the ability to manually send an alert as an email notification to any addressee.
We will mark this as completed, but please do raise a suggestion if you would like to see further improvements.
Thanks for your patience,
SQL Monitor Development Team -
Single sign on
Make it so that I can add an AD group to the settings, then enable AD Auth in IIS and not be prompted for username and password.
LDAP settings should not be needed.15 votesSupport (at) red-gate.com can provide you with instructions how to disable SQL Monitor authentication in order to fall back on IIS authentication, which supports Single Sign On.
-
Include drive letter in subject and body of disk space alert email
It would be helpful to know which drive (by letter) the alert information detail is about in the email. The drive letter should be included in the subject line such as Disk space | ServerName | E:\ as well as in the body of the email. This information helps identify the problem drive without having to go to SQL Monitor for that information.
15 votesThis enhancement will be in the next version of SQL Monitor
-
Stop being nagged about maintenance windows - because they don't fit our operation
The nag about "you haven't set up any maintenance windows" is something you could allow us to turn off. Period.
SQL Monitor's simplistic feature does not tie in with the way Rackspace performs their patching, so the feature is useless and the nag is annoying as it keeps on coming up and we keep on dismissing it.
Please, give us a "Turn of maintenance window reminders globally" option - it can't be that hard to do...
15 votesHi,
SQL Monitor 7.1.11.9625 has been released to check for updates and contains a fix for this bug (SRP-11455 fixed an issue where some informational messages were not dismissible).
Please do let us know if you continue to see this issue. Thanks for your patience.
Adam
SQL Monitor Development Team -
Add an alert to monitor failed logins.
The sql logs show failed logins, could we have an alert for this?
15 votesHello,
We are happy to announce that ‘Failed SQL Server logins’ metric is now available. Please install it from http://sqlmonitormetrics.red-gate.com/failed-sql-server-logins/
Thanks,
SQL Monitor development team -
Improve the performance of the user interface
When I access the user interface (hosted on IIS) it is quite slow to use.
It frequently takes several seconds between clicking on something and things happening.It does not appear to be a resource problem, as both the IIS/Monitor server and the database server has plenty of resources to spare.
14 votesI’m marking this as “closed” seeing as performance improvements will be indefinitely be delivered, so it would never make sense to consider this work “done”.
-
In an AlwaysOn environment with backup preferences is set to Primary, I do not want the alert for Backup overdue and Log backup overdue
is it possible to remove backup alert on not readable databases in an AlwaysOn environment
14 votesThis has been completed in SQL Monitor 5.0.2
-
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.
-
Add the ability to create new alerts
Instead of limiting the available alerts to a pre-defined list, allow users to create new alerts and threshold metrics based on customized queries. In my opinion, this is about the only glaring omission in the current version of sql Monitor.
13 votesIncluded in SQL Monitor v3.0
-
Use the Base Monitor Service account to query Active Directory when using AD Credentials
We are using a Managed Service Account to run SQL Monitor so we don't have to manage passwords. However we still need to have a regular domain account to query AD because there is no option other than to specify a username and password.
What would be great is to have an option to use the base monitor service account to query AD instead of having to specify a username and password.
This would work in a similar way to what already exists when setting up credentials for the server you monitor, where you can choose to connect to the…
12 votesAD (LDAP) Auth can now be configured using the base monitor service account, this includes GMSA accounts. See https://documentation.red-gate.com/sm12/adding-sql-monitor-users/authenticating-with-active-directory
-
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.
-
Add more narrow time intervals in Reports
We are using the reports part of SQL Monitor to show them on a TV screen in a proactive way and we find this very helpful.
Now we have a question, would it be possible to include more narrow intervals like 6 h, 2 h and 30 min in the reports?
Because even if we lower the reports to 12 h and has auto refresh every 1 min it’s kind of hard to see and react on the spikes in the graphs.
An example can be seen in the attached fil - Batch request/sec report, it’s hard to spot the…12 votesThanks for this suggestion.
Version 9.0.8 has been released which has added 30 minutes, 1 hour, 2 hours and 6 hours to the Reports time filter values
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 feedback you might have.
Thanks,
SQL Monitor Development Team -
be able to schedule monitoring suspend or maintenance on instance level
We have a cluster with two instances. The databases on these instances are restored on different times during the day.
I want to be able to schedule suspend of monitoring during these different time periods so that one instance is suspended and the other is not. Or put them in maintenance mode on the instance , not on host machine level.12 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
-
12 votes
-
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 -
Email reports monthly
I just upgraded to SQL Monitor V7 and it's great being able to have custom metrics in reports. We have a metric that records how many customers are notified in a monthly process (runs overnight on the 1st of the month). We need a way to send out this report via email on the 1st of every month (current options are only to send it weekly)
10 votesThe ability to email reports on a monthly schedule has now been released.
Please make a new suggestion if there are any areas of the reporting you think could be improved.
Kind regards,
SQL Monitor Development Team -
Pagerduty API/WebHooks and Better Notification channel
We are in a high secure payments network, we do not wish to open ports used for email (smtp) however we would like integration with Pagerduty.
Please create a generic web hook interface where the payload can be fully customised or direct integration via there API.
I would like the option to pick what communication channel is used based on the severity of the alert
Alert Rule XXXXXX
H M L
Email
Pagerduty X
Slack X10 votesCustom Webhook messages now allow the Webhook message sent to be customised. See https://documentation.red-gate.com/sm/metrics-alerts-and-notifications/configuring-alert-notifications/setting-up-webhook-notifications/custom-webhook-messages for full details.
-
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
- Don't see your idea?