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
-
Sortable System Processes Grid
On the Alert Details page, it would be nice if I could sort the grid under the "System Processes" tab. It currently shows processes sorted alphabetically by name. I would like to sort it by CPU or memory utilization to see top consumers. I currently have to copy the data to a spreadsheet to do that.
10 votesThis suggestion, allowing the system processes grid in alert details to be sortable, was completed in Version 6.0.18 – apologies for not updating at the time.
Thanks for the suggestion – please reply if you feel it needs further attention.
Kind regards
SQL Monitor Development Team -
to see 24-hour clock affecting times on graphs
I see the setting and it is set and in most places it is used but not in the time axis on graphs in analysis.
6 votesWe have just released version 7.1.3, available from Check for Updates, which fixes this issue.
Thanks for the suggestion, and for your patience,
Adam
-
Allow option to exclude Integrity Check Overdue Alert for read only databases
An alert configuration option should allow
a database status to be checked when querying for last good integrity checks and read_only databases could be excluded from the alert. Even when integrity checks are performed on read only databases, the last checked date is not updated resulting in unnecessary alerts in most cases.8 votesThanks for this suggestion.
Version 9.0.7 has now been released and adds the ability to exclude read only databases from Integrity Check Overdue and Fragmented indexes alerts.
We will mark this as completed, but please do raise a suggestion if you would like to see further improvements.
Thanks,
SQL Monitor Development Team -
Relative-day maintenance windows
Rackspace maintenance days revolve around, for example, "Default week - Wednesday - 02:00 to 04:00", where "default week" is established in the service contract. That can change to early-week or (I forget the name) "late-week".
Current SQL Monitor Maintenance Windows are wholly inadequate to record a "Default week is 2nd week of each month, maintenance on that week's Wednesday, at (the time period)".
Without this, my PagerDuty Alerts go berserk during maintenance windows, and shy of having someone go and suspend monitoring at 2 in the morning and remember to turn it back on, it just keeps on sending out…
8 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
-
Disable Chat functionality
It would be nice to have an Option to disable the built in chat functionality. I understand this is a quick easy method for obtaining feedback from the user community. The issue I have is that this is not an "Approved Chat Client" according to my info sec unit.
Having the ability to turn it off allows me to satisfy their requirements while still allowing this to be enabled for other users to quickly interact and provide feedback to RedGate.
6 votesAfter upgrading to SQL Monitor 6.0.8 or later you can now disable the intercom chat feature.
After upgrading navigate to the following file C:\Program Files\Red Gate\SQL Monitor\Web\Website\web.config
and amend the line
intercom enabled=“true”
to be false, then restart the website.
Further details can be found here:
https://forums.red-gate.com/viewtopic.php?f=205&t=80218&sid=76afdd87b11da381fcb31901d658270a#p143776Thanks for your patience with this issue,
SQL Monitor Development Team -
Add AM PM or military time to alert times since they aren't listed
Process login time: 3 Nov 2016 09:00
Query start time: 3 Nov 2016 09:00
Would either want them in military time, or listed w/ AM PM so I know when they occurred1 voteClosing as this has been available since 6.0.7
You can find this option on Configuration > Display settings. Please let us know if this is not working as you expect.
Thanks -
Forecast and plan disk/database capacity
CONTEXT: When looking after a large number of databases, we have to make sure that none of them run out of space or I/O capacity.
PROBLEM: SQL Monitor needs to show us:
• The current size of Database files (and which disks they are on) and how full they are, ideally with a forecast
• Autogrowth configuration
• Space remaining on disk, ideally with a forecast
• File and disk-level IO metrics, ideally with a forecastEXAMPLE SOLUTIONS:
• Provide this data as metrics in the Analysis Graph
• Create a Disk Overview report with this data
• Enhance the…217 votesThank you for this suggestion. Version 8.0.10 released July 10th, 2018 includes a new Estate tab containing the new “Disk Capacity Planning” feature.
We hope this meets the requirements and will close this suggestion, but please do raise another suggestion if you have specific improvements you’d like to see.
Kind regards,
Adam
SQL Monitor Development Team -
improve speed when navigating through the GUI
It takes quite sometime to navigate across the screens on V6.0 would be a welcome relief if we have performance improvement on the UI
1 voteThanks for raising your suggestion. We’ve made a number of performance improvements over recent releases. Whilst we will continue to make improvements, hopefully this meets your expectation regarding this suggestion, so I will close this issue.
If you have any specific issues or suggestions around performance, please reply to this or raise another UserVoice suggestion so we can investigate.
Thanks
Adam -
"CLEARED" alerts button should be renamed to "CLEAR".
On the alerts screen, there is an option to select alerts. If you want to clear the alerts selected you hit the button labeled "CLEARED".
Having the button marked "CLEARED" is confusing because it implies that the button is a filter rather than an action. It should be labeled "CLEAR" so you know you are performing an action.8 votesThanks for this suggestion.
We agree the labels were confusing so this was fixed in version 8.0.2 in March (apologies for delay in updating) when the new inbox was released. The button now reads ‘Clear’ as you suggested.
Thanks again,
SQL Monitor Development Team -
Reduce the number of false-positive status alerts (e.g. Machine unreachable)
CONTEXT: Many status alerts (eg. Machine unreachable) have a simple configuration model, meaning that these alerts will trigger as soon as a ping to the Machine fails.
PROBLEM: VPN connection resets, scheduled restarts, etc. all may be acceptable causes for a ping to fail in our system, but these currently lead to a lot of false positives... provided they are brief, and the system recovers in time.
EXAMPLE SOLUTIONS:
• Add configuration to the machine unreachable alerts to set a time threshold
• Require two consecutive pings to fail before raising the alert92 votesVersion 5.0.5 introduced the ability to configure machine unreachable, and SQL Server instance unreachable, by multiple time thresholds. We left this open for a while to see if there were any further requests. Thanks for the suggestion.
-
Don't bloat plan cache
Fix this query so the nvarchar() parm is of a fixed size (or MAX). As is, each invocation is generating its own execution plan and bloating the plan cache.
(@p0 bigint,@p1 bigint,@p2 nvarchar(560))INSERT INTO [data].[ClusterSqlServerTopQueriesInstances] ([Id], [CollectionDate], [QueryText]) VALUES (@p0, @p1, @p2)
(@p0 bigint,@p1 bigint,@p2 nvarchar(159))INSERT INTO [data].
[ClusterSqlServerTopQueriesInstances] ([Id], [CollectionDate], [QueryText]) VALUES (@p0, @p1, @p2)1 voteCompleted in v6.0.3
Thanks again for the suggestion, we appreciate your input.
SQL Monitor Development Team -
See how alerts correlate in time
CONTEXT: When investigating an alert, it is useful to see what else has happened at the time. SQL Monitor gives detailed performance and query data with every alert details report, but doesn't show what other alerts have been raised at the time
PROBLEM: Sometimes alerts inform one another. E.g. a Long-running query can be caused by a blocked process, or a deadlock can cause a job failure. Alerts coinciding with the current one potentially help us to determine the root cause
EXAMPLE SOLUTIONS:
• List time-correlated alerts when viewing alert details
• See alerts over time on a graph
•…38 votesVersion 6.0 was released on August 30th, 2016 and contained a new Server Overview which shows alerts over time.
I am closing this as there have been no new comments since it was released. If you would like to see specific improvements to this feature, please raise a new suggestion.
Thanks,
SQL Monitor Development Team -
Receive an alert for the process that is blocking not the process being blocked.
We recently upgraded our SQL Monitor to version 5.1 and it appears there has been a change in the Blocking process metric. Before the upgrade we received an alert about a process that was blocking and after the upgrade it appears we receive an alert for each of the processes being blocked. We have set the threshold for 90 seconds and if there are three processes that are 30 seconds that total the 90 seconds, we receive an alert. However we don’t want to receive an alert for the 30 second blocked processes. Is there a way we can understand…
10 votes -
Alert History on new Overview - Don't show Cleared Alerts
The slide-out Alert pane is useful on the Overview IF, and ONLY IF, under normal circumstances we want to see NON-cleared Alerts, like the default filter on the Alerts page itself.
Please make this pane behave like the Alert page's filter, and allow us to re-filter, to include cleared if we want to. But at the very least allow us to set a default filter (in my case NON-cleared).
Thanks.
7 votesHi, thanks for the suggestion. The version 6.0.10 release added the ability to show/hide cleared and ended alerts from the timeline and alert sidebar on server overviews. We intend to add this to the global dashboard soon. Hopefully this solves the issue.
-
Navigation for "rewind time" shouldn't hide navigation buttons
The navigation controls for "rewind time" autohide when actively using this feature. Please consider enabling until "live" is chosen again to simplify operation to move back and forth in time increments.
Issue submitting first time. if duplicate please close.
3 votesClosing this because the v6 server overviews no longer have this particular time control so hopefully this bug is no longer relevant.
-
On the main dashboard please maintain a consistent ordering.
Dashboard element sorting should be fixed preferably in alphabetical order. The whole idea of a dashboard should be to provide an at a glance view of the state of your server set. When you change the order from servername when all is green to some other order because something has triggered an alert on a server I have to spend extra time figuring out which server has an issue because the sort order has changed.
1 voteVersion 6.0.11 has now been released and amongst the enhancements is the ability to fix the servers in alphabetical order (Oder by: Name).
If you have any feedback, email sqlmonitorfeedback@red-gate.com
Thanks,
SQL Monitor Development Team -
When using Windows authentication I want the read-only account/group option.
I like the windows authentication but it doesn't have the read-only option. I would like to be able to add users and AD groups where I can limit the servers, but also make the data read-only, just like the options when not using Windows Authentication.
8 votesApologies for not updating the status of this suggestion. We have supported this since version 6.0.17. When adding an AD user or group, you can now choose whether that user should be a standard or read only user (or an administrator). So you can do this, and can also choose the permission level for each individual user, rather than having to define it for the system as a whole.
Thanks for your patience,
SQL Monitor Development Team -
Push 5.2 Alias down to Analysis and beyond
The write-up about the 5.2 Alias feature waxes almost lyrical about how much we would like it...
Until you open the Analysis page and see the old names - in my case unintelligible I.P. addresses. Sad, very sad...
Please make Aliases utterly pervasive, as in Analysis, Configuration => Monitored Servers (I.P. list), emails (just to make sure they're not overlooked).
3 votesI’m closing this suggestion because the server aliases were fixed in v5.2.2.
However, there is currently no way to alias cluster/machine names, so if this is important, please do raise this as a suggestion as we could look to address that if there is demand
-
Bring back the ability to list fragments of T-SQL to reduce Blocking Process alerts, please
By FAR the largest number of abject NUISANCE Blocking Process alerts I get across 17 servers is due to a simple "How is fragmentation going?" query from a 3rd party product (Idera Defrag Manager).
Looks like this:
use [DBName] declare @indexId int declare @dbId int declare @tblId int declare @partitionId int set @partitionId = 0 select @dbId = ISNULL(DBID(),-1) if @dbId=-1 RAISERROR( N'Database does not exist or permission denied: %s', 16, 1, '[DBName]' ) else begin select @tblId = ISNULL(OBJECTID('[DBName].[dbo].[TableName]') ,-1) if @tblId=-1 RAISERROR( N'Table does not exist or permission denied: %s', 16, 1, '[DBName].[dbo].[TableName]' ) else begin…
3 votesVersion 6.0.16 has now been released and this includes the ability to add regular expression filters to blocking process alerts. We hope this completes your suggestion.
Thanks, SQL Monitor Team
-
Integrate SQL Monitor notifications with devices, ticketing systems and and other monitoring tools
CONTEXT: SQL Monitor is one of multiple tools I use to monitor my estate, such as SCOM, Tivoli, and OpenView. I would like to consoldate notifications from all of these tools
PROBLEM: SQL Monitor only sends human-readable email notifications, but other integration points like SNMP traps are not provided out of the box
EXAMPLE SOLUTIONS:
• Provide an SNMP demon against SQL Monitor's alerting data
• Make SQL Monitor send SNMP notifications out of the box
• Ability to send SMS or other push notifications
• Ability to "forward" an alert into a ticketing system127 votes
- Don't see your idea?