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.
219 results found
-
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 -
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
-
be able to choose the actions during maintenance window.
During a monthly patch round along the servers, a restart or some downtime is mandatory. I want to be able to select the actions SQL Monitor will perform with the alerts triggered within that maintenance window. Most of the time I'm aware of the required Windows reboot, so I do not need an email telling me that the SQL Server was not reachable for a short period. So I would like to tell SQL Monitor not to trigger any alert during the maintenance window. (preferably a one-time maintenance window, see other suggestion)
22 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
-
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.
-
12 votes
-
get a report on my server inventory
For MSFT licensing purposes, I would like to have a report from SQL Monitor across all my registered servers that tells me enough information to work out my licensing requirements. For example, which version of SQL Server is installed, which edition, how many CPUs it is installed for, any information about the Windows licensing, whether it is on a virtual machine (and how many sockets, etc) ... you get the idea.
Currently, the reports only allow for a very limited amount of information to be added, and they have to be in summary tiles or charts. Maybe this could be…
33 votesThe SQL Server Licensing page within the ‘Estate’ section (see attached) shows licensing information for monitored servers.
-
export selected alerts
it would be nice if we could export selected alerts (for instance full deadlocks related information) to forward to our "partner" so they can analyse the problem.
21 votesThanks for this suggestion. SQL Monitor 10 now makes it easier to create and share reports of recent types and severities of alert. 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).
Thanks,
SQL Monitor product team
-
deadlock
Add the ability to customize deadlock alerts. I want to able to ignore alerts if the deadlock was on table XXXXX or produced by stored procedure YYYYYY
or have different alert levels depending on the database and table.45 votesThanks for this suggestion. We will close this now as there have been no new comments since we released the new filters.
However, please do raise new suggestions for anything you feel hasn’t been addressed, so we are able to consider them as we continue to improve SQL Monitor.
Thanks,
SQL Monitor Development Team -
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.
-
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 -
set the default email recipient per level
I'd like to be able to override the default email recipient "per level", in the same way alerts can be configured.
This would make it much easier to manage in a case where monitoring responsibilities are delegated for a specific server or group of servers.
16 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 -
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 -
Historical graph of how one query/Stored procedure is performing now compared to 2 months back
Choose from top 50 of worst queries and check what is the difference now compared to the stats in the past in graphical view and create custom reports with graphical view
30 votesThank you for this suggestion. A graph showing a query’s history was added to the Server Overview Top Queries table in Version 7.1.11 in November 2017. This allows you to see a query’s performance over time, view its execution count, duration, reads, and writes, and the points in time a query’s plan changed.
We will close this suggestion, but please do raise another suggestion if you have other specific improvements you’d like to see.
Kind regards,
Adam
SQL Monitor Development Team -
improve speed when navigating through the GUI
It takes quite sometime to navigate across the screens on V6.0 would be a welcome relief if we have performance improvement on the UI
1 voteThanks for raising your suggestion. We’ve made a number of performance improvements over recent releases. Whilst we will continue to make improvements, hopefully this meets your expectation regarding this suggestion, so I will close this issue.
If you have any specific issues or suggestions around performance, please reply to this or raise another UserVoice suggestion so we can investigate.
Thanks
Adam -
I want to be able to document in SQL Monitor why an alert is set a certain way.
On the alert configuration screen for any alert, at any level I would like to see a comment type box where I can enter in the box the reason the alert is set as it is.
For example if I have disabled the backup overdue alert for a particular database I would like to be able to save that reason in this comment box. Or if I have changed the disk space usage for a particular drive on a server different than the default I want to be able to document the reason why.
I want to see this box…
21 votesThank you for this suggestion, it makes sense to want to record why certain configuration changes have been made.
We released this enhancement in version 8.0.10 (in July this year – apologies for delay in updating this suggestion).
I will mark this suggestion as Completed, but please do reply if you have any further feedback.
Thanks,
SQL Monitor Development Team -
Sort or Filter Monitored Servers
In Configuration -> Monitored servers I would like to sort and filter the servers and have the grouping functionality applied to this screen. This would make it easier to find my server that I want to put a maintenance window on.
38 votesMarking as completed - the Monitored Servers page now includes filtering based on server name, tags and status.
-
Add AM PM or military time to alert times since they aren't listed
Process login time: 3 Nov 2016 09:00
Query start time: 3 Nov 2016 09:00
Would either want them in military time, or listed w/ AM PM so I know when they occurred1 voteClosing as this has been available since 6.0.7
You can find this option on Configuration > Display settings. Please let us know if this is not working as you expect.
Thanks -
See more detail on Failed Agent Jobs
Present the detailed Step error message for Agent Job Failures. Currently shows the Job message, but not the error from the step that actually failed. This requires the user to open SSMS and drill down to find what caused the failure, instead of getting a head start from SQL Monitor.
53 votesThanks for the suggestion and votes. This was completed in version 7.1.2. I will close this – please let us know if you believe there are further improvements we could make.
Kind regards,
SQL Monitor Development Team -
to see 24-hour clock affecting times on graphs
I see the setting and it is set and in most places it is used but not in the time axis on graphs in analysis.
6 votesWe have just released version 7.1.3, available from Check for Updates, which fixes this issue.
Thanks for the suggestion, and for your patience,
Adam
- Don't see your idea?