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.
791 results found
-
Exclude individual databases entirely from scope
There are some databases (including the RedGateMonitor database) that i do not want to see reported with alerts. I want the ability to omit certain databases entirely from the scope of monitoring and leave all other databases on that machine in the scope of monitoring/alerts.
8 votes -
"Index searches/sec"
Why in SQL Server metrics there is no “Index searches/sec”.
In your description for “Full scan/sec”, you mention “The ratio of Index searches/sec to Full scans/sec should generally be no more than 1000:1.”.
It would be very useful to have this counter without having to go through performance monitor under windows8 votes -
Detailed Memory usage breakdown
I would like to see a breakdown of memory usage. For example, how much memory is used by the plan cache, how much for the buffer pool, etc.
Also, a breakdown of memory usage per database.8 votes -
Provide a tile for an Availability group on the main page
Should be able to see status of an availability group from the front page
8 votes -
Have more retention periods for the data retention settings.
Right now on the data retention settings screen, there is only a drop down with a static list of ranges to keep data. It would be useful if these could be more granular, like being able to set both the number and interval (month,day,year). At a minimum, it would be nice if there were options between 1 year and indefinitely.
8 votes -
Allow Job Name to be used for Long-running query alert exclusion
For a Long-running query alert, the Job Name is being collected but cannot easily be used for avoiding specific alerts from being triggered.
8 votes -
Show query history for custom date range in "Top Queries" view
In the top queries window, the history can only be searched via three date ranges:
Zoom Range,
Window Range,
All historyIt would be good to be able to search a custom date range to make the graph easier to see for a time period of interest. Window range is only three days max and all time can be too broad.
8 votes -
Track Aborted Sessions
The ability to view aborted sessions, either an alert or space on the overview page in a similar way to the TOP 10 queries.
Attached is the offering from SolarWinds.
8 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.
8 votes -
Ability to set up multiple webhooks
We are generating a work flow where alerts of a specific type are sent to a seperate monitoring tools and the rest to a google chat - both use webhooks, both to different locations - at the moment we are using a work around with script tasks....but ideally being able to set different webhook locations and message for different alert types would be beneficial
8 votes -
Additional parameters for filtering Long-running query alerts
Long-running query alerts
Example: Creation of ability for you to filter the queries it alerts on based on a regular expression
Source Ticket:
https://redgatesupport.zendesk.com/hc/requests/65981Possible closely related feature request:
https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/11123559-triage-and-configure-repeating-alerts-more-efficie7 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 -
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 -
create user permissions script
provide the sql to run for users to use during install to assign permissions to the back end database use and the monitored db use
obviously explain about the SysAdmin problem with your product
https://forum.red-gate.com/discussion/80787/required-permissions-changed-after-upgrade
https://forum.red-gate.com/discussion/80448/new-permissions-needed-for-monitoring
https://documentation.red-gate.com/display/SM7/Permissions7 votes -
Save the deadlock graph as pdf
I would like to be able to save the deadlock graph as pdf or maybe be able to send the page as an email
7 votes -
Monitor for unavailable disks
I'd like to see SQL monitor check for disks that were previously available but are no longer. Example: I have a machine were a disk is online, something goes wrong and the disk goes offline. I would like SQL monitor to alert me to this. If the disk contains database files I would get a database unavailable alert, however if it is a drive that holds backups there would be no notification until the backups start failing.
This would have to be setup differently for clusters where a disk may exist on any node in the cluster due to failovers.
…
7 votes -
save list of top 10 queries to excel
I would like to be able to save the list of top 10 queries to excel to deliver to developers in different sort orders
7 votes -
Remove a user/group from SQL Monitor
It would be desirable to be able to remove a user and/or group from SQL Monitor.
At present, there are no options to manage them, only add them.7 votes -
Baseline WaitStats
SQL Monitor contains an aggregated baseline of wait stats, however there is no way to tell if the current wait stats are "normal" for my environment. For example, we had a problem where LCKMX went through the roof, and as a consequence HADRSYNCCOMMIT plummeted because there was fewer insert/updates/deletes happening. The net difference suggested that there was no problem, but there was.
I'd like to see something that shows what's "normal" for each wait type, and what the recorded value is.
7 votes -
Blocking process report does not display database name
I would like to see databasename and also starttime and endtime in the blocked process report. It qwould also bee good to be able to scale the picture in size.
7 votes
- Don't see your idea?