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.
807 results found
-
Include Custom SQL Code in alerts
When creating custom alerts, I would like to be able to include information that can be retrieved by running a SQL query.
One example is using the pre-built Failed SQL login custom alert that is available to setup. The alert notifies when this event occurs, but it fails to include information like which login failed, etc.
It would be nice to be able to build part of the e-mail body in the alert to include some critical data that can be queries using T-SQL.
8 votes -
Select what alerts i want to receive by Slack, the same way it happens by Email
Slack messages are a little annoying when all the alerts are sent by them.
I would like to configure the alerts i want to receive on slack. Today this is possible to configure in the e-mail option.8 votes -
Improve alert troubleshooting by showing sql server error log
When viewing an alert it may be helpful to see the error log for the server for the surrounding time. RAISERROR can log to the error log, so this info could be useful to see.
8 votes -
Job execution in overview graphs
It would be nice if you in the Overview graphs could see SQL Agent Jobs, just like long running queries, deadlocks etc.
It could be good for troubleshooting high disk IO, CPU etc, if you could see that a job has started running at a point.I've tried to illustrate my idea in the attached file.
8 votes -
be able to show basic SSIS monitoring graphs/sparklines on the overview page (Buffers spooled, Buffers in memory, rows read,...).
There is currently no SSIS monitoring in SQL Monitor. You can add custom metrics for performance counters available through SSISDB but these can only be seen on the Analysis page and only after you have selected all of them.
It would be nice to be able to select SSIS as an option for a server and then see these counters as graphs/sparklines on the overview page.
8 votes -
Add ability to search Server Log
I would like the ability to search the error log or at least filter out some alerts. For example, we get about 45 "Log has been backed up" log entries every 15 minutes. It's very hard to actually find things on redgate without having to login to the SQL server and filter there.
8 votes -
Clone custom metrics for copying
When I have a very simular custom metric, I want create. I have to copy and paste . Can we have a clone custom metric feature?
8 votes -
export the overview page
The reporting is very limited and provides less detail that the overview and estate pages. We need to be able to export the overview and estate pages easily. Also need to be able to report on the Top queries and top waits.
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
- Don't see your idea?