Welcome to the Redgate SQL Monitor feature suggestions list. Tell us how we can improve SQL Monitor by voting on these suggestions or by submitting your own ideas.
This is the easiest way to make an impact on SQL 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 — often the SQL Monitor team will initially stay quiet about new suggestions to see what you have to say!
If you have any questions visit the SQL Monitor forum.
182 results found
Configure disk space alerts at individual disk level
I'm able to get away with some disks running closer to capacity than others. (not all drives hold SQL!) it would be nice to be able configure alerts to reflect this and have the email alert display which disk is causing the problem.4 votes
This feature already exists in the product.
Analysis | Allow for custom versus comparisons
It would be useful to compare a custom time range between different days such as 08:00 - 10:00 for this Monday and the Monday before.6 votes
This has now been implemented in v3.4.
SQL Monitor Development Team
Disk Names in Overviews and Analysis
Disk Names in Overviews and Analysis
I think that it will be usefull to have a same disk names in Overviews and Analysis as they are shown in the system in Disk Management.
Not only F: G: H: as they are visible now in SQL Monitor.
Thank you.15 votes
This has been implemented in SQL Monitor 4.2
Alert Details - Performance Data - Top 10 expensive queries - Bug
The "Top 10 expensive queries" tab under the "Performance Data" section of the "Alert Details" view shows "Totals" data by default even though the "Avg. per execution" radio option is selected by default.
This can be confirmed by changing the selection to totals and then back to average.
Observed in Web Version 18.104.22.1686 votes
Hi, thanks for pointing this out to us. It has been fixed in version 3.3
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 votes
We 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 votes
This feature already exists in SQL Monitor.
Multiple Maintenance Windows
I would like to be able to set two maintenace windows every day.98 votescompleted · AdminNeil Turner (Admin, Red Gate Software) responded
Thanks 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.
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 votes
Thanks 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.
SQL Monitor Development Team
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 stats1 vote
The 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.
SQL Monitor Development Team
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 votes
Just 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 ya!". May I respectfully say, "that's idiotic and unrealistic" - who of us is glued to our SQL Monitor Alerts like that!?
Please, put these log entries SOMEWHERE ELSE so we can actually see what triggered the Alert in the first place! Better still, put ALL associated Log Entries as collateral data with the Alert!
I had a 3-minute outage shortly after midnight over a weekend. Despite sending myself an email to my personal account, do you think I leaped up? Not having a company smart phone means I don't have text alerts. Perhaps the RG assumption is that all DBAs on Production Systems have such devices...?
So, for the dinosaurs among us, and for simply doing a good job of reporting errors of this kind for everyone, please snag the data and show it me in the Alert itself.
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 votes
Completed 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 votes
SQL 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 etc48 votes
Closing 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.
..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 votes
This 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.
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 votes
SQL 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.
SQL Monitor Development Team
Since only one SQL server is active in an Active\Passive cluster, you should not require multiple Monitor licenses.50 votes
Currently, 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 metrics31 votes
Closing 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
- Don't see your idea?