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.
- or
716 results found
-
In the Global Overview screen, have a filter selection for Still Active Alerts
Once an Alert has been cleared or ended I no longer want to see it on my Global Overview screen. When I am handling lots of servers and I see lots of RED on the alert side but they have either been cleared (checked) or ended I no longer want them showing up on the global screen unless I want them too to review. This causes lots of questions from management when they walk by and see lots of RED and the Alert was handled or no longer a concern.
3 votes -
Job Duration Unusual: ability to set different thresholds for different jobs
Some jobs that take a few minutes, others routinely take a longer time to run, and so it would be useful to set different thresholds for different jobs.
The current set up allows for excluding jobs from the alert, but offers no way of still monitoring those jobs.
I only want to exclude the jobs from monitoring, only if its possible to add in another alert just for them.
The documentation seems to hint that you can configure different alerts for different jobs, but all I've found is the high medium low thresholds, and this isn't the same.
…
2 votes -
configure notifications 'per alert per object' rather than just 'per alert'
Right now we have a large number of SQL Servers across different environments such as dev, QA, production, etc. In a similar way to having multiple notification channels configured on an alert (another suggestion covers that), I'd like to be able to configure the alert notifications differently for each level that the alert is set at ... I'm away from work right now, but I think that although you can set the thresholds and filters at each group level, you cannot change the notification settings (eg, do NOT trigger SNMP alert for non-production environments). if I'm right about that,…
3 votes -
Allow use of non-administrative shares
Instance-level monitoring requires the use of the default administrative shares, which are likely to be disabled on hardened production servers.
Allowing the use of user-specified shares on a per instance basis would provide a means of getting around this restriction.
1 votesorry, can’t do – Microsoft’s APIs are too flakey
-
Add Active/Ended as SELECT drop-down options for Events
The current Alerts page Select drop-down has None/All/Read/Unread
For events, such as Disk Space, being able to Select "Ended" to get rid of the noise, helps focus on what needs to be addressed.
If the list doesn't have any Event-type row, don't offer this pair of options.
3 votesWe’ll look into this. In the meantime you can set-up a custom filter for Active or Ended events and use the ‘Select All’ to select these rows.
-
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
-
full table scans
Highlight full table scans on big tables, so these can be investigated
It could be these tables have grown, so initially they were ok, but now they aren't
3 votes -
Some alerts show 2 different time zones on a single alert event
On the alerts page I open a Database Unavailable alert that indicates a time of 10pm. The new page opens, and I see "Time raised = 10pm" but on the Details tab I see "Time = 6am"... it's showing UTC time instead of local time here. (Unless I've got something misconfigured!)
2 votesThanks – tracking this as a bug
-
Be able to customize alerts by job
I would like to be able to customize alerts by job. For instance, I have many jobs that run multiple times per hour. If it fails once or twice, I don't want to be alerted about it. However, if it fails 3+ times in a row, I want to be alerted.
3 votes -
A report on the front page (Overviews) of the Sql service status
A report on the front page (Overviews) of the Sql service status (Datbase Engine,Agnet,Reporting Service And etc )
Using DMV "SYS.DMSERVERSERVICES"
This Report includes Columns For Example : ServiceName,Startup-Type ,Status-Desc And Last Startup Time
Tnx From Redgate Company Team
2 votesUnhealthy service statuses raise alerts in SQL Monitor, which will be surfaced on the front page (future work on the front page will make this more parseable in SQL Monitor 5.2)
-
Alert based upon trend data
We want to be able to alert when a value changes dramatically over a period of time. so if a system returns 110,105,112,40,38,52
to eye ball that on a graph I can see there is a problem, however that may be at the peak time of the day and 38 might be a reasonable value for in the middle of the night, so having a threshold of a low value is not appropriate, the comparison mode of query for this situation would report a change of
-5,+7,-72,-2,+14in here there is one large drop but then it is running stable,…
3 votes -
Overviews Alert Severity Colours
When I go to the overviews page the servers have different alert levels represented by a colour and a symbol. I would like the choice of colours to be easier to identify for colour blind people, so the healthy, low and medium have colours that are almost identical to colour blind people as the contrast is so similar: https://personal.utdallas.edu/~melacy/pages/2D_Design/Itten_ColorContrasts/ColorWheel02.png
2 votes -
Long Running Query Alert - Update Process Fragment Info for Agent Jobs with SSIS Packages
One of the most common alerts that we get is the Long Running Query alert. However, when the query is due to a package executing from an agent job, there is little to no information about what is running long. The attached image is an excerpt from one of the alerts we got this morning. We can tell it is from an executing job, because of the SSISDB database specified. But beyond that, we are left trying to figure out which job/package was the culprit by digging through execution logs and schedules, then trying to match execution lengths with where…
2 votes -
Option to display time zone with time display.
Example:
Long-running query Server1 2:05 AM (UTC-5)
Blocking Server2 8:15PM (UTC+2)etc.
Thanks
1 voteAll times are shown in accordance to the browser’s timezone
-
Read Only users should not view Analysis page.
When restricting "Read Only" users they can still see all servers when viewing the "Analysis" page. I think this should also exclude any servers not explicitly defined in the Managed Users page.
1 voteThanks for this suggestion. This has been fixed in Version 9.0.6 (although I would suggest updating to the most recent version, v9.0.7 at time of writing) when we fixed the issue SRP-11791: AD user can see names of servers they don’t have access to fixed for Analysis and Backups.
Hopefully this completes this suggestion.
Thanks,
SQL Monitor Development Team -
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 -
Check the plan cache ad-hoc or on a schedule to report issues
implicit conversion,
scans,
lookups and the index that didn't have the columns include
missing indexes
Parameter sniffing
etc...
Report the issues based on impact number2 votes -
Improve the resolution of the analysis graphs
The analysis graphs don't plot enough points to be able to clearly pick out peaks and troughs in the data -- it all gets averaged out.
2 votesAbsolutely. We’ve upped the resolution from 50 data points to 500 or so.
-
Have a way to exclude Deadlock alerts based on the T-SQL or Proc name
I would like to exclude alerts for deadlocks based on a procedure name or other T-SQL, just like I can do for LRQ and other alerts. Please see http://productsupport.red-gate.com/hc/requests/170766
1 vote -
have the ability to customize browser tab labels
Provide the ability to label browser tabs to indicate contents, such as "Host101 Disk Activity" or "Host102 Database Transactions" or "Host103 Disk Usage"
1 vote
- Don't see your idea?