Suggestions
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 votesThis 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 votesThis has now been implemented in v3.4.
Thanks
SQL Monitor Development Team -
Disk Names in Overviews and Analysis
Disk Names in Overviews and Analysis
Hello,
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.ServerData (F:)
ServerLogs (G:)
Server_System (H:)Not only F: G: H: as they are visible now in SQL Monitor.
Thank you.15 votesThis 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 3.2.1.231
6 votesHi, 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 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
- Don't see your idea?