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.
- or
721 results found
-
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
-
Add an option to schedule when custom metrics run against a given database.
Currently when a custom metric is executed can only be controlled by the frequency (daily, hourly, etc).
My primary purpose is for daily. I would like to schedule the time of day a daily metric is run per database, or at least server. The custom metrics I pull back are time sensitive so controlling when the metric is returned is a must.
A more advanced option to this would be going beyond simply choosing the time of day for daily runs, but rather the ability to build a custom schedule of run times. An example might be Custom Metric…
57 votesThe ability to schedule when daily custom metrics run was added in version 13.0.56.
To do so, when adding your metric, simply set the collection frequency to collect data every day and you can choose the time of day you'd like it to run.
-
Filter "Blocking Process" alert by User or Application or Database
We frequently get high-severity "Blocking process" alerts via email for a SSRS database that I'd like to ignore. We sometimes get so many alerts that the new SQL Monitor sends, "You've received more than 30 of these alerts in the past 24 hours so we're going to stop sending them for a while." Unfortunately the alerts caused by the SSRS database mean our Inbox is full of noise and we miss our important application database alerts.
Please add the ability to filter which User/Application/Database cause these alerts to be raised, similar to some other alerts that support Regular Expression filters.
14 votes -
Include SQL comments in Top Queries search
I use Entity Framework Core to interact with a SQL Server database, which comes with the ability to "tag" queries with extra searchable information for troubleshooting purposes.
This extra information is in the form of SQL comments, like so:
-- SPARK: PartyRepository.PartySearch
It would be very valuable to be able to search for this data, but unfortunately it appears that comments are excluded from Top Queries search, even though the data is there in SQL Monitor query data.
8 votes -
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 -
Error Log Section - Under the instance screen add a search function similar to Databases section where we can search for keywords like fail
Error Log Section - Under the instance screen add a search function similar to Databases section where we can search for keywords like failed logins. This will speed up the process to look for something specific rather than moving through pages looking for that one error.
1 vote -
Identify and alert on heap fragmentation
Currently SQL Monitor does not have a way to identify and alert on heap fragmentation. I suggest you add this to the product.
I know having a heap is usually a bad idea and that heap maintenance is a pain (rebuilding a heap also rebuilds all the nonclustered indexes on it, SQL Server doesn't release a page of a heap table, and doesn't use free space in previously used pages unless you are doing deletes with TABLOCK hints), but there are some valid use cases for heaps.
14 votes -
It would be nice to be able to exclude names of databases to be backed up instead of un clicking them one at a time .
It would be nice to be able to exclude names of databases to be backed up instead of un clicking them one at a time .
This should be similar to the long running queries where you have the option to exclude.1 vote -
monitor microsoft dynamics nav related stuff
connected users
etc3 votes -
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.
-
DataRetention setting and Performance troubleshooting data per technology because needs may be different
Possibility define DataRetention setting and Performance troubleshooting data per technology because needs may be different between sqlserver, postgres , mysql, etc, and improve disk space of seacrh engine queries.
7 votes -
Add link to disk details on Server details page.
From the Estate - Disk Usage tab we can select the specific drive to get usage details for that disk.
When you navigate to a server from the Overview there is a section that shows the Disk Usage at a high level, but no links to drill into the specific disk.1 vote -
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.
-
Poll the SQL Monitor Targets on Demand.
When we make a configuration change to address an Alert. By polling the TARGET on demand after making change, we want to make sure that the alert is addressed.
4 votes -
Identify if virtualization hosts are congested
CONTEXT: We are monitoring virtual servers that share a VM host.
PROBLEM: If host resources are overallocated, the physical resources can be contended even if the virtual resources aren't. This is not easy to spot in SQL Monitor.
EXAMPLE SOLUTIONS
• Add virutal host counters for VMware and Hyper-V to the analysis graph: CPU, Memory, disk...
• Integrate with a Virtualisation monitoring solution to connect the dots more easily100 votesWe have now released version 7.1.0. The collection of VMware metrics is out of beta.
https://documentation.red-gate.com/display/SM7/Adding+a+VMWare+host
If you have suggestions for any improvements you would like to see, please begin a new suggestion with as much detail as possible, so we can consider where best to focus our efforts.
Thanks,
SQL Monitor Development Team -
Allow Groups to be created on Instance name rather than server name
For multiple instance hosts, each instance can have a separate functional purpose. However groups do not allow instance level granularity. It would be useful to have distinct instances from the same host in separate groups.
30 votesTags can be used to indicate functional purpose for instances. See https://documentation.red-gate.com/sm/adding-and-managing-monitored-servers/applying-tags-to-monitored-servers.
-
Have a free-text notes field for each server\instance
A notes field can be used for any useful information such as business contacts, service hours or documentation links, etc.
16 votes -
Understanding what caused the Diskspace alert
When viewing a disk space alert, it would be very useful to view the disk space usage for the drive the alert is raised for?
Ideally I'd like to to be able to get to the page: the Estate | Disk usage | [and filtered for the Specific Server: Drive:]
I understand that on the detail page of the server, you can see the growth of the databases for the selected time period, but its not always db files that cause the alerts.
3 votes -
Only receive emails for the most important alerts
CONTEXT: I review alerts raised by SQL Monitor in order to stay on top of my server activity, and I also have alert emails enabled in order to respond quickly to issues.
PROBLEM: I only want to receive emails for issues that require immedate action or are otherwise noteworthy. I don't want to change the alert thresholds because for my triage, the "lower-priority" alerts are still interesting - but they shouldn't be sent as emails.
EXAMPLE SOLUTIONS:
• Send emails by alert priority - e.g. medium and high only
• Alter the default alert behaviour to only send emails for…240 votesWe have released version 9.0.10 of SQL Monitor which includes the ability to choose to receive notifications for only high level alerts, or only high and medium alerts (or the default of all severities) globally.
https://documentation.red-gate.com/sm9/release-notes-and-other-versions/sql-monitor-9-0-release-notesWe realise this is long overdue, as we’ve struggled to provide one solution to the different problems contained in this suggestion. As such, we’ve decided to break this down into different problems we can look to address.
We believe this release delivers the solution to the problem originally suggested, to be able to send email notifications for alerts with a Medium or High priority, so will mark this as completed. However, please do raise new suggestions for anything you feel hasn’t been addressed by this release, so we are able to consider each one as we continue to improve SQL Monitor.
Thank you for your patience,
SQL Monitor Development Team -
Datawarehouse Database for older data
There should be an option to transfer older data to a datawarehouse database and still seamless be accessible from the Red Gate Monitor tool. This way the primary database can be small and quick in normal day to day use.
2 votes
- Don't see your idea?