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
741 results found
-
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
-
Custom metric: alert when value changed
I want to be alerted if someone creates or deletes a database. The metric itself is easy (select count(*) from sys.databases - executed for the master DB on all servers).
But in the alert setting I can only define that it should trigger if the new result is abover or below a set value but not for value changed (compared eigther to the previous value or the "baseline").
So I have to create two metrics / alerts for DB drop (below) and create (above) AND have to define / modify the number of databases as alert threshold for…
19 votes
Daniel Rothig
responded
-
Azure Service Principal authentication (Client ID / Client Secret)
It would be highly beneficial for us if Redgate Base Monitor supported authentication via Azure Service Principals using Client ID and Client Secret across all Azure products, including Azure SQL Database and Azure SQL Managed Instance.
We are restricted to using Service Principals only and cannot rely on user-based authentication. Support for SPN authentication would allow us to fully automate the onboarding of new Azure SQL Databases and Managed Instances via Terraform, using our own modules, and register them in Redgate without any manual interaction. This would significantly improve scalability, consistency, and security in our Azure monitoring setup.
15 votes -
Trigger a device check-in via powershell
We use powershell scripts to shut down and start SQL services before and after maintenance. The scripts create a suppression window before and after as well. However, if the suppression window is removed too soon after the services are up, alerts are still fired because SQL Monitor thinks the server is still down. We workaround this by adding a delay in the scripts, but it's annoying to sit and wait for it. I'd like to be able to force SQL Monitor to check in with the server before removing the alert suppression window.
3 votes -
Make "Source" hyperlink in Alert take you to the specific date time on the Server Overview Page
If I click on the "Source" Hyperlink in alert, this opens the server overview page for the relevant server, however, the displayed time frame is the default (24 hour period ending at the current time)
It would be helpful if the server overview page opened at the date / time of the alert as it is highly likely after clicking the hyperlink, that you are going to want to view the point in time of the alert
3 votesWe're currently reviewing this suggestion as part of general usability improvements.
-
See on the overview page incase of a AlwaysOn or a windows cluster which node is the active\primary
We have several windows clusters and AlwaysOn clusters. It would be very helpful to see on the overview page which node is active.
It can be easily done by adding a color to the AG icon on the tile.
I know that it can be seen on the cluster overview but I really think it belongs on the Overview page.
29 votes -
For SQL Permission currently there is only permission for users in the server level displayed . Can the permission level in the database
For SQL Permission currently there is only permission for users in the server level displayed . Can the permission level in the database level be able to display
1 vote -
Alert suppresion window by specific date every month
We do our maintenance on scheduled windows on the 20th and 21st day of every month, including weekends.
Currently, it is not possible to set up such a recurring alert suppression window.
Can you add this to the Redgate Monitor alert suppression settings?3 votes -
One-time Maintenance Window
We perform updates to (nearly) all our Windows servers on our domain monthly. I'd like see the ability to set a maintenance window and have it removed once it has passed, rather than having the maintenance window fixed to set time every week.
One use case is "silencing" alert generation while investigation is in progress
71 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
-
Quick view of whether Agent is up on all monitored servers
If I go to the Configuration > Monitored servers tab, I can quickly see if all SQL Servers are up and running. It would be nice to also be able to quickly see if all SQL Server Agent services are up and running.
3 votes -
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 -
Add more information to alert email
It would be nice to have more information sent into the alert email, instead of having to login into the monitor to check details. I am not sure if there is a way to do this already. If there isn't - this would be nice to have.
For e.g: This doesn't divulge which query. If the query was mentioned, it would help.
ID: 59
SQL Server: (local)
Machine: (Machine Name)
Alert type: Long-running query
Level: None
Time raised: 8 Mar 2012 12:44 PM (UTC-05)
Time ended: 8 Mar 2012 12:50 PM (UTC-05)
View full alert detail147 votesSQL Monitor V 3.3. has now released. This release contains improved subject lines and message bodies of alert emails to help you quickly understand problems before logging in to SQL Monitor.
Thanks,
SQL Monitor Development Team -
Filter to search the SQL Agent Jobs by server name
Filter to search the SQL Agent Jobs by server name . Currently only can filter by job name
1 vote -
ssis
SQL Monitor currently does not monitor the execution of SSIS Packages.
It would be extremely useful if SQL Monitor would monitor the execution of the SSIS packages like it does the execution of SQL Jobs
E.g.
Alert if the SSIS Package Execution Fails
Alert if the SSIS Package is taking longer than normal to Execution
Alert if the SSIS Package fails to start41 votes -
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.
-
ADD Support for GCP Cloud SQL (MSSQL managed instances)
As Google Cloud Platform increases their market share and adds features such as managed instances for Microsoft SQL Server, it would be great to have the ability to monitor those as well.
4 votes -
Raise an Event Alert when a database is dropped
There is currently no alert when a database is dropped or detached from a server. SQL Monitor should create an Event alert to record when the drop happened. Obviously this might be intentional (e.g. the alert you have now that records a database is offline), but it might be accidental or unknown to the DB team (E.g. a vendor drops their database).
Because it will (hopefully) be an intentional action, and quite probably no plan to ever re-attach the database, the alert should be an event alert rather than a normal alert (the normal alert would never end)
A…
6 votes -
Clone a report and change the server name globally within it
I have crafted a report for my servers. I understand there's some behind-the-scenes scripting I can do to replicate a report, but the GUI could provide a "Clone Report" option, allowing me to change the server name reference on all the widgets. Sure would make deploying one extra server easy.
1 vote -
Enhance query tagging in monitior overview.
Add extra functionality to query tagging: allow colour coding of tags, add comment text to tagged queries, enable query tagging in postgresql (I am current using postgresql monitor v14.0.34 with server deployed SQL server, SQL Azure and PostgreSQL Aurora).
Is there any timeline for this?
3 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.
11 votes
- Don't see your idea?