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
724 results found
-
Database name "like" filter for "Database Unavailable" alert
In our environment we have several systems (3rd party ETL/reporting packages) that create and drop databases as part of their normal operation.
Would be good if the "Database Unavailable" alert allowed configuring to ignore drops of database names either matching a "LIKE" filter or perhaps more advanced a regex filter.
15 votes -
In the backup check would like it if we could select the times of the backup to then show that group
in the Estate > backup page you are able to see issues such as RPO 1 week. it would be good to be able to click on this to then show the backups listed (fade the not appropriate backups).
6 votes -
With the AG Groups it would be good to have soft alerting on configurations
With the AG it is possible to have different configuration on the server replicas. We mostly get caught out with Logins. but have had issues with XMLBlob size, linked servers and Server Master Keys.
It would be good for monitor to alert (or be able to alert) if a Login does not exist on both (all) replicas. we have times when a quick addition through SSMS does not put the same login on all side. when fail over occurs we then have broken processing. It would be good for sids to be checked as well as this is another issue when the SQL Auth is used but sid on both sides is different.
We also have Service Master key issues where different keys are set up then the database master key will fail on AG Failover and need manually opening. a simple check on both sides would be useful.With the AG it is possible to have different configuration on the server replicas. We mostly get caught out with Logins. but have had issues with XMLBlob size, linked servers and Server Master Keys.
It would be good for monitor to alert (or be able to alert) if a Login does not exist on both (all) replicas. we have times when a quick addition through SSMS does not put the same login on all side. when fail over occurs we then have broken processing. It would be good for sids to be checked as well as this is another issue…
6 votes -
We would like to send slack messages to different channels depending on the server.
We have multiple teams who are ultimately interested in what is wrong with their platform, The posting to a single slack channel is good, however giving an option to send only messages from certain servers to specific channels would improve our customer engagement. currently the main channel is ignored by the all teams except the dba's as the chaff from other servers can cause disinterest, or interest when no reason for a team to investigate.
9 votes -
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 -
Word Wrap Alert Comments
Super minor detail, but it would be a more pleasant experience if I didn't have to use a scroll bar to read comments on Alerts. If it were word wrapped in some manner it would make the user experience better for me.
5 votes -
Select custom date range in Estate - SQL Agent Jobs
Would like to be able to view SQL Agent Jobs between dates. Currently you can pick from Day - Week - Month but it would be really good to have "Custom" also which allows you to select start and end date.
90 votes -
Ability to not monitor/show certain queries in the TOP 50 list.
The top 50 query view in SQL monitor is showing the query that is running on the service broker queue with explicit waitfor statement. In our server these waitfor is 5 min and we have 100 threads that runs for 5 minute and wait for the messages in the queue.
The query monitor shows these query as the top slow performing queries, but in reality these are not slow queries, they are just waiting for messages in the queue. We need a way to not show up the queries in top 50 list, so the queries that are actually slow can be addressed.The top 50 query view in SQL monitor is showing the query that is running on the service broker queue with explicit waitfor statement. In our server these waitfor is 5 min and we have 100 threads that runs for 5 minute and wait for the messages in the queue.
The query monitor shows these query as the top slow performing queries, but in reality these are not slow queries, they are just waiting for messages in the queue. We need a way to not show up the queries in top 50 list, so the queries that are actually slow…7 votes -
I'd like it to be more obvious that an active alert is no longer a current and unresolved issue
Whenever an issue is flagged, for example in the night, it changed the server to red. Once you click on that, the state is "active" (more un acknowledged I would say if not current). For me it is not clear if that issue is still ongoing or that it had been an issue and is now resolved.
Can it be made clear what the end time is if the alert is no longer active? (right now only start time is listed)2 votes -
In SQL Monitor, I want to use a variable description in a custom alert.
Some custom metrics could be about things like a specific disk, job or DB-object. At this moment it's not possible to specify those in a generic Alert.
If besides the metric value a descriptive value was allowed, it would be possible to parse the descriptive value into the Alert.3 votes -
Automatic validation of regex for Long-running query configuration
When applying regex filters for long-running queries, a malformed expressions causes the page to just drop the error and not take the save action.
My suggestion is to just implement a basic regex validation and prompt/indication on error.2 votes -
Disable specific alert for some time
Make it possible to ignore a specific alert for a specific server for x amount of time. Sometimes there is something going on for say half a day and you do not want to miss out on other errors but just that specific one.
2 votes -
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 -
be able to switch support for cloud-features and off based on company needs
Some companies still operate on-premises only, others operate only for Amazon RDS xor Azure. Having all these cloud-database features enabled clutters the user interface and I'd rather like to enable/disable such support through configuration options like
[ ] enable Amazon RDS
[ ] enable Azure SQL
[ ] enable Azure Instance
...
[ ] enable Oracle/xxx/yyy features5 votes -
Monitor Disk Overallocation
Recently we ran into disk space issues on a server. Looking into that, it was discovered that a 10TB database had 3TB in "Unused" space. That is the space was allocated to a table, but the table needed to be reorganized to recover the space. sp_spaceused shows this space, and a disk report of top tables clearly showed the Unused space. This was not something that Redgate noticed. Going back over our estate, we discovered there were more such databases where we could recover space. This could also be noted at an individual file level. Reorganizing that one database has freed up 50GB per file across 28 data files and 70GB per index file across 12 index files. That also would be useful to know.
Recently we ran into disk space issues on a server. Looking into that, it was discovered that a 10TB database had 3TB in "Unused" space. That is the space was allocated to a table, but the table needed to be reorganized to recover the space. sp_spaceused shows this space, and a disk report of top tables clearly showed the Unused space. This was not something that Redgate noticed. Going back over our estate, we discovered there were more such databases where we could recover space. This could also be noted at an individual file level. Reorganizing that one database has…
2 votes -
Email queuing
Basically, I would like email to queue up in SQL Monitor. In the event an email fails to send (account locked out, mail server down, etc), having the email just fail to send is not the desired result. When problems are resolved, the email should send.
For example, lets say IT is doing scheduled maintenance on the email server and during that window one of the SQL instances shuts itself down due to an error (for arguments sake, lets say out of disk). SQL Monitor will see it go offline and try to send out the alert but fail because the mail server is down. When the mail server comes back up, I still want to be notified as it is better to have a late notification than no notification. I'd rather see that the SQL instance went down an hour ago and the notification took a while to arrive than get a phone call telling me that my SQL instance is down.Basically, I would like email to queue up in SQL Monitor. In the event an email fails to send (account locked out, mail server down, etc), having the email just fail to send is not the desired result. When problems are resolved, the email should send.
For example, lets say IT is doing scheduled maintenance on the email server and during that window one of the SQL instances shuts itself down due to an error (for arguments sake, lets say out of disk). SQL Monitor will see it go offline and try to send out the alert but fail because…7 votes -
see an administrative web-based log viewer
Having the ability to review logs in a web-based interface is useful for administrators of a tool so we can diagnose and remedy some problems without needing to reach out to support. The downside is the log needs to be filterable or multiple log files need to exist.
An example of a log that would be useful would be an email log. In the event an email fails to send, I'd like to know why without needing to download the entire log in a zip, extract the zip locally, and browse through it when I am looking for a specific issue (email) and I should know a rough estimate as to when it started failing.
Email is my example in this case simply because that is the error I hit this morning - an email that I expected to be sent at 12:15 AM didn't arrive. IT was doing work on the email server around that time, so I expect that it failed because the mail server was down during the time it tried to send it.One HUGE advantage to this was noticed in a different tool called Jira Software. The tool has a log analyzer that scans through the log for errors and then presents the administrator with a list of errors, written out in plain English so it is easy to understand, and includes a link to the Atlassian support article on how to correct the error. It isn't 100% accurate, but it is much nicer than spending 2-3 days working with support to resolve an issue that I can fix myself by looking at the log analyzer.
Having the ability to review logs in a web-based interface is useful for administrators of a tool so we can diagnose and remedy some problems without needing to reach out to support. The downside is the log needs to be filterable or multiple log files need to exist.
An example of a log that would be useful would be an email log. In the event an email fails to send, I'd like to know why without needing to download the entire log in a zip, extract the zip locally, and browse through it when I am looking for a specific…2 votes -
A way to showcase all SQL Statements running for a specific time frame
A way to showcase all SQL Statements running for a specific time frame. This is will be helpful to investigate any issue that occurred in the past.
5 votes -
Suspend Monitoring of Individual Cluster Nodes
Alert suppression windows can be applied to groups, clusters, instances, and machines - including individual cluster nodes. Howerer it seems it is only possible to suspend monitoring for instnaces or clusters not individual nodes,
We recently had a hardware fault and it would have been helpful to suspned monitoring of a specific node whislt the engineer resolved the fault.
6 votes -
Long-running query Alert - time based parameters
I need to disable monitoring long running queries at night.
My proposal is that you could add new parameter to alerts
Time from - Time to which will exclude monitoring during this time.That will help to exclude ETL - ssis, and other long rununig queries which we set up at night.
6 votes
- Don't see your idea?