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.
216 results found
-
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
-
Add the calling module/process in "Blocking process" alerts
In the Details tab of a Blocking Process alert the process name of the blocking process is included. It would be very useful if this was included in the "Blocked process" info on the processes tab. This would assist us in working out what it is that the blocked process is trying to access because the SQL fragment is often too generic to be useful.
13 votesFrom version 12.1.28 this information is provided.
-
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.
-
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
-
12 votes
-
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
-
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 -
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 -
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.
-
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.
-
Permission granularity on server/cluster objects
It would be great to assign a set of users in a security group a read only or any other access to a particular cluster node instead of the full cluster. It is a managed environment with shared responsibilities, so it is essential to have this granularity in permission management.
12 votesAvailable from version 14.0.14 (July 24, 2024).
Admins can now grant users access to specific cluster nodes. Previously, access could only be granted to the entire cluster.
-
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 -
Periodically or manually request "check disk size" for when SAN Drives are reconfigured on the fly
We resized the log drive from 100GB to 170GB. SQL Monitor shows 100GB until the base monitor service is restarted.
Periodically, i.e., once a day, re-check disk sizes.
Perhaps on the configuration page, show a button to "re-evalute server base characteristics", which would include disk drive sizes.
10 votesDisk capacity is re-evaluated regularly (every 10 minutes or so)
-
Receive an alert for the process that is blocking not the process being blocked.
We recently upgraded our SQL Monitor to version 5.1 and it appears there has been a change in the Blocking process metric. Before the upgrade we received an alert about a process that was blocking and after the upgrade it appears we receive an alert for each of the processes being blocked. We have set the threshold for 90 seconds and if there are three processes that are 30 seconds that total the 90 seconds, we receive an alert. However we don’t want to receive an alert for the 30 second blocked processes. Is there a way we can understand…
10 votes -
suspend
Hi,
I think it's very important to show Suspended status of a monitored host/instance should be shown in dashboard.
I had suspended monitoring on an instance and forgot to resume so I've missed monitoring for a while.
I suggest to show the state of monitoring (Active or Suspended) maybe graphically/iconic, in the dashboard and Server overview pages10 votes -
Sortable System Processes Grid
On the Alert Details page, it would be nice if I could sort the grid under the "System Processes" tab. It currently shows processes sorted alphabetically by name. I would like to sort it by CPU or memory utilization to see top consumers. I currently have to copy the data to a spreadsheet to do that.
10 votesThis suggestion, allowing the system processes grid in alert details to be sortable, was completed in Version 6.0.18 – apologies for not updating at the time.
Thanks for the suggestion – please reply if you feel it needs further attention.
Kind regards
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 -
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
- Don't see your idea?