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.
219 results found
-
I would like to see a better dashboard view
One where I can see a cumulative report of ALL of the instances being monitored with average totals for cpu/memory/disks utilization, across them all. Average success to failure ratios for Scheduled jobs (backups).
27 votesWe implemented a new global dashboard in the 5.2 release, which shows an overview of all instances on one screen.
-
Alert if any data collection of metrics values stops unexpectedly
For some reason our data collection stops every other week for certain metrics. Restarting the SQLMonitor-service will make the service resume collecting again.
As it is now we have to inspect each metric manually to identify problems.
I would like an alert if any data collection stops unexpectedly.3 votesThis feature already exists in SQL Monitor.
-
Multiple Maintenance Windows
I would like to be able to set two maintenace windows every day.
98 votesThanks for this suggestion. SQL Monitor 10 now allows teams to suppress alerts, or just their notifications, over certain periods using alert suppression windows. Multiple windows can be set-up. 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
-
Enable changing Alert levels on Clock Skew alerts
I would like to be able to change the alert level from high to medium or even low.
It would be nice if the alert level would be set depending on the skew size, so that for example low level could mean 5 second, medium at 10 seconds and high at 30 seconds.I would like to do this, since we receive the alert occasionally from our test server (is gets cleared rather quickly so it is no big issue for us).
7 votesThanks for this suggestion. Apologies for not updating at the time, but this suggestion was completed in version 8.0.10 in July 2018.
We will mark this as completed but please do let us know if you have any further feedback.
Kind regards,
SQL Monitor Development Team -
2 votes
Hi Ben,
Thanks for letting us know about this bug in our validation logic. It will be fixed in the upcoming version of SQL Monitor
-
is there fix in the works for IE10?
In order to see almost anything, need to put browser into IE9 compatibility and some features still not showing like current server stats
1 voteThe update has now been released. SQL Monitor will display a message above the product name banner when it next checks for updates.
Alternatively, you can get it direct from http://www.red-gate.com/dynamic/products/dba/sql-monitor/download then click the ‘Returning customer installer download’ link on right.
Please let us know if this doesn’t fix the issue for you.
Thanks
SQL Monitor Development Team -
occurrences
Please retain a "tombstone" that can be referenced to present a history of "Occurrences" for HIGH Alerts. Allow us an additional retention period so these don't hang around forever - but please don't limit the number of days, just a smallint would be good.
When Monitoring Fails and is cleared, the Occurrence disappears when DB maint nukes "old cleared Alerts". If the retention period is short, say 14 days, the history of occurrences is soon lost.
A "tombstone" would at least keep the occurrences for trending.
6 votesJust keep the alert data in the Purge settings indefinitely – it’s only the metadata of the alerts, none of the performance data, so are “tombstones” as you described
-
Monitoring error (SQL Server data collection) - SAVE THE ERROR LOG
When one of these occurs it is 99.999% likely that, in the middle of the night, I will NOT jump out of bed, fire up the laptop, connect to the SQL Monitor Server and look at the SQL Monitor Error Log IN THE 5 MINUTES I HAVE BEFORE THE ENTRY IS LOST! May I cite the "Description" tab in SQL Monitor: "If the alert is still Active, or it Ended within the last five minutes, you can find out more information about its cause..." So we, ANYONE THAT IS, has a mere FIVE MINUTES to react to this before "see…
8 votesCompleted in SQL Monitor 5.0.3
-
Increase user granularity and allow creating more than the 3 built in user accounts.
Increase user granularity and allow creating more than the 3 built in user accounts. For example, we have an offshore development team that would like access to their SQL instance, but can’t have access to any other instances. What I would like to do is to be able to create an account, assign permissions to that account against databases or instances, limiting the access they have to production systems. If we could get it to use AD integration rather than forms authentication as well as being able to set permissions granularly then that would be ideal.
86 votesSQL Monitor 5.0 introduces Active Directory integration with granular control over which user sees what. Please note that you will need to enable Active Directory authentication in order to make use of this functionality
-
Add an option to alias the server names.
In a multi-server environment it would be very helpful to be able to assign an alias to the server name. So at a glance you can see something like - 192.168.1.1 (Company A OLTP)
Merged idea: Longer descriptions for Servers, Databases etc
48 votesClosing this suggestion as the server alias work was completed in v5.2.2.
However, there is not currently a way to alias cluster/machine names, so if that is important please raise it as a new suggestion as we could look to address it if there is demand.
If you are experiencing problems with server aliases, please let us know via the support forums.
Thanks
-
..retry operations that fail during install/ initial connection to server. Such as at my server where DBCC TRACEON (1204,-1) failed. In that
..retry operations that fail during install/ initial connection to server. Such as at my server where DBCC TRACEON (1204,-1) failed. In that case, retrying would be good, to ensure that it is eventually turned on.
1 vote -
Order databases alphabetically in the Analysis view
In the analysis tab, when you select the metrics and the server, where there is a database list, the list of databases is not ordered alphabetically. It would be much easier to find the database you want to look at if it was ordered - especially on servers with lots of databases.
7 votes -
Identify head blocker in a blocking chain
It would be quite useful and timesaving if one could identify the head blocker for a blocked process (as done in SSMS's Activity Monitor, Processes tab). Otherwise when get a lot of blocked process alerts, you have to manually figure out the head blocker by analysing all the alerts.
79 votesThis work was completed in version 5 – apologies for the delay in updating.
If you view a “Blocking process” alert, clicking on the ‘Processes’ tab (next to the details tab) will show the head blocking process, followed by any blocked processes.
If this doesn’t meet your requirements, please let us know how we can improve this alert.
Kind regards
Adam -
Regarding Custom Metrics - allow us to either have the "Description" inserted into the email or give us another text field for annotating.
We have solution documents in a help desk application. I would like to have my error message emailed with a suggestion that the recepient reference the solution document for steps in resolving the problem.
4 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. For custom alert, emails now include description.
Thanks,
SQL Monitor Development Team -
Licensing Clusters
Since only one SQL server is active in an Active\Passive cluster, you should not require multiple Monitor licenses.
50 votesCurrently, we are offering a 50% discount for passive cluster nodes. We’ll continue to review our pricing structure over time.
Why do we charge money for passive nodes at all? Covering your passive nodes with monitoring is necessary to ensure that when a failover occurs, the passive node is in a healthy state, and the failover will be able to succeed. However, passive nodes don’t (usually) have complex performance characteristics, hence the discount.
-
Create an Iphone app with a heatmap for the alerts. As well as an improved Analysis screen where you can select/combine/mix multiple metrics
Create an Iphone/android app with a heatmap for the alerts. As well as an improved Analysis screen where you can select/combine/mix multiple metrics
31 votesClosing because this is multiple suggestions: The analysis screen request has been completed in SQL Monitor 3.3 – as for the mobile site, if you favour this please vote for: http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/3641809-provide-mobile-version-of-alert-monitoring-screen
Thanks
Daniel -
Identifiy the failed job steps when a job has failed
CONTEXT: When looking at a job failed alert, we would like to pinpoint why it has failed.
PROBLEM: SQL Monitor doesn't indentify the failed steps - we have to go to SSIS to get that information.
EXAMPLE SOLUTIONS:
• Add this information to the "Job failed" alert
• Provide a query to make retrieving this data more convenient136 votesThanks for this suggestion. Failed job steps are now listed in failed job alerts – this feature was completed in Version 7.1.6, released October 4th 2017 (apologies for not updating sooner).
We have marked this as completed – please let us know if you believe this needs to be reopened, or add a new suggestion if you would like to see a particular improvement.
Thanks,
SQL Monitor Development Team -
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 -
Custom Metric Order
Either allow an order to be defined for custom metrics on the analysis tab or at least order them alphabetically rather than in the order created.
3 votesWe’ve alphabetically ordered the custom metrics on the Analysis tab and this will go in the next release which we hope to have available later next month.
Thanks again for the suggestion.
-
Allow drilldrown capability for different resource areas
It would be nice to be able to see which sql statements or db users were generating the most CPU usage, RAM usage, and Disk IO. This would help us quickly identify bottlenecks on the system.
CLR statistics would be nice to have too since we have found that it can account for locking issues in certain circumstances.
5 votesResource utilisation per query can be seen in the top 10 queries view on the SQL Instance overview
- Don't see your idea?