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.
710 results found
-
I'd like it to be more obvious that an active alert is no longer a current and unresolved issue
Whenever an issue is flagged, for example in the night, it changed the server to red. Once you click on that, the state is "active" (more un acknowledged I would say if not current). For me it is not clear if that issue is still ongoing or that it had been an issue and is now resolved.
Can it be made clear what the end time is if the alert is no longer active? (right now only start time is listed)2 votes -
have more flexibility with user permissions.
I'd like to be able to customize permissions. For instance, I would like an AD group to have the ability to set and remove alert suppressions (operational) but not have admin access to the monitor (administrative).
2 votes -
add data from past to a custom metric
Since data at the current point in time is still being processed and takes about a minute and a half to complete its way around the system a way to add a data point from a few minutes ago for example would be very advantageous.
As a work around currently the metrics all do a
where utc_date between
dateadd(minute,-3,convert(smalldatetime,getutcdate()))
and dateadd(minute,-2,convert(smalldatetime,getutcdate()))
but this means that the data is always two minutes out when compared to the actual raw data2 votes -
Reduce the suggestions on how to fix queries when viewing Top 10 Queries
SQL Monitor pops up the text "x issues with this query". Addressing them could improve performance. It then lists some things that might have an impact (e.g. select * instead of listing just the columns that are required) but also lists other things that won't change performance (e.g. not specifying a schema name).
Can this list be reduced to just what is potentially performance related? Maybe have a 2nd field for best practices if that's considered improtant.
2 votes -
Webhook notification for Cleared events
We use Webhook notication to push the alerts to our central ITSM tool. The status "Raised" creates an entry, the status "Ended" deletes the entry in the third-party tool.
We would also like to be able to use the status "Cleared" to delete entries. For this, a webhook notification would also have to be triggered when the status changes to "Cleared", which is not yet the case.
2 votes -
For the "Job failing" alert, add the ability to exclude job categories
The "Job failing" alert currently has the ability to exclude jobs based on job name and owner. It would be very useful to also have the ability to exclude jobs based on the Agent Job Category.
2 votes -
can use proxy
We have internet access through proxy. I need SQL Monitor to work through this. for example download latest update
2 votes -
When "Totals" is selected, on mouse over still display average values for the metrics
When we change from "Avg. per execution" to "Totals" the row order can change.
With bigger numbers, it becomes harder to quickly know if the average is high or not to decide to take a further look.
Instead of need to "Track query" and then click back and forth with "Avg. per execution" / "Totals" having the average on the tooltip when "Totals" is selected will be helpful.
2 votes -
Being able to set alerts based on existing KPIs (Analysis Graph) instead of create a new custom metric
If I want to create an alert based on some existing KPIs, I need to write the query and can't leverage the existing one.
Example:
I want to create an alert when the "Tempdb: Free bytes" is lower than X.
I can't use the existing "SQL Server metrics" that contain this KPI.
Instead, I need to create a new custom metric and build the query. (which in the end it will be exactly the same). Only after that I can create an alert.2 votes -
Add a scroll bar to the backup list (bottom within the specific database)
When we go to the "Databases" at the bottom and we expand a specific one we get the list of the backups that happened during the period we have filtered.
For a better experience, this list should have a vertical scroll bar it it it will show more than 5/10(?) entries.
Otherwise the general scroll bar will become smaller, the page height increase a lot and we need to scroll much more
2 votes -
Grant more granular report level access
I can grant report level access to a user by adding them to the Reports User role and I can restrict the servers which they see reports for.
However, this role gives the user more permissions than I would like to give - they can still view any other page - alerts, server overview etc
Can we change this so they can see the reports only?
2 votes -
Add ability to collapse the "Query details"/"Wait type"/"User memory" list under a specific query.
Often we want to screenshot the execution pattern, the graph below all these areas and because all of those occupy a big chunk of space on the screen, this becomes harder.
We end by "zoom-out", crops, or even picking multiple screenshots and doing collages.
Thanks
2 votes -
Job Duration Unusual Alert should be 'AG aware' to avoid false positives
We are using an AG for one of our instances.
As you would expect we have the same SQLAgent jobs created on both instances in this AG, but we only want the job to execute on the primary.
In SQLAgent the jobs on both nodes of the AG have a step at the beginning which checks to see if this is the primary instance.
If it is the primary instance it will proceed to step 2 and execute the rest of the job.
If it is not the primary instance the job will terminate.
This all works fine - however…2 votes -
Clear RedGate Alerts automatically
Once the alert is taken care of, RedGate should send an email saying that the alert is cleared. Also, there is no need of a clear button in the web interface, it should be done automatically.
2 votes -
Support Monitor Ubuntu with another port ( not port default 22)
Dear Development Team,
Currently, I'm using SQL Server running on Ubuntu ( with SSH port 5678). I can't connect to OS Linux via SSH port 5678. I don't see where to input the port (not the default port). I want the Team to enhance the feature allow to the input SSH port.I have created an issue to discuss here (https://productsupport.red-gate.com/hc/en-us/requests/305026)
Thanks,
Khoa.Nguyen2 votes -
Datawarehouse Database for older data
There should be an option to transfer older data to a datawarehouse database and still seamless be accessible from the Red Gate Monitor tool. This way the primary database can be small and quick in normal day to day use.
2 votes -
Show "HostPID" on deadlocks
Add "Hostname" and "Hostpid" detail to blocking processes and long running queries in RedGate, this information is available deadlocks.
This would help us to identify the process causing the blocking to further investigate fixes vs trying to work out the process from the SQL code, which can often look similar to other queries.
2 votes -
Current Activity (sp_whoisactive) History
I would love to see snapshots of current activity (sp_whoisactive) taken on a regular cadence (e.g. every 5 minutes would be very useful for troubleshooting).
So in the current activity tab I can select a snapshot time from a dropdown of taken snapshot times. Backwards/Forward buttons advancing to the next/previous snapshot would very powerful.Having the top queries and waits etc. is super useful, but being able to see a snapshot of the active running queries around an incident would add a lot of value.
Appreciate that is potentially generating a significant volume of data so appropriate retention/default capture options/server…
2 votes -
Uncover hidden tuning opportunities by toggling graphs to a different scale
Two problems, one suggested solution: First, too often something important to us is hidden, because the graph showing the critical metric is skewed by another event. In order to show the peak of that event, the graph is scaled such that other activity is just a flat line at the bottom. Second, graphing multiple measures in a single graph, when their scales vary widely, makes interpretation difficult--for a contrived example, imagine plotting CPU (scales to 100) and batches per second (scales to tens of thousands for our web site). A tool for tuning MongoDB provides a beautiful solution, by allowing…
2 votes -
groups
Group properties.
I am using groups to group databases by application /development group. Then use tags to determine prd, dev, uat etc.What would be really useful would be able to add properties to a group such as the developer name to contact when i see poor queries
2 votes
- Don't see your idea?