Suggestions
Welcome to the Redgate SQL Monitor feature suggestions list. Tell us how we can improve SQL Monitor by voting on these suggestions or by submitting your own ideas.
This is the easiest way to make an impact on SQL 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 SQL Monitor forum.
-
Job duration taking too long - triggering WHILE job is still running
CONTEXT: If a job is taking a long time (outside of some predefined threshold), we want to be alerted about it. That’s often an actionable alert – we could decide to stop the job, we could let the users know that report XY will be late as a consequence etc. One step further is being alerted on the job STEP level as well.
PROBLEM: Current alert “Job duration unusual” is triggered AFTER the job completes, if it meets the alert's criteria. We need an alert to trigger WHILE the job (or job step) is still running, but the criteria is…
30 votes -
TempDB unexpected growth
I think it would be a good idea to have information about what caused random sudden growth in tempdb. I know we can see the DB size chart but theres no way to know what caused it.
Information that would be nice to be captured:
Table name
What query created table
What user created table14 votes -
be able to report on deadlocks
Add the possibility to report on deadlocks. The information is stored in the database as an alert but it's currently not possible to report on alerts.
I'd like to see the occurrence of deadlocks over time, per database,...
6 votes -
Alerting on Autogrowth Events
Alerting on Autogrowth Events, some environments set the file size of their databases and would like to be alerted if autogrowth occurs since that indicates abnormal behavior
1 vote -
SQLMonitor consider the SQL Server cluster name as an instance
SQLMonitor consider the SQL Server cluster name as an instance
6 votes -
Customize Disk Space alert for C: drive on all servers
SQL Monitor allows me to set global settings for Disk Space alerts, and then override for a complete server group, for all disk of one single server, or for a specific disk.
What I want is to have different settings for the system drive (C:) as compared to the other drives, Currently I need to set this for each individual C: drive, so one change per server.
Please make it possible to specify global settings (applying to all disks on all servers), and then add an override for C: on all servers.
4 votes -
Displaying the actual names of the disks and not just the Volume Number for the Disk space alert
In SQL Monitor when you are using the disk space alert in conjunction with multiple volumes on different mountpoints SQL Monitor tends to display just the HardDisk Volume number in the alert, this is extremely unhelpful as it means you have to log on to the physical server, launch diskmgmt.msc and match the disk thats alerting to take any action. Is it possible to just display the mount point name as opposed to the Disk Volume Number? This would be extremely helpful and would give a wealth of information instantly.
13 votes -
Email Reports as an attachment
I know that it is possible to email report on a schedule basis.
But it only sends a clickable Link to the report.
Is it possible to send a PDF as an attachment on a schedule basis?12 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.
5 votes -
Perform an action when an Alert is Triggered
It would be great if you could perform and action when an alert is triggered. For example if a service down alert is triggered maybe run some PowerShell code that could start the service.
I have noticed that some of the competitors now offer this e.g. APEX SQL Monitor:- https://knowledgebase.apexsql.com/use-custom-command-alert-actions-apexsql-monitor/
5 votes -
Overview database growth estimation
When planning new server we have to estimate how much space will be taken by database during life cycle of new SQL server and when SQL monitor watching server for us I would like to have possibility see following:
- Database file size portion
- Log File size portion and how much of that contain free space
- Estimated growth (as information in Alert)
- Summarized size per disk (if possible with how much space left)
- Have this available as summary tile in the report, so I can reactive this info as email.Thanks and regards,
//Radek
1 vote -
Timestamps in UTC
Currently, timestamps in charts and elsewhere are displayed in local webbrowser timezone. I need all the timestamps in UTC. I need to share screenshots with colleagues in different timezones and having them in UTC is a must have.
7 votes -
Option to include @Channel or @User in Slack Channel Notification
Provide an option for individual alerts to include @Channel or @User to the slack channel notification.
5 votes -
Dark Theme!
Would love to be able to have a Dark theme for the UI.
We use a number of other tools where this is an option and really appreciate the saving of the eyes from the sea of white/ other bright colours.
15 votes -
filter the queries to see in the top queries and long running queries section
In top queries and long running queries section, I can see the queries executed by the db system but I want to filter out such queries.
4 votes -
Set alert rules on specific AG nodes
Our AlwaysOn AG groups are backed up from the secondary node (the preferred node). Not Backed Up alerts still show for the primary node. We would like to be able to filter these out.
4 votes -
Set up multiple custom alerts for a single custom metric
For some custom metrics, the ideal number is not a fixed number. (E.g. ideal number of VLFs depends on log file size). In those cases I write a custom metric that returns a "percentage of ideal number". I like to be warned both when the actual number is too high and when it is too low so I would like to set up two custom alerts for this.
This is currently not possible without creating a copy of the custom metric, which of course wastes resources. Please consider adding the option to set up multiple custome alerts for a single…
6 votes -
Filter Top 10 queries/waits by database
I would like to see the top 10 queries by database sometimes instead of the entire instance.
17 votes -
see the sql_handle under query details under top 10 queries
to find an execution plan in the plan cache when the plan is recreated
12 votes -
Remove a user/group from SQL Monitor
It would be desirable to be able to remove a user and/or group from SQL Monitor.
At present, there are no options to manage them, only add them.7 votes
- Don't see your idea?