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 — often the SQL Monitor team will initially stay quiet about new suggestions to see what you have to say!
If you have any questions visit the Redgate Monitor forum.
683 results found
-
track blocking processes date/time by start time, not login time
in blocking tree, it shows old date/times for queries that are running. We found that it is using the login time of the spids (which could be held and sleeping for extended amount of time) instead of the start time of the executing process of that spid.
instead of using the login time, I recommend it uses the start time of the last execution of the query found in sys.dmexecrequest1 vote -
Availability Group alert details
It would be great to see the server name in the mail body which is affected by the alert. Currently it is only in the subject. EG: Raised on detail i the mail body contains the primary replica, the affected unreachable replica is only in the subject.
1 vote -
FCI alerts should refer to the DB instance and not to the active node
For various alerts that are actually assigned to nodes of a Windows FailOver cluster (no AlwaysOn), the alert display shows the active nodes as the source. For example, "Disk average read time" Node1 -> E: instead of the cluster role SQL instance -> E:.
I can more quickly deduce from the name of the DB instance which DBs or which applications could be affected. The names of the nodes are numbered and meaningless.
1 vote -
PaaS dbs on an instance appear seperately
Hi Redgate Support,
While adding PaaS SQL servers, each database appears individually. Will this change in near future where they appear together with other database on the instance like they do on-prem and on IaaS.1 vote -
Control Alerts For Managed Instances Separately From On Prem.
Some guidance for Azure SQL Managed Instances is different from on prem SQL Instances. For instance, there is information out there not to just do routine index maintenance and instead do statistics and only rebuild indexes when there is an obvious problem. Having a way to keep our current alerts for on prem and turn this off for Azure would be helpful.
1 vote
Neil Turner
responded
Hi Tom,
Thanks for your suggestion. Can you provide a bit more context for your suggestion? What goal are you trying to accomplish?
Would the current ability to control alert settings by group not be sufficient for this?
Thanks,
Neil
(SQL Monitor product designer) -
Be able to see and dissect alerts for deadlocks on the AWS RDS platform.
Currently, SQL Monitor does not raise deadlock alerts for AWS RDS database instances. I'd like this functionality to be added, as it's a major feature and selling point for the product.
The current workaround we're using is a combination of AWS performance insights and a SQL script. A "single pane of glass" would be much more efficient.
1 vote -
Improve filters available for alerts
A recent incident I have been working on revealed to me that filters work based on last update which makes it hard to find alerts that you know would have started around a specific time. The ability to filter on start/end times as well as show this information in view returned.
1 vote -
Add Active/Ended as SELECT drop-down options for Events
The current Alerts page Select drop-down has None/All/Read/Unread
For events, such as Disk Space, being able to Select "Ended" to get rid of the noise, helps focus on what needs to be addressed.
If the list doesn't have any Event-type row, don't offer this pair of options.
1 vote -
Add link to disk details on Server details page.
From the Estate - Disk Usage tab we can select the specific drive to get usage details for that disk.
When you navigate to a server from the Overview there is a section that shows the Disk Usage at a high level, but no links to drill into the specific disk.1 vote -
LDAPS Support for user authentication for Redgate SQL Monitor
LDAPS Support for user authentication for Redgate SQL Monitor . Now organization want to make the ldap communication to be more secure and moving to LDAPS communication . LDAP will be discontinued soon . When can this be implemented
1 vote -
annotation
I would like to be able to trigger an alert and notification when I use the RedgateSQM powershell module's Add-SqlMonitorAnnotation cmdlet.
1 vote -
see username and hostname in "top 50 queries" and "top 10 waits"
In SQL Monitor, I want to see username and hostname in "top 50 queries" and "top 10 waits"
Please add username and hostname in "top 50 queries" and "top 10 waits." These two columns will be useful to trouble shoot SQLs that are causing troubles
Thanks,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.
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 -
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 -
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 -
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 -
Data Export
Export the top querys list with detail as excel file or can be mail to another person.
1 vote -
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 -
"Take Screenshot" Feature in Analysis Section
I have the need very often to take screenshots for non-technical management slideshows.
Could you add a button in the analysis panel to take a screenshot of the analysis timeline?
I would like to obtain something like this (with a single click)
https://images4.imagebam.com/c4/e9/b5/MEC1R73_o.png
Thank you
1 vote
- Don't see your idea?