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
721 results found
-
Filter disk space alerts for Quourum disks
Add a new criteria to the Disk monitoring, that allows me NOT to monitor disks that have less than X GB/MB of Total disk space.
13 votes -
Identify head blocker in a blocking chain
It would be quite useful and timesaving if one could identify the head blocker for a blocked process (as done in SSMS's Activity Monitor, Processes tab). Otherwise when get a lot of blocked process alerts, you have to manually figure out the head blocker by analysing all the alerts.
79 votesThis work was completed in version 5 – apologies for the delay in updating.
If you view a “Blocking process” alert, clicking on the ‘Processes’ tab (next to the details tab) will show the head blocking process, followed by any blocked processes.
If this doesn’t meet your requirements, please let us know how we can improve this alert.
Kind regards
Adam -
save monitoring data of a specific day
When having performance related issues on environments we'd like to be able to "save" the data of a specific day or days in order to do a proper root cause analysis, even over a longer period of time.
Due to aggregation of data we're now seeing issues arise that after a certain period we're no longer able to access detailed monitoring data of that day through SQL Monitor. Being able to access this data in SQL Monitor helps us correlate this data against other monitoring systems even after aggregation.
Our suggestion would be to add a save…4 votes -
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 -
Login via https
Is there a configuration setting to force the SQL Monitor login page (or entire site, preferably) to https?
10 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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
pass
Platform as a service(PaaS) support on SQL Monitor
6 votes
- Don't see your idea?