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 for full filegroup
if a database is a fixed size (max size set), or if the db is initially set to be the full size of a disk, there is no alert to let us know that the database is full.
for instance - if T: drive contains tempdb (and only tempdb) and we've sized it to take the whole drive. we've done funky sizing and growth settings so we can get an alert when the db grows, but once its grown and the temp objects are cleared, we're unlikely to get another disk warning, because the DB will already be taking 100%…
6 votes -
Be able to run a query (or powershell) in response to an alert
Be able to run a query (or powershell) in response to an alert.
This would automate some responses, but also want to be able to send the RESULT of a script in the email that goes out, ie Alert to say Schema changes have been made where the email actually includes the schema changes.11 votes -
Filter for Database with no Tlog backup
On the Estate->Backup page, it would be great to have an additional drop-down option for 'DBs without Tlog"
2 votes -
Add AND/OR conditions for disk alerts
We are using SQL Monitor to monitor disks and we also send these disk alerts to our NOC(24/7 monitor team) and when they receives an alert they are calling us on our On-Call service when outside office hours.
The alerts are not always relevant as the alert can be like for example:
Disk free space less than 5 % but actual space left is 300 GB, which is more than enough and no alert and phone call had to be triggered.We are trying to set custom disk alerts but as we have 1000+ disk alerts to configure it’s impossible…
44 votes -
Utilize in SQL Monitor Analysis or Reports pages any SQL Server counter available in PERFMON.
For instance BRENT OZAR has an excellent method to diagnose memory pressure. The counter in use is SQLServer: Memory Manager – Memory Grants Pending which is not available.
If Memory Grants Pending is averaging over 0, queries can’t even start because they can’t get enough memory. You may have queries that have incorrect memory grants, or you may just desperately need more RAM.
30 votes -
Monitor Table Growth and get projections
It would be nice if in the Estate tab under disk usage, we could dig deeper and see table growth and projected growth over time.
19 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.
This combined…
2 votes -
Ability to export backup history detail for providing audit information easily.
possibilities I can think of that might help to add are each backup having it's own export button when the backup history graph is expanded out, including the backup history on the current excel sheet or possibly having a summary report for it in the Reports section
1 vote -
I would like alert sounds.
Every product I have used in the past allowed for an Alert sound that you could turn off and on. I get that this is annoying to some people but for certain alerts I like to have a sound on them because I am not LOOKING at RedGate or my email, but I always have RedGate open. So setting any High alerts to a certain sound let everybody in the office know that there was an issue.
3 votes -
Resizing Reports
It would be quite good if you could edit the size of the report and stretch to make it easier to read. Currently (may be an option to) the data over a 7 days period for example is condensed.
1 vote -
Ignore failing jobs using regex
the config for JOB DURATION UNUSUAL alerts allows the use of regex to filter the jobs to ignore.
this functionality would be very useful for FAILING JOBS alerts
6 votes -
Automatic failover when GEO replication is set up for PaaS servers
It would be great to have a feature to monitor automatic failover when GEO replication is set up between PaaS servers.
It is quite useful information to understand if failover occurs.
4 votes -
Monitor individual CPU cores and not just avg CPU as a whole
AVG CPU is not enough of an indication of how things are going - There could be an entire numa node maxed at 100% while other nodes are almost idle and it will drag the avg down.
As per here: https://forum.red-gate.com/discussion/comment/162141#Comment_162141
6 votes -
Get notification for when a SQL Agent job is in a retry state
Hi, it would be really useful if SQL Monitor could identify when any currently executing job steps are in a retry state. We have many such jobs and the time lost whilst they are in such a state is frustrating as if we had notification we could take action. I appreciate I can roll my solution but would be nice if SQL Monitor could do it :)
1 vote -
Enter and assign purchased SQL licenses to VM hosts, VM or server
The new SQL licensing tab would even make it possible to detect unlicensed instances depending on listed availability or improper VM host movement rules.
6 votes -
Change management for all changes made to your application and a report for the manager to review this change
Change management for all configuration change made in SQL Monitor and a report for the manager to review this change
4 votes -
Add the ability to report/analyize Index fragmentation
I would love to see the ability to see the Index Fragmention results in the report/anayize feature. I have been fighting index fragmention but cant really tell how much it has improved.
9 votes -
Monitor database total space usage not by individual data files.
I have many databases that we are monitoring for space which have multiple datafiles. Usually most the datafiles are full but at least 1 of the files is able to autogrow. Sometimes autogrow has reached its max limitation and sometimes we have turned it off once the file reached the largest size we will allow it. Our goal is to monitor so the database does not run out of space. We currently get alerts for the files that are full, we know some are full, we aren't worried about them, we still have 1 or 2 files we allow to…
10 votes -
kill sql spids
in other monitoring tools (Idera) i can see active sql connections and they are doing. i also have a option to kill the process if i decide. dose your product have this ability
37 votes -
Add a description for users in the manage users for active directory
In some environments, the user login doesn't necessarily match the true user's name. This would help navigate what the user is assigned to that specific account.
1 vote
- Don't see your idea?