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
-
Overlap
To analyse a trend over a period of say 30 days using one continuous line graph is difficult. If we could see a line for day 1, overlapped with day2, day 3 etc over the same 24 hour period then its easier to see trends and patterns e.g. processing time increases at 1pm everyday
Regards
3 votesSee the Baselining features introduced in SQL Monitor 3.5
-
Raise Alert level based on time
Currently all alert levels are based on the numbers allocated and the alert is simply triggered at that level,
Some of the values I'm tracking sit at 0 quite often, the problem is less the number but the length of time that it remains at that number
So after 5 collections i would like to raise a low alert, after 10 collections a medium and after 20 a high alert
Thanks for your time and concideration
Ste
3 votesHi this is planned for status alerts: https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/11123793-reduce-the-number-of-false-positive-status-alerts
For custom metrics that’s already possible via the custom metric wizard
Thanks
Daniel -
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
-
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
-
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.
-
SQL Monitor 5.2.5 upgrade dashboard server/SQL Server memory
Upon upgrading from 5,1 to 5.2.5 the new Global Dashboard no longer shows machine memory vs. memory being consumed by SQL Server. Why was this removed? This can be critical to see if SQL Server or any other process is using up all of the servers memory.
3 votesThanks for this suggestion. Apologies for not closing this sooner as it was completed a long time ago; we did agree that we should show machine memory vs. SQL Server memory and this is shown on the Server Overview memory chart.
Thanks,
SQL Monitor Development Team -
Please remove the 20 character size limitation from the Alias feature
Given that actual server named instances can be longer than 20 characters (even if they are truncated on the display), it makes no sense to limit an alias to 20 characters. Please significantly extend this limitation.
3 votes -
Add a "Check for updates" link in the About section
Alternative for when you've clicked away the "new version available" notification
3 votesHi,
We have now added check for updates to the About section in version 7.1.16.
Thanks for the suggestion. I’ll mark this as completed now, but do let us know if you feel it should be reopened.
Thanks
Adam
SQL Monitor Development Team -
Database File Usage Alert - Autogrowth
Database File Usage Alert : Please consider autogrowth! So far, this alert is of no help.
3 votesSQL Monitor v7.1.18 added an option to disable database file usage alerts when autogrowth is enabled. The setting can be found on the configuration screen for the database file usage alert.
Thanks for helping us improve this feature with your suggestion.
SQL Monitor Development Team
-
Report Email Attachment Name
Name the pdf attachment something other than "AttachedReport".
The report has a title and a date which could be used to name the attachment. That would really simplify the process of saving the reports for baseline purposes.
e.g. "Server2ProcessUtilization20180308.pdf"3 votesReleased in SQL Monitor v13.0.5.
-
Alerting on Autogrowth Events
Alerting on Autogrowth Events, some environments set the file size of their databases and would like to be alerted if autogrowth occurs since that indicates abnormal behavior
3 votes -
reports timespan options
Please add 14days as the timespan in the dropdown for the reports
3 votesShipping 8.0.16.
-
Have the ability to pin the left sidebar in the overview screen
It'd be great if we could pin the sidebar on the left-hand side of the screen on the overview section when looking at a particular server. As I'm looking over metrics I oven find myself hovering over that section then waiting for it to expand and collapse again. An example concept implementation that I think would work well is similar to how Microsoft implements basically that same functionality in their office suite (in particular off hand outlook is a great example). Really just being able to pin it in place I think would satisfy the entire issue for me as…
3 votesThe sidebar is now either open or closed (it will no longer open on mouseover).
-
Comment multiple alerts at once
I would like the ability to add the same comment to all of my selected alerts before clearing them in the Alert Inbox.
3 votesHi,
Thanks for this suggestion.
Version 8.0.23 has now been released and includes the return of the ability to add comments to multiple alerts.
This was initially removed while developing the ability to group alerts, and it’s taken us longer than expected to reintroduce – apologies for the inconvenience this caused.
We hope this solves this suggestion. We’ll mark it as completed, but please do reply if you have any further feedback.
-
Don't check Agent status for Express Edition
Whenever I add a server to the monitoring that is Express Edition, I get alerted that the SQL Agent service is not running.
Well d'uh. It's Express Edition. The Agent service cannot run on it.Instead of always giving me this alert and then having me go in and disable it for yet another server, why not change the logic to not raise this alert at all when the edition is detected as Express?
3 votesThis was fixed in version 9.0.10 released on May 1st https://documentation.red-gate.com/sm9/release-notes-and-other-versions/sql-monitor-9-0-release-notes
Please update to the latest version and let us know if that does not solve the issue for you.
Thanks
SQL Monitor Team -
Allow custom scopes in OpenID Connect authorization request
Currently SQL Monitor only sends the scopes "openid profile".
In my usage the "groups" scope is needed as well.Make this parameter configurable to support any number of custom scopes.
3 votesYou can configure OpenID Connect scopes by running a script on your SQL Monitor repository. See Authenticating with OpenID Connect documentation (https://documentation.red-gate.com/sm11/adding-sql-monitor-users/authenticating-with-openid-connect) for more details.
-
Geeting listener name in AG info
Would it be possible to get the SQL Server AlwaysOn AG listener name in the SQL Monitor dashboard?
3 votesThis is available from version 12.1.16.
-
Median from jobs - calculating Job duration unusual ONLY for sucess
I have noticed that SQL Monitor calculate median from all jobs ragardles if it is failed or sucess...
From my point of view it should analyse only jobs which finished success and calculate median from duration.
I need to know when job succeded what is duration median and if it is ok or not.Please change job duration median to calculate from jobs which ended with sucess.
3 votes -
Estate view (SQL Server version) Discrepancies
For the SQL 2016 versions of SQL Server, we are seeing the software is flagging as "not current". However, we do have the latest SP/GDR.
This issue lies with the Azure Connect Feature which only applies to connections to Azure based on an article we read. . (https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2016/build-versions)
We do not use Azure so we feel that this should not be a required patch.
3 votesAvailable from version 14.0.13 (July 19, 2024).
The Versions page under Estate will no longer recommend users to update instances of SQL Server 2016 to the latest Azure Connect Feature Pack GDR unless that instance is already using an earlier version of it.
-
Add field 'Description' to Powershell module manifest
Currently it is not possible to redistribute the powershell module to an internal nuget powershell repository, because the field 'Description' is missing in the psd1 file.
At the moment we need to add this field and sign the module again before publishing it to our internal nuget feed.3 votesThis is now available in Monitor.
- Don't see your idea?