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.
773 results found
-
Alert statistics over time
I would like to see which alerts are firing more frequent over time.
It would be nice to be able to see alert statistics over time, tabluar or graphical.14 votesWe’re reviewing this and would appreciate any more context on what you would like to do with the information.
-
Provide Mobile version of Alert Monitoring Screen
It may be just me (since no one sle has yet to suggest this) but a mobile friendly version of SQL Monitor for the ALERTS tab would be of great benefit. Currently I check the ALERTS on my SMART PHONE which has a screen waaaayyyy to small to do this but since I have no tablet option I have no other choice.
A mobile option at login to SQL Monitor would let those with smaller sized computing devices acccess the ALERTS tab so as to monitor/check in on their SQL Monitor instance remotely.
Thanks
16 votesThere are currently no plans for a SQL Monitor mobile app. We hope to improve the experience when using SQL Monitor on a mobile device. However at the moment we can’t give a timescale for when this might happen.
-
Show sample aggregation values on Analysis graph
As you zoom out of a graph on the Analysis tab, the peaks and troughs become less obvious (I fully understand that and agree), but it would be beneficial to know roughly the level of detail at which the values have been calculated to show on the graph.
So for example at the most detailed level (say at Last 1hr) CPU usage is sampled every 15 seconds, zoom out to Last 6hr, and the points seem to be every 1 minute - so are 1 minute averages.If I come all the way out to a custom 60 day view,…
1 vote -
Show current data sizes on purging page
On the data purging page would it be possible to show for each of the data categories how much space each one is currently occupying.
Possibly even an 'oldest date' too? As this may be pertinent if the purge thresholds haven't yet been met.
On some environments I want to keep as much SQL Monitor data as possible and if it's a healthy server you may have very little alert data, and so want to keep more history than you do say, machine data.
It would also help in cases where the Repository database is growing, and you're not sure…
7 votes -
Save DMV Snapshots for Analyzing and monitoring changes
Idea is to save snapshots of DMV's so that the changes can be analyzed. For example sys.dmexecprocedure_stats shows only total, last and average elapsed time. It will be great to know how the average changed over a period of time.
Common use case: sysproperties
31 votes -
Custom metrics to have their own individual data purging value
At the moment, we can only have a single value for data purging for all custom metrics.
I would like to be able to set a custom data purging interval for selected custom metrics as I'd like to track them over a longer period of time.
1 vote -
New alert type for blocking in parallel execution plans
We frequently get alerts for a "Blocking process" where 1 process is blocking itself because it is running in parallel and the threads are blocking each other. While this might represent a scenario that can be improved this is normal activity in queries that use a parallel execution plan. This alert is identifiable by "Number of blocked descendants: Unknown" and the lack of any blocked sessions.
I do not think this type of blocking should be ignored. But, there is no customize the behavior of this alert. If you exclude specific queries from the "Blocking process" alert you would not…
3 votes -
View transaction log
Have ability to view and possibly generate recovery scripts from the transaction log
6 votes -
add "Red-Gate SQL Monitor" to the start of all titles
If I have a lot of tabs open, the title of the page gets shortened. So, hypothetically, I have enough tabs open that only 4 letters show on the redgate SQL Monitor for the page title. Boss comes into my cubicle to talk to me about something, glances at my screen and sees I have a tab called "Anal..." open when it is really "Analysis", and some red flags will go off in his mind even though I'm doing nothing wrong. If it started out with "Red-Gate - Analysis" or "SQL Monitor - Analysis", even if that got shortened to…
4 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, then…
3 votes -
data purging - add a flush/reset button
it would be nice to have the possibility to clean/empty all data from sql monitor. for instance since we were trying different alert options etc... there's a lot of stuff which are not needed anymore. i mean after fine tuning the system i'd like to "start over" with a clean history even if we lose the old logs...
3 votes -
Track sql timeouts on execution
Track sql timeouts on execution from applications that close the connection before execution is completed
1 vote -
Create alert on items in Analysis Graph
The ability to create an alert metric around data which is currently being collected for the Analysis graphs. E.g. Being able to alert when the BufferPagerLifeExpectancy drops below a certain amount.
35 votes
Daniel Rothig
responded
-
Have a standard metric for Data space used
There is currently an out of the box metric or Log Space Used, but there isn't an equivalent Data Space Used.
I get that it's a bit trickier if you have multiple data files, (even just adding them up as one metric). We have databases that we want to pro-actively allocate space for but it's hard to do without a metric to tell us when it's getting full.
8 votes -
In the email alert for custom notifications I would like to execute an ad-hoc query that shows me the results.
This will allow me to write a custom metric alert and see the results of the alert inside the email alert. Example where I monitor one log file with various items the custom alert message can give me context on what errors are written to the log inside of the email
3 votes -
see the meaning of the alert in the email alert going out as it shows in the description on the dashboard inside the dashboard
This will provide more context at what the alert means without going into the dashboard (web) page.
2 votes -
Expand lower section of overview window
I would like the ability to expand the sections in the lower portion of the overview window or break them out into separate windows. For example, when viewing the Top 10 Queries or Waits it is very difficult because there is not enough room. Also because the individual tabs scroll separately from the main window, scrolling is a pain. The top graph section shrinks, but it still takes up too much screen area. Being able to break out in individual sections or expand them to fill the screen would be very helpful.
See attached screenshot for an example.
6 votes -
remember
Remember time period in overview of an instance or change the default from 24 hours. I tend to look at the overview of an instance using the last 6 hours however every time I click down in the overview I have to change from last 24 hours to last 6 hours, this is very frustrating. I would like to be able to remember my last setting or at least be able to change the default for me as a user.
7 votes -
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 -
Be able to see in the overviews panel how much RAM my monitored instances are consuming just like I can see CPU and Disk IO for example.
I want to monitor how much RAM my instances are consuming while I'm in the overviews panel and even though I can go to a specific panel for checking this specific counter it'd be useful to havr it in the single overviews panel and not moving back and forth.
2 votes
- Don't see your idea?