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.
693 results found
-
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 -
Blocking process alert based on number of descendants
While the alert for blocking process is great, it would be nice to be able to configure the trigger for number of descendants affected as well.
If a blocking process runs for 30 seconds and affects 10 people but the alert is configured for a one minute duration of the block it would obviously not let you know
5 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 -
Add an option to schedule when custom metrics run against a given database.
Currently when a custom metric is executed can only be controlled by the frequency (daily, hourly, etc).
My primary purpose is for daily. I would like to schedule the time of day a daily metric is run per database, or at least server. The custom metrics I pull back are time sensitive so controlling when the metric is returned is a must.
A more advanced option to this would be going beyond simply choosing the time of day for daily runs, but rather the ability to build a custom schedule of run times. An example might be Custom Metric A…
54 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.
32 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 -
Add other Red Gate tools to SQL Monitor as licensed modules
It would be useful if the following tools were additional modules that could be added to the web interface to SQL Monitor;
SQL Backup Pro
Index ManagerFor example, upon receiving a no database/log backup alert it would be great to just click into another section of SQL Monitor to then diagnose/fix the issue rather than using an external application. Additionally the capability within Index Manager would sit well in SQL Monitor as a logical extension for the fragmented index alert.
This would allow SQL Monitor to be the primary place that a DBA would need to go in order…
11 votes
- Don't see your idea?