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.
198 results found
-
Make cookie timeout duration configurable
Currently Cookies expire after 2 days, this means you have to re-enter your password for SQL Monitor every two days. This should be configurable. Some of us have adequate desktop security, and secure external access that this is unnecessary.
3 votes -
create a function to allow clearing of all alerts on a given server, instance, database.
Currently i can only find a way to clear 100 alerts at a time, or to purge information from the SQL monitor. It would a nice easy feature to be able to clear all alerts in one go.
3 votesThis feature is already present in the SQL Monitor.
-
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.
-
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.
-
Day of week is not considered in Analysis Graph when comparing this mont with last month
When comparing this month's data with last month's data, the 1st of this month is compared with last month's 1st.
This might not be relevant if, for example, the first of the current month was a Wednesday and the 1st of last month was a Saturday.When comparing this week with last week, this Monday is Always compared with last Monday asf.
So, it would be nice to have a new option where the day of week is considered.
3 votesSQL Monitor v3.4 is now released.
The new features include:
• Time ranges and comparison on the Analysis graph are fully customisable, making it easier to identify unusual patterns of behaviour.
• There are now more ways to manipulate the Analysis graph, including clicking and dragging to change the time frame, and zooming in and out with the mouse wheel.Thanks,
SQL Monitor Developement Team. -
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
- Don't see your idea?