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
716 results found
-
Add counter [forwarded_record_count] to Analysis page
As you describe in this article: https://www.red-gate.com/simple-talk/sql/database-administration/sql-server-heaps-and-their-fragmentation/
forwarded-record-count From sys.dm-db-index-physical-stats
Please add forwarded-record-count to Analysis page
Thanks guys!
14 votes -
Increase user granularity and allow creating more than the 3 built in user accounts.
Increase user granularity and allow creating more than the 3 built in user accounts. For example, we have an offshore development team that would like access to their SQL instance, but can’t have access to any other instances. What I would like to do is to be able to create an account, assign permissions to that account against databases or instances, limiting the access they have to production systems. If we could get it to use AD integration rather than forms authentication as well as being able to set permissions granularly then that would be ideal.
86 votesSQL Monitor 5.0 introduces Active Directory integration with granular control over which user sees what. Please note that you will need to enable Active Directory authentication in order to make use of this functionality
-
Auto hide Menu and Filter bar
When in TV/Overview mode (dashboard), It would be nice to get the full real estate on the TV/Monitor to show as many server tiles as posible, hence auto hiding the top menu and filter bar. with a dropdown button (show button) on the top right side of the server tile area. (shown in the image associated).
1 vote -
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 -
Report to identify alert overrides
We are using the alert categories "Host machine alerts", "Instance Alerts", "SQL Server alerts", and "Availability Group alerts" for our SQL Server environment. We have defined general thresholds for the alerts w/in each category. We then have situations where we override the alerts for a monitored object in an alert subgroup or the monitored object itself because the general alert threshold(s) don't make sense for the sub group or the object. It would be very useful to have a report which shows where we have performed these alert overrides. A report showing where an alert is overriden or…
9 votes -
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 -
Login via https
Is there a configuration setting to force the SQL Monitor login page (or entire site, preferably) to https?
10 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 -
be be able to send alerts to multiple Slack channels
At present I can only use one Slack channel for SQL Monitor. I'd like to be able to specify a channel per alert - for example I have a custom alert and it would be good to be able to send a message to a designated Slack channel
43 votes -
Banner Messages for planned Downtimes
Hi!
We want to put Banners on Top Global Dashboard to inform Users, that we planning Downtimes on SQL Monitor.
SQL Monitor has build in banners for unlicensed Servers and stuff like that. Would it be possible to show User Messages that there will be a Downtime on SQL Monitor?3 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 -
Click on CPU part of the server block on global dashboard (version 5.2) leads me to serveroverview instead of graph
I would suspect to go to the graph (analysis tab) after I click on the CPU part of a serverblock (in Global Dashboard), instead of the server overview
1 vote -
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 -
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 -
Alerts should configurable to repeat until an issue is resolved
We'd like the option for alerts to repeat until an issue is resolved. For instance, we may have a custom alert to tell us when a DBCC CheckDB hasn't been performed in >24hrs. For that we'd perform the check once per day and expect to get an alert every day that the problem continues. Without the alert recurring it's very easy for it to slip through the cracks and get missed.
Another example is blocking. We have some databases where we monitor blocking via SQL Agent and when a block occurrs for 1m or more, we send emails every 30s…
6 votes -
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 -
pass
Platform as a service(PaaS) support on SQL Monitor
6 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.
69 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 -
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
- Don't see your idea?