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
-
Show Compressed Backup size on Estate > Backups Screen
Currently the backup size displayed on the Estate > Backup screen is the uncompressed backup size which is useful but it would also be useful to include the compressed backup size because that's going to be the raw file size on disk when backup compression is enabled.
Knowing the compressed backup size is pretty useful when trying to assess how big a backup will be on disk.
6 votes -
Enter and assign purchased SQL licenses to VM hosts, VM or server
The new SQL licensing tab would even make it possible to detect unlicensed instances depending on listed availability or improper VM host movement rules.
6 votes -
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
6 votes -
Ignore failing jobs using regex
the config for JOB DURATION UNUSUAL alerts allows the use of regex to filter the jobs to ignore.
this functionality would be very useful for FAILING JOBS alerts
6 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 -
Trace schedule
Could the new "Trace" feature have a schedule as well as an on/off? If not this then how about a third option "Trace until date/time"?
Thanks
6 votes -
Customize alerts at the host level in a windows cluster
Currently you cant customize host level alerts at the host level only at the windows cluster level.
A few scenarios where this is needed :-
Always-on cluster where one node is for the application and you have a read-only secondary for reporting. I need to be alerted for the application node for high CPU, but the report server is usually often hits 100% CPU during business hours.
Multi node regular failover cluster with different application owners. 3 nodes, app1 lives on node1, app2 lives on node2, node 3 is a passive node for both. Alerts for app1 need to go…
6 votes -
Have a custom message added to alerts
When an alert is emailed, I want to place an action (possibly including an html link) as a comment on the alert.
This would allow the recipient of the alert to solve the issue directly.
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 -
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 -
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…
6 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 -
Attach Custom Documentation To Alerts
I'd like to be able to customize things like an alert that job X has failed with a link to our own documentation on how to troubleshoot that job. It would be even better if these links could carry forwards into the slack notifications but even just having them on the alert page in SQL monitor for that particular alert would be immensely useful.
6 votes -
Add a process that automatically checks to see if a stand-alone SQL Instance has become an Always-On Availability Group
There is a stand-alone SQL Instance that is being successfully monitored by SQL Monitor.
The SQL Instance importance has increased and the SQL Instance becomes an Always-On Availability Group. This change is not detected by SQL Monitor.
The work around is to remove the SQL Instance from being monitored and re-add, the SQL Instance for monitoring so that the change is detected.
Add a process that automatically checks to see if a stand-alone SQL Instance has become an Always-On Availability Group or has been removed from a Availability group to become a stand-alone instance once again.
6 votes -
Dashboard view for multi-instance environment
We have multi-instance SQL Server on one VM.
Today on dashboard we have waits for instance, and we need processor usage for instance also.We would prefer to have on tile:
1. Waits for instance
2. Procesor for instance
3. Disk i/o for instanceWe should have also tile which grup all instances into machine. On machine tile we shoul have the same information as for instance but measuers would count machine indicators.
There would be also great if You would add new dashboard view for multi instance environment.
My proposal for view in atachment (I am not a professional…
6 votes -
Have option to keep the base instance name in display for availability groups
We have the option to choose between Windows cluster name and FCI network name for FCI. However, in an Availability Group scenario, every instance is being show by the cluster name first, which is obviously the same for all of them. This makes it difficult to identify the correct one when you need to look at a specific instance. Would like to add this as a configuration option so that clustered AG servers we can also choose whether to use cluster name or instance name as display
6 votes -
Outlook calendar style view for SQL Agent jobs
This would be very useful for viewing all scheduled jobs in an Outlook-style calendar view. Also useful for scheduling new jobs to prevent conflicts.
6 votes -
Ability to add notes to tracked queries
When working in an environment with multiple people is typical that each person is tracking different queries to analyse ongoing changes/improvements.
Being able to note something as "Tracked by Cláudio. Following FIX #1234" would be great.
It will give us a clue on who is working on what and reach out to that person. Or just keep small notes during the analyses.
6 votesA great suggestion. We are exploring this as part of a wider review into improving query tuning features.
-
Being able to filter "TOP Queries" by any of the columns
On the "TOP Queries" grid we can order it by any of the columns (besides "Database").
I would like to be able to filter the rows by the amounts.
Example:
Filter queries where "Execution count > 100" same for other columns.
Then apply the "order by".This way we can filter together with the "Enter search term" box.
6 votes -
custom group order
I'd like to be able to pick an order of my groups... dev, prod, staging in alpha I'd prefer to see prod, staging, dev.
5 votes
- Don't see your idea?