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.
710 results found
-
To show top server Process memory usage
Under the "Processes", it would that we can sort the top memory usage as well. There are times we got alert that the server memory usage is high and we need to know what other OS processes is utilizing the server memory other than SQL.
1 vote -
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 -
Update the password of the account with powershell module
I do not want to use the base monitoring account, to monitor the different databases. So I need to use a separate account for that. In order to regularly be able to rotate the password of this account, I would need the PowerShell module be updated with a function to update the password.
3 votes -
For the "Job failing" alert, add the ability to exclude job categories
The "Job failing" alert currently has the ability to exclude jobs based on job name and owner. It would be very useful to also have the ability to exclude jobs based on the Agent Job Category.
2 votes -
Data Export
Export the top querys list with detail as excel file or can be mail to another person.
1 vote -
Increase SQL Monitor email Alerts to larger than 400 KB
We have some alerts for important servers that require you to login to SQL Monitor to see the full details because they exceed 400 KB. The alert currently reads:
"Details
Details omitted because they exceeded 400KB. Please log into SQL Monitor to view them.
View full alert details
Configure alert"Please increase this value so that we can see the full alert details within an email instead of having to login to SQL Monitor to see them.
Thank-you!
3 votes -
Fragmented Indexes
Would like to add row count and fill factor to the alert as depending on how many rows there are depends on whether a reaction is needed
Fragmented indexes:
Index Table name Fragmentation(%) No. of pages1 vote -
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 button for a…4 votes -
Provide AAD authentication mode to connect to Azure SQL server apart from username and password authentication.
Provide AAD authentication mode to connect to Azure SQL server apart from username and password authentication.
Because if Azure SQL is set to AAD authentication only for security reasons in any organization, username and password to add new Azure SQL server/DB under SQL Monitoring doesn't help.
33 votes -
See job history beyond one month
Currently the Estate Job page only offers a view of a day, week or month, but sometimes we need to see trends beyond one month.
Is it possible to add a variable window? Or a fixed one of a year?3 votes -
Webhook notification for Cleared events
We use Webhook notication to push the alerts to our central ITSM tool. The status "Raised" creates an entry, the status "Ended" deletes the entry in the third-party tool.
We would also like to be able to use the status "Cleared" to delete entries. For this, a webhook notification would also have to be triggered when the status changes to "Cleared", which is not yet the case.
2 votes -
custom RPO time
Custom RPO time. Have the ability to adjust the RPO to its values, for example 5 or 10 min. Not only 15minutes.
3 votes -
Alerts and Notifications Export
Would love to be able to export all notifications with details into Excel or CSV. Very beneficial to create dashboards, metrics and KPI for all notifications.
1 vote -
Create a threshold for how many times a job can fail before raising an alert.
We have jobs that fire every minute, or every 5 minutes - similar to heartbeat jobs. If the job fails once or twice, we don't care. If it fails 10 times in a row we do care.
21 votes -
Disk space alert
The disk space alert can be configured on Server-Level as a host machine alert, but the alert is fired for every Instance on that host.
As example, we have 5 instances on a sever, each instance has it's own drive, e.g.
instance1 on drive d:
instance2 on drive e:
instance3 on drive f:
etc.If one instance, e.g. instance2 on drive e: is filling up it disk, the alert is fired for all instances. We would like to see an alert only for the instance that is affected and not 5 alerts.
1 vote -
Add Text Boxes/Areas to Reports
I have reports that I circulate from SQL Monitor. I have to edit these before I issue them to add additional information. E.g. Under the "Lock Waits/Sec" chart I have a description of what a "Lock Wait" is, what impact it has, what's an acceptable value, etc. I tried supplying a supplementary sheet with this info but the management team prefer it under each chart / metric.
1 vote -
Reduce the suggestions on how to fix queries when viewing Top 10 Queries
SQL Monitor pops up the text "x issues with this query". Addressing them could improve performance. It then lists some things that might have an impact (e.g. select * instead of listing just the columns that are required) but also lists other things that won't change performance (e.g. not specifying a schema name).
Can this list be reduced to just what is potentially performance related? Maybe have a 2nd field for best practices if that's considered improtant.
2 votes -
Fix the column headers for the Top Queries when scrolling
On the Server Overview "Top Queries" section, it would be helpful if the header row of the table didn't scroll off the screen. I keep scrolling back up to work out if I'm looking at reads/writes/CPU Time/etc.
5 votes -
AWS FSx drive status
In our company we are using AWS FSx drives for our SQL Server databases. The FSx drives are not real drives, they are more like a shared folder, I'm wondering if there is a way to add those drives on SQL Monitor so we can check disk space and get alerts. AWS has been adding more features for FSx drives to be used on SQL Servers. Right now the only way to monitor that is using AWS console or alerts, which are not very friendly and only available for some system administrators.
7 votes -
deadlock Detailed Report
Please create a detailed deadlock report.
In addition to the existing DeadLock summary report, can you please create a DeadLock Detailed report for all deadlocks for a given time range.
Looking for a DETAILED report of deadlocks (all deadlocks for the time range) that will include:
1. Date / Time of the event
2. Blocking SPID and full query text
3. Duration of the block
3. All Child or deadlock victim SPID and full query text of the victim
Similar to the summary report, will need to be able to select the SQL server instance and / or database to…3 votes
- Don't see your idea?