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
747 results found
-
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 -
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 -
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 -
service now event creation
ServiceNow integration current creates incidents directly in ServiceNow. Due to corporate standards we aren't allowed to directly create incidents. All monitoring integrations to ServiceNow have to create "events", which are then mappen within ServiceNow to incidents (where applicable).
Please consider adding an option to create events instead of incidents.1 vote -
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 -
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 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 -
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 -
I would like to set up an alert for disk space projection threshold
Wanted to know if we can set up and alert when it reaches the threshold of less than a month of projection for disk - this is in the disk monitoring estate for Redgate .
image.png
Regards,
Shaily.1 vote -
Allow users to specify the time period in minutes for the top 10 expensive queries
I would like to specify that exact minutes on the slider for Top Queries. Currently you can only do a 15-minute change. But I would like to be able to do that down to a minute range. Sometimes we make a change and I don't want to wait 15 minutes to filter out the previous queries.
2 votes -
Be able to set an Alert to escalate when it has been active for a certain amount of time.
I have a several different Jobs that fail periodically, once in a while is not a big problem but when they continue to fail over a period of time it does become a problem and I need to know. Likewise when I have an AG is slow to sync in the middle of the night when it is rebuilding all of the indexes of a 1.2TB database and syncing across to locations in 2 states I don't want to be paged, but if it is persistent through the day I do.
1 vote -
removed an evicted node
I would like the ability to remove an evicted node from a cluster. As of today, we have one in such a state and there is no option to manually remove just that single node from "Manage Servers".
1 vote(reason: bug report)
Hi Matthew, SQL Monitor should automatically remove evicted nodes after a short period of time – if it doesn’t please contact support and we’ll do our best to resolve the issue
-
Filtering on a Postgres Aurora Cluster based on Node
When adding a Aurora Postgres Cluster to be monitored, if it has multiple nodes, say a reader/writer. Can we get a feature that will show only the metrics related to that specific node. Say I want to see only the CPU/Memory/Throughput for the writer node only and vice versa for the reader node.
1 vote -
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 -
Display total memory for memory graphs on summary screens
The memory graph on the summary screen does not always show the total memory on the screen. It shows what is being used, but I have no idea how much is free.
I have attached a file showing one one of my servers that has 128GB of total memory. However, the graph only shows 75GB and it makes it look like most of the memory is consumed.
1 vote -
Show alert bubbles in other metrics, too
I like seeing the alert bubbles in the main overview. It would be helpful to also be able to see them in the additional metrics shown below. Anothe option would be to align these other metrics with the main 4-metric window.
1 vote -
Incremental Image Creation and Deduplicated Storage
This is a formal customer-specific product enhancement from NTI requesting a significant architectural update to the Redgate Cloning platform. NTI utilises this solution extensively across a complex environment. As data volumes grow, the 'build from scratch' nature of the current Data Image creation process has become a critical bottleneck. This request seeks a design update that enables incremental image updates and deduplication to reduce the daily processing window.
1 vote -
MS DTC down alert....
I would like to see an Alert if MS DTC (the DTC service) has stopped\failed or doesn't restart after a reboot.
1 vote
- Don't see your idea?