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.
765 results found
-
Activate the alert suppression on a database level
In our production environments we'd like to be able to suppress all alerting on a database level.
For instance, if a database is to be retired, it will go into an automatic offline state for 2 weeks before it's actually deleted. During this period SQL Monitor keeps returning with a High Alert level warning that the database is not available.
Yes it's possible to manually disable this alert just for this database. However if we want automatic ticketing to kick in on this alert type we'd need to able to create a maintenance window before hand in order to prevent…7 votes -
Top 50 Queries should ignore queries that runs with explicit "waitfor"
The query that runs with explicit "waitfor" should not be included in the top 50 query report.
7 votes -
Email queuing
Basically, I would like email to queue up in SQL Monitor. In the event an email fails to send (account locked out, mail server down, etc), having the email just fail to send is not the desired result. When problems are resolved, the email should send.
For example, lets say IT is doing scheduled maintenance on the email server and during that window one of the SQL instances shuts itself down due to an error (for arguments sake, lets say out of disk). SQL Monitor will see it go offline and try to send out the alert but fail because…7 votes -
Ability to not monitor/show certain queries in the TOP 50 list.
The top 50 query view in SQL monitor is showing the query that is running on the service broker queue with explicit waitfor statement. In our server these waitfor is 5 min and we have 100 threads that runs for 5 minute and wait for the messages in the queue.
The query monitor shows these query as the top slow performing queries, but in reality these are not slow queries, they are just waiting for messages in the queue. We need a way to not show up the queries in top 50 list, so the queries that are actually slow…7 votes -
Monitoring of Windows Server Failover Cluster
We would like to have the option to monitor Windows Server Failover Clusters as an integrated part of SQL Monitor. Considering that over 50% of our infrastructure is implemented as Always On High Availability Groups, operating on WSFC, we would like to have monitoring and alerts if something on WSFC level goes wrong such as a node disconnecting, a File Share Witness going down, errors reported in the WSFC console etc... At the moment, if something happens at WSFC, such as loosing quorum due to a file share witness going down, we are not being alerted and will not know…
7 votes -
AWS FSx drive status
In our company we are using AWS FSx drives for our SQL Server databases. The FSx drives are not real drives, they are more like a shared folder, I'm wondering if there is a way to add those drives on SQL Monitor so we can check disk space and get alerts. AWS has been adding more features for FSx drives to be used on SQL Servers. Right now the only way to monitor that is using AWS console or alerts, which are not very friendly and only available for some system administrators.
7 votes -
Testing the Availability Group listener(s)
If an Availability Group listener is not working for any reason (like no DNS resolution), but the ressource is still up in the cluster, SQL Monitor will not raise any alert.
Could you add a specific test for SQL monitor to test the connection using the availability group listener(s) and raise an alert if not successful?
7 votes -
Add database changes details based on the zoom range
In the "Databases" section when selecting one, we would like to have a list of the database changes that happened based on the "zoom range" period.
Right now I'm thinking based on the SQL Server error log
Example:
1 - Database Status changed. Online/Offline/Read-Only/Read-Write/etc
2 - Compatibility Level changed - This will be great to co-relate some situations with the CL change.
3 - Page Verify
EtcIn the end, any message that uses any of these texts:
SELECT * FROM sys.messages
WHERE text like '%Setting database%'This includes query store changes
7 votes -
contained
Add support for Contained Availability Groups (CAG) in SQL Server 2022
This is actually a feature that broke with the new version. There is no ability to monitor SQL Agent Jobs.10 votes -
In AzureSQL, I would like Redgate Monitor to not "keep awake" systems which are set to "sleep".
Within AzureSQL you can set SQL Servers to be Serverless and also to "sleep after" a time window. This means you can save money for systems which are not heavily used.
I think Redgate Monitor needs to have a "light touch" mode for such systems where it will firstly check the config and say "ok, this server is asleep, I dont need to look at it" before reporting maybe in the infomration status "system asleep". When the system wakes up, it should monitor as normal.
This is a cost saving exercise since, after adding Redgate to our Legacy AzureSQL servers,…7 votes -
Add alias to rest api
The rest endpoint api/v1/monitored-entities should include the alias field. It would present as an empty string if the monitored entity does not have as an alias and filled in if an alias has assigned to the monitored object.
7 votes -
Pull Server Certification Info
Would like to request enhancement to be able to create a report to pull Server Certificate info, and have an email sent out to notify us 30/60/90 days before hand when it will expire. Pull details like the certificate issuer, validity period, and common name from the server certificate installed on the target machine.
7 votes -
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 -
Support Individual query monitoring in Azure SQL Database
This sounds like a useful feature. I wish it was available for my environment.
7 votes -
Add more visibility to captured system processes
A view of all system processes is available whenever an alert is clicked. It would be nice to get the same view of system processes with their CPU and memory consumption for a specified time even of there is no alert to click on at that time.
6 votes -
Add day name(sat, sun, mo etc) of date to analysis screen
Add the day name of date to analysis screen.
Currently only the date and time is displayed on the graph lines dots.
6 votes -
In the Analysis tab, it would be better to have an option to change the font from grey (very hard to see) to black/dark blue or something
In the Analysis tab, it would be better to have an option to change the font from grey (very hard to see) to black/dark blue or something
6 votes -
Allow trace to be set at the individual alert level and severity
SQL Trace can highly impact the performance of the server. I can't benefit from trace right now as it's set on any alert to launch a trace.
Other monitoring tools, for instance Sql Sentry, allow the individual alert to be configured with settings for trace.
For example: A long running job might benefit from a trace, while a "dbcc checkdb " hasn't been run in a long time should not trigger a trace. This increases storage and server load for no benefit.
Please look into allowing traces to be configured based on the alert AND the severity level defined on…
6 votes -
I wish the mouse wheel did not automatically modify the date scale in the Analysis graph.
I can't count the number of times I have unintentionally messed up a graph with the mouse wheel. It is quite annoying to me.
6 votes -
Expand lower section of overview window
I would like the ability to expand the sections in the lower portion of the overview window or break them out into separate windows. For example, when viewing the Top 10 Queries or Waits it is very difficult because there is not enough room. Also because the individual tabs scroll separately from the main window, scrolling is a pain. The top graph section shrinks, but it still takes up too much screen area. Being able to break out in individual sections or expand them to fill the screen would be very helpful.
See attached screenshot for an example.
6 votes
- Don't see your idea?