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
-
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.
-
Be able to customize sql agent job failure notifications turn on/off at the specific sql agent job level
Be able to customize sql agent job failure notifications turn on/off at the specific sql agent job level.
7 votes -
Email Reports as an attachment
I know that it is possible to email report on a schedule basis.
But it only sends a clickable Link to the report.Is it possible to send a PDF as an attachment on a schedule basis?
16 votes -
Group expensive queries by query hash
I would like to have a section where the query execution counters are aggregated per query_hash.
We use Dynamics Ax ERP and in order to avoid parameterisation issues we enabled passing company literals instead of parametres. This now leads to a single expensive query "taking up" as many of the top 10 query slots as there are companies executing this query.
Ideally it would be possible to show the top 10 query hash data on the top level and then drill into each sql handle and view the query statistics and history there.
9 votes -
Report Email Attachment Name
Name the pdf attachment something other than "AttachedReport".
The report has a title and a date which could be used to name the attachment. That would really simplify the process of saving the reports for baseline purposes.
e.g. "Server2ProcessUtilization20180308.pdf"3 votesReleased in SQL Monitor v13.0.5.
-
Notifications to Slack Only
Would be nice to have the option to send some alerts to slack only, at the moment the only option is to send to slack and email, or don't send to either.
7 votes -
Database File Usage Alert - Autogrowth
Database File Usage Alert : Please consider autogrowth! So far, this alert is of no help.
3 votesSQL Monitor v7.1.18 added an option to disable database file usage alerts when autogrowth is enabled. The setting can be found on the configuration screen for the database file usage alert.
Thanks for helping us improve this feature with your suggestion.
SQL Monitor Development Team
-
Setting Maintenance Window via API service
That would be very nice if there as an API service which we would use to set maintenance window for a given sql host or a group of hosts.
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. Windows can be set-up using SQL Monitor, or via the API. Please see the example Scripts within Configuration for more details.
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
-
Allow the pinning of availability groups to the Global Dashboard
I'd like to see the status of my AGs on the Global Dashboard without having to find them inside the server. Would also nice to see stats on latency on this widget.
6 votes -
SQL instances which are part of Availability Group does show if it primary or secondary in Global Dashboard
When SQL instances which are in Availability Groups are being monitored, the global dashboard lists both the primary & secondary node.
However though it does have 'AG' badge but it does not say which is primary or secondary.
While looking at the SQL monitor it will key that we know upfront which is the primary instance and also when alerting it should say primary or secondary in the subject line.48 votes -
Exclude specific alerts from SQL SERVER ERROR LOG ENTRY alerts
We have certain tools (mainly infosec related) that generate a lot of entries in the SQL server error log as part of their normal operation creating a lot of alerts. The only way to identify these and thereby determine that they are 'expected' is to go into each alert individually and mark it as read. The ability to ignore certain errors based on error number, severity or message would add a lot of value to this feature.
47 votes -
display unlicensed servers in different color
We started with RedGate Monitoring and added all our SQL Servers. As a result we consumed too much licenses. Although there's a warning on the top of the screen for this, the unlicensed servers are reporting 'healthy' which is a little tricky (especially for non-dba it'ers) because you don't know the state.
I like to see the unlicensed servers in a different color ( for example gray) to see a better reliable overview
6 votesUnlicensed servers are now shown as grey on the global dashboard.
-
Add a "Check for updates" link in the About section
Alternative for when you've clicked away the "new version available" notification
3 votesHi,
We have now added check for updates to the About section in version 7.1.16.
Thanks for the suggestion. I’ll mark this as completed now, but do let us know if you feel it should be reopened.
Thanks
Adam
SQL Monitor Development Team -
Notifications support for Microsoft Teams
Just like Slack (Webhook) notification support, it would be great if SQL Monitor could send notifications to Microsoft Teams.
106 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 -
Link executions of top 10 queries
I had an issue with a query that runs slow every other day. For a specific slow day I could find it in the top 10 queries. I'd like to be able to easily compare the days when it was previously executed . I did manage this by opening a new tab to select the fast day - the query was hard to find as there were many other queries in the top 10 on the fast day. I'd like to be able to lock in on a specific query and monitor the server/query stats at the time/duration of previous…
5 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 -
Please remove the 20 character size limitation from the Alias feature
Given that actual server named instances can be longer than 20 characters (even if they are truncated on the display), it makes no sense to limit an alias to 20 characters. Please significantly extend this limitation.
3 votes -
Missing database name in blocking session alert
When I receive an alert about a blocking session, it does not tell me the database. The mail starts with e.g.
Blocking Session ID: 93
Number of blocked descendants: 1
Total blocking duration for all descendants: 00:03:02
Blocking SQL fragment: CREATE PROCEDURE [dbo]...In the subsequent blocks (blocked sessions) it shows the corresponding database name, but only after much of scrolling, when the block cames from a long procedure (some with > 1000 lines).
So please add the database name to the blocking session part too.
5 votesThanks for the suggestion. Version 7.1.3 has now been released and improvements include adding the database name to the Blocking process alert.
Kind regards,
SQL Monitor Development Team -
Monitor a failover cluster in Azure
I have two failover clusters in Azure using ClusterSharedVolume storage, migrated from terrestrial clusters.
I've been using SQL Monitor to monitor all aspects of these clusters but now I've migrated to Azure, the monitor can't connect (I believe it's to do with the inability to ping the cluster load balancer in Azure).
I'm sure, as more and more of us migrate to cloud services, that covering an Azure cluster would be most welcome.18 votesSQL Monitor versions 7.1.6 and above support SQL Server Failover Cluster Instances and AlwaysOn Availability Groups hosted in Azure.
There are lots of ways in which Azure clusters can be configured, so If you’d like to suggest how we could improve the feature, please drop us a line at sqlmonitorfeedback@red-gate.com
Thanks,
Adam -
Use (Group) Managed Service Account Credentials for Server Monitoring
Allow the use of managed service accounts (MSA and gMSA) as credentials when monitoring servers.
Given the high-level permissions required to fully monitor servers, this would provide a higher level of security to match.
48 votes
- Don't see your idea?