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
-
See more detail on Failed Agent Jobs
Present the detailed Step error message for Agent Job Failures. Currently shows the Job message, but not the error from the step that actually failed. This requires the user to open SSMS and drill down to find what caused the failure, instead of getting a head start from SQL Monitor.
53 votesThanks for the suggestion and votes. This was completed in version 7.1.2. I will close this – please let us know if you believe there are further improvements we could make.
Kind regards,
SQL Monitor Development Team -
View queries against specific database in real time
View all running queries against a specific database with the details of the query and its duration.
This will help in monitoring a specific query in any particular time
17 votes -
Total data file size/used metrics - add filegroup level
CONTEXT: We have some databases with multiple filegroups, I’d be useful to be able to drill down from the DB level to the FG level on the “Total data file size” and “Total data file used” metrics.
PROBLEM: Not being able to slice totals by FG is problematic, since different FGs often have different capacity / performance requirements, different space used speed/patterns etc.
EXAMPLE SOLUTION: For “Total data file size” and “Total data file used” add an additional selector window after the database selector: a list of filegroups + an (All) option at the top. So, the selectors would be:…
21 votes -
Enable and track wait stats
I would like to see an overview of wait statistics along with historical tracking of those waits. I currently have queries that would show the total wait time, but other tools I have used will provide a current snapshot of these waits as well as store them historically so that I can monitor changes.
72 votesHi,
We are excited to annouce that SQL Monitor v4.0 has been released. This release contains Performance diagnostics features which let you analyze the waits and queries affecting SQL Server performance on the Instance overview and Database overview pages. Check out the release notes for more details.
Thanks,
SQL Monitor Development Team -
see my sizing per server (in Estate)
I would really like to have an extra column in Estate showing how much RAM and CPU are configured. Especially CPU information is important, because this determines how much licenses I need to maintain my Estate.
The extra column could be added between Versions and Status.
3 votes -
Ability to store a baseline
After attending SQL in the city and listening to Grant Fritchey talk about the need to create baselines (and demo sql monitor) a feature I would like is the ability to create a baseline over 24 hours and have it stored. This could be then added to the analysis page as a Versus. ie last hour vs baseline, last day vs baseline.
118 votesWith SQL Monitor v.3.5 introducing a powerful baselining feature, we consider this suggestion as completed.
One thing our implementation doesn’t do (though it was mentioned in a couple of comments) is to be able to “freeze” a data range so as to retain a static baseline. We’ve created a suggestion for this additional functionality – so if you are interested in that aspect please vote on the following suggestion: http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/11122092-select-and-store-a-static-baseline-for-future-refe
Thanks
Daniel -
Show current RPO
Show current backup RPO and allow us to click the graph to see specific databases under each RPO grouping (>15 minutes, >30 minutes, etc).
5 votes -
Run a custom SQL script when an alert is raised
We use SQL monitor very heavily for our SQL and application monitoring, what we would like is for each alert to be able to define a custom sql script to run when the alert is raised, the output of this sql should be included in the alert.
This would allow us to do things like capture whoisactive when blocking occurs or other application specific things and make responding to alerts MUCH easier.
74 votes -
Export the analysis graphs to PDF and add printing support.
I would like to be able to print nice well formatted reports from SQL Monitor so that it can be shown to Management. I guess exporting to PDF could accomplish that.
13 votesPlease use our CSV export instead – Tools like Excel will help you visualise your results in a variety of ways
-
Grant access to the Security Auditing features to a specific user role or user group
As a DBA, I wish to grant access to the Security Auditing features (Permissions changes and Configuration compliance) to our security team. I do not wish the security team to have full administrator access to the Redgate Monitor installation as they are not DBAs and neither interested in nor responsible for any other parts in Redgate Monitor.
At the moment, only Redgate Monitor administrators have access to the above enterprise security features in Redgate Monitor. From a separation-of-duty perspective, the security team should not have full access as administrators to the Redgate Monitor installation.
5 votes -
Who ran the query and what time
I would like to see in sql monitor who was the person that ran the query and what time the query was run.
10 votes -
SQL instances which are part of Availability Group does show if it primary or secondary in Global Dashboard
When SQL instances which are in Availability Groups are being monitored, the global dashboard lists both the primary & secondary node.
However though it does have 'AG' badge but it does not say which is primary or secondary.
While looking at the SQL monitor it will key that we know upfront which is the primary instance and also when alerting it should say primary or secondary in the subject line.48 votes -
Alert "regarding "instance alerts" - Cluster failover - for Postgres"
for Alert "regarding "instance alerts" - Cluster failover - for Postgres", would like to have it available on the individual server level and not just the monitoring group. That way we can customize our notification accordingly.
9 votes -
Support for regular expressions
Most of the alarms need more granular support for excluding/including different things. Using regular expression is a good idea and should be extended further. For example you defenitly need to be able to filter out things from the alarm on the sql server errorlog. Without it's useless.
74 votesThanks for this suggestion, and for the supporting comments.
Several alerts now allow you to enter regular expressions to match text you want to ignore, to stop alerts being raised in certain situations.
For example:
- Deadlock (XE) alerts can be filtered by database, login name & resource (added in version 8.0.22 released November 13th 2018)
- Blocking Process alert can be filtered to exclude queries with a SQL process names, SQL commands or objects match regular expressions
- Job Duration Unusual alerts can exclude jobs matching regular expressions
- Long Running Query alerts can be filtered to exclude queries with a SQL process names, SQL commands or objects match regular expressionsWe will mark this suggestion as completed, so that the votes can be returned while we continue to look at ways to make alerting more useful. Please make new suggestions for specific improvements you would like to see,…
-
documentation
Add Server documentation such as:
- app owners,
- support type (24/7, next business day),
- escalation contacts (clients to contact for unscheduled maintenances),
- primary purpose (main application using the server, business function)
- Add costum fields for server notes or setup instructions
6 votes -
suspend
Hi,
I think it's very important to show Suspended status of a monitored host/instance should be shown in dashboard.
I had suspended monitoring on an instance and forgot to resume so I've missed monitoring for a while.
I suggest to show the state of monitoring (Active or Suspended) maybe graphically/iconic, in the dashboard and Server overview pages10 votes -
Service Level Agreement Metric Report
The following contract metrics are common to many US Government clients. It would be very helpful (and a real time-saver) if SQL Monitor had report that could provide the below listed SLA's in a monthly email to an editable distribution. The report should be .pdf or .xlsx format, with layout intended to communicate to executive audiences. The setup for the report should allow comparing baseline dates. Thanks in advance for considering this idea.
- List of database instances
- Database uptime
- Components that are reaching capacity
- Computer resources growth
- Reserve capacity
- Throughput I/O
23 votes -
add more custom notifications
-
Execute HTTP Action :
This notification method executes a GET request or sends any POST, PUT, or PATCH data to a custom URL. You can execute specific actions on a web server or control any web service that accepts commands via one-time HTTP requests. Whenever a notification of this kind is triggered, the HTTP action is sent. -
Execute Program:
With this notification method, you can execute a script or a program as an external process. It can be a Windows executable file or a BAT, CMD, or PowerShell file. You can use EXE, COM, BAT, CMD, VBS, or PS1 files.
11 votes -
-
Analysis Thresholds
One of the things I like about the free PAL tool, is that you can specify thresholds for each performance counter. Therefore, you can have a customizable red line which appears on your graph to easily tell you if your disk latencies are over 25ms or your free memory is less than 5% - for example.
I would like to see something similar on the Analysis screen on SQL Monitor. I would like to specify for each machine, SQL Server or Custom metric a warning threshold and a critical threshold. This makes it easier to troubleshoot performance issues as…11 votes -
Click to open analysis from alert window
For some alerts, I like to see not only what happened before, but also what happened since. Some examples are disk space, or database file usage. The latter for example has a nice graph of the file usage up to the moment the alert triggered. But when I look at it the next day in the office, I also want to see what happened since - did the file continue to grow, has it been stable since, or was this a peak and is less space used now?
Currently that means going to the Analysis tab, selecting the correct server…4 votes
- Don't see your idea?