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
-
Provide a direct link to the base monitor download
When installing updates, only the SQL Monitor web service link is initially provided. In order to get access to the SQL Monitor base monitor download one has to first install the the SQL Monitor web service. This process slows down upgrade time and extends the "broken state" time in a multi-base monitor configuration.
Please provide a direct link to the base monitor download without requiring an initial WebService monitor install.
4 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 -
be able to choose the actions during maintenance window.
During a monthly patch round along the servers, a restart or some downtime is mandatory. I want to be able to select the actions SQL Monitor will perform with the alerts triggered within that maintenance window. Most of the time I'm aware of the required Windows reboot, so I do not need an email telling me that the SQL Server was not reachable for a short period. So I would like to tell SQL Monitor not to trigger any alert during the maintenance window. (preferably a one-time maintenance window, see other suggestion)
22 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
-
Have audible alerts on SQL Monitor
It would be very helpful to have a configuration setting to make alerts audible (something like a beep or alarm ring). In the office we have a screen that displays the SQL Monitor where the alerts are only noticed when people look at the screen, which is not very often.
An audible alert of 'red' alerts would prompt us to action them straight the way.
32 votes -
Collecting custom metrics for multiple databases at the same time
ATM, a custom metric can return one value, but sometimes collecting the metric for one database takes the same amount of time as collecting it for all of the databases.
Having a multi-database metric (maybe something that returns a database id -> value map (as a two col table)) would be especially useful if it takes a long time to collect the metric (in my case it takes nearly 30 secs to collect it).
12 votes -
Under Estate section: display last date/time server and/or instances on each server were restarted
I want to know what SQL Server Services are running/stopped on each server and be able to alerted if said servers are stopped.
11 votes -
Use base monitor service user account to authenticate with vcenter
When monitoring a vcenter deployment, it would be nice if the base monitor service could just delegate the credentials it is running as rather than entering them in the username and password boxes inside sql monitor.
9 votes -
Manage Scheduled SQL Monitor Reports from one overview page.
It's easy to set up a new report and schedule for SQL monitor reports. But once schedules are created it's difficult to manage them.
Have an overview page that would allow you to see all that has been scheduled .... giving options to:
1) Delete individual schedule (e.g. following server decommission or server no longer monitored).
2) Edit individual report schedule ... e.g. change time / frequency and for a particular type of report change the target server for that report ... i.e server replaced, being able to move report from reporting on original server report created for to…1 vote -
I want to be able to document in SQL Monitor why an alert is set a certain way.
On the alert configuration screen for any alert, at any level I would like to see a comment type box where I can enter in the box the reason the alert is set as it is.
For example if I have disabled the backup overdue alert for a particular database I would like to be able to save that reason in this comment box. Or if I have changed the disk space usage for a particular drive on a server different than the default I want to be able to document the reason why.
I want to see this box…
21 votesThank you for this suggestion, it makes sense to want to record why certain configuration changes have been made.
We released this enhancement in version 8.0.10 (in July this year – apologies for delay in updating this suggestion).
I will mark this suggestion as Completed, but please do reply if you have any further feedback.
Thanks,
SQL Monitor Development Team -
Sort or Filter Monitored Servers
In Configuration -> Monitored servers I would like to sort and filter the servers and have the grouping functionality applied to this screen. This would make it easier to find my server that I want to put a maintenance window on.
38 votesMarking as completed - the Monitored Servers page now includes filtering based on server name, tags and status.
-
show sql related windows event log entries
Rather than going through all Windows event log entries looking for SQL related events on every monitored server, it would be good to have them displayed on the server screen along with the SQL Error log entries.
1 vote -
Be able to monitor Basic Availability Groups. Currently Basic Availability Groups are not supported
Be able to monitor Basic Availability Groups. Currently Basic Availability Groups are not supported
30 votes -
A Comprehensive Manual for SQL Monitor
Currently there is a serious lack of information about SQL Monitor and that's bad for everyone and not just the user base for DPA. Therefore DPA needs a head to toe, top-down comprehensive manual that details every single aspect of DPA from the metrics it captures to the settings it uses and every single function/feature no matter how insignificant needs to be documented in a single manual/guide. When complete there should not be any part of DPA that is not detailed in this manual. While I can see no reason for why something this comprehensive would not be made available…
1 voteFor SQL Monitor, in addition to the official documentation (https://documentation.red-gate.com/display/SM5/SQL+Monitor+5+documentation), there is a very comprehensive guide written up on SimpleTalk:
https://www.simple-talk.com/sql/sql-tools/sql-server-performance-troubleshooting-with-sql-monitor-5/
For DPA on the other hand, I think the good people of Solarwinds are better equipped than us Redgaters to document their tool ;)
-
Export a Databases report to Excel including Name, Availability, Transactions/sec and Database size for any time period
In SQL Monitor I want to export a Databases report to Excel including Name, Availability, Transactions/sec and Database size for any time period. You can see this data and screenshot it, but it would be much more professional, useable and positive for management if I could deliver it in Excel instead of combining screenshots.
1 vote -
Provide AAD authentication mode to connect to Azure SQL server apart from username and password authentication.
Provide AAD authentication mode to connect to Azure SQL server apart from username and password authentication.
Because if Azure SQL is set to AAD authentication only for security reasons in any organization, username and password to add new Azure SQL server/DB under SQL Monitoring doesn't help.
36 votes -
Monitor Backups LSNs in Always On Availability Groups
With Always on Availability Groups, Error is... Log backup for database "XXX" on a secondary replica failed because the last backup LSN from the primary database is greater than the current local redo LSN. And SQL Monitor cannot check for this. I would like to see if SQL monitor can catch it before the Azure Backup Vault fails to backup every 15 minutes.
3 votes -
Remove a user/group from SQL Monitor
It would be desirable to be able to remove a user and/or group from SQL Monitor.
At present, there are no options to manage them, only add them.7 votes -
Access rights on database level
CONTEXT: We want to give our developers access rights to there databases alerts (long running queries, blocking processes, deadlocks ...).
PROBLEM: Access rights are only allowed on sql server instance level. Database1 should only see dev team1, database2 should only see dev team2. This is not possible at the moment.
11 votes -
“Longest Running Queries” in Redgate SQL Monitor Reports
I need to show more “Longest Running Queries” in Redgate SQL Monitor Reports. The layout of the report is also a bit awkward, it seems if everything does not fit into the report.
See attachment.10 votes -
Utilize in SQL Monitor Analysis or Reports pages any SQL Server counter available in PERFMON.
For instance BRENT OZAR has an excellent method to diagnose memory pressure. The counter in use is SQLServer: Memory Manager – Memory Grants Pending which is not available.
If Memory Grants Pending is averaging over 0, queries can’t even start because they can’t get enough memory. You may have queries that have incorrect memory grants, or you may just desperately need more RAM.
30 votes
- Don't see your idea?