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.
788 results found
-
Monitor individual CPU cores and not just avg CPU as a whole
AVG CPU is not enough of an indication of how things are going - There could be an entire numa node maxed at 100% while other nodes are almost idle and it will drag the avg down.
As per here: https://forum.red-gate.com/discussion/comment/162141#Comment_162141
13 votes -
Have ability to configure alerts to be active for various periods.
I have multiple alerts (including custom alerts) on serves. I would like to configure alerts to have different thresholds for diffident periods (weekday/ weekend) OR (mornings / evenings ) OR other periods.
Like log sizes on weekends (mostly due to index maintenance) can be much higher than weekdays.
Current "alert suppression windows " applies to a host and to all alerts on it and not to specific list of alerts.
1 vote -
DatabaseName custom message parameter addition for Custom Webhook messages
I would like to share with the developers the alerts for the different databases we have in the same server instance. I noticed for custom webhook messages. It looks like the option was there (like monitoredEntity.azureSqlDatabaseName).
One of the SQL instances we have is a shared instance with multiple databases so the owner of the database can know exactly what database is failing
Right now I have the following custom message
{
"text": "{{alert-severity}}: An alert of type \"{{alert-name}}\" has been \"{{alert-status}}\" for {{alert-target-name}}.\r\nVisit {{alert-url}} for details."
}
Where I cannot specify which database is that alert for. I consider…
4 votes -
Connect to Azure database via express route
Currently I'm only able to connect to Azure SQL Server (PaaS) via internet and URL servername.database.windows.net.
We have a direct connection to our Azure environment via Express Route. Therefore I want to use this also for the monitoring, but per default SQL Monitor uses external URL.
3 votes -
Display parameter list in the query plan form
It would be great to be able to see the parameter list from the query plan in the "Query Plan" form without having to download the plan and traversing the XML file.
It would save time troubleshooting problematic queries.
4 votes -
ERRORLOG tab on Alerts
When we are viewing an alert, it would be nice to have a view into the ERRORLOG at that point in time. If we could have the option of adding an ERRORLOG tab under the Performance Data section on each alert, that would be handy.
3 votes -
Add a Description field in the Databases section
Dashboard, drill down to the Databases Screen. In that section, there are currently 4 fields or columns - Name, Availability, Transactions/sec, Database size. Will it be possible to add another string field to store a high level description of the database; this will be really useful for our users. Can the new field comes after the name, be 200-300 characters in length and can be a pop-up if a mouse pointer hovers over it. Many thanks.
1 vote -
3 votes
-
Separate notification option for both Medium and High Severity alerts
It would be better to have Separate notification options for both Medium and High Severity alerts instead of a single distribution for both Medium and High severity alerts so that separate group get notifications depending on the severity of the alert.
12 votes -
Have a way to exclude Deadlock alerts based on the T-SQL or Proc name
I would like to exclude alerts for deadlocks based on a procedure name or other T-SQL, just like I can do for LRQ and other alerts. Please see http://productsupport.red-gate.com/hc/requests/170766
1 vote -
show sql related windows event log entries
Rather than going through all Windows event log entries looking for SQL related events on every monitored server, it would be good to have them displayed on the server screen along with the SQL Error log entries.
1 vote -
1 vote
-
Extend field width of Server Selector field on top of Dashboard to be the same width as the Drop Down
Go to Dashboard; Overview tab; drill down to one of the servers. On top of this next form (Server Host Metrics form) is the Server Selector field with a Drop Down list box. When you select the down arrow key to open the List Box the width of the List box is about twice the width of the Server Selector field. Is it possible to make the width of the Selector field the same as the drop down or make it user defined/variable? Right now it's around 27 chars. We have long server aliases/names so if extended, it will help…
1 vote -
Configure job duration unusual alerts to ignore negative variances
Typically (although there are exceptions) I'm not concerned if a job has a high negative variance compared to baseline. One other way to satisfy this would be another suggestion already in here, allowing for more configurable options such as a floor/ceiling variance .
7 votes -
Record queries terminated by the client
We use an ADO client with a query timeout of 30s by default.
These queries are not being captured by SQL Monitor. If they were, it might highlight the cause of why they are taking so long.
For context, we have a query that regularly takes a couple of seconds to execute, but every hour or so exceeds the 30s timeout and we would really benefit from SQL Monitor to capture those to help diagnose why.
1 vote -
Suppress Free Space monitor (Azure Hyperscale DB)
When using Azure Hyperscale DB - the DB auto grows - therefore the Free Space monitor needs to be silenced/ignored forever (except if you about to hit the max of 100TB!)
5 votes -
Alert for full filegroup
if a database is a fixed size (max size set), or if the db is initially set to be the full size of a disk, there is no alert to let us know that the database is full.
for instance - if T: drive contains tempdb (and only tempdb) and we've sized it to take the whole drive. we've done funky sizing and growth settings so we can get an alert when the db grows, but once its grown and the temp objects are cleared, we're unlikely to get another disk warning, because the DB will already be taking 100%…
6 votes -
Be able to run a query (or powershell) in response to an alert
Be able to run a query (or powershell) in response to an alert.
This would automate some responses, but also want to be able to send the RESULT of a script in the email that goes out, ie Alert to say Schema changes have been made where the email actually includes the schema changes.11 votes -
Filter for Database with no Tlog backup
On the Estate->Backup page, it would be great to have an additional drop-down option for 'DBs without Tlog"
2 votes -
Add AND/OR conditions for disk alerts
We are using SQL Monitor to monitor disks and we also send these disk alerts to our NOC(24/7 monitor team) and when they receives an alert they are calling us on our On-Call service when outside office hours.
The alerts are not always relevant as the alert can be like for example:
Disk free space less than 5 % but actual space left is 300 GB, which is more than enough and no alert and phone call had to be triggered.We are trying to set custom disk alerts but as we have 1000+ disk alerts to configure it’s impossible…
44 votes
- Don't see your idea?