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
716 results found
-
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
-
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
Update the password of the account with powershell module
I do not want to use the base monitoring account, to monitor the different databases. So I need to use a separate account for that. In order to regularly be able to rotate the password of this account, I would need the PowerShell module be updated with a function to update the password.
3 votes -
export metrics data to csv (or table) with configurable granularity and option to get cumulative data
The analysis page allows exporting data to csv for a certain metric, e.g., a database counter, but we cannot control the granularity nor whether data for all databases should be cumulative or not.
I would like to get data with the granularity produced by the 15 minute time range, i.e. seconds, but for a larger date range and preferably cumulative for all databases or a set of databases.
10 votes -
Security auditing
Monitor SQL Server login and database user activity to identify unused or anomalous accounts. Supports security audits, enforces the Principle of Least Privilege (POLP), and helps retire or restrict dormant or misused accounts.
The tool will collect and analyze login usage data across all servers and databases. It will:
Report accounts that have not been used within a configurable time period.
Identify accounts active in unexpected contexts (e.g., unauthorized hostnames or outside normal business hours).
Allow administrators to define thresholds or parameters for expected usage and generate alerts when violations occur.
2 votes -
See the last X weeks of User transactions/SQl statments ran on the server
Have a view in SQlMonitor that can be used to do a quick search on what querys a user has run on SQL Server over the last X weeks.
For our user case we would just need the data for the last two weeks but sure if storage allows user's would like to hold the data for longer.
This is to enable some auditing functionalty to quickly find what a user has ran for reporting.
e.g.
What did user1 run yesterday,
What was run and by who over the last hourThis could also help with finding performance issues.…
7 votes -
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
-
Activity monitoring for DDL & DML
Add an element that will track all DML/DDL activity within a SQL Server instance and log this to a tamper proof archive. If linked to performance trends this can corrolate performance to T-SQL executed against the instance.
This has scope for aiding with Compliance with PCI-DSS & SoX.
13 votes -
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 votes
- Don't see your idea?