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.
665 results found
-
auto refresh
I'd like the Analysis Graph to auto jump to present every 1 mintue
1 vote -
Raise Free Space alerts on disks that are mounted, rather than simply drive letters/volumes
In our clustered environments, instances are given a small drive for mounting the larger data/log/etc volumes within them.
Whilst we always get a "disk full" warning on the mountpoint drives (subsequently disabled), there appears to be no ability to monitor the volumes that are mounted within, where we do care about free space.
I do see that metrics for IO, latency etc are done on a per volume (not drive letter) basis, so would be great if we could have consistency.12 votes -
Analysis Thresholds
One of the things I like about the free PAL tool, is that you can specify thresholds for each performance counter. Therefore, you can have a customizable red line which appears on your graph to easily tell you if your disk latencies are over 25ms or your free memory is less than 5% - for example.
I would like to see something similar on the Analysis screen on SQL Monitor. I would like to specify for each machine, SQL Server or Custom metric a warning threshold and a critical threshold. This makes it easier to troubleshoot performance issues as you…11 votes -
Add "not started within X minutes" delay before SQL Agent status alert raised
In an unpredictable maintenance window environment, as in, SQL Monitor's abilities in the window setting arena are inadequate, there are a reasonable number of times when SQL Agent is restarted with good reason.
As alerts are tied to pagerduty, it's a one size fits all Alert at present, which isn't helpful.
If a "delay emitting Alert for X time periods" could be added to this Alert, the short-duration bounces will go un-alerted, which really helps on call personnel to avoid unnecessary awakenings for "it is of no matter" Alerts.
In my case, there are 24 recorded incidents of this Alert,…
9 votes -
Sorting for columns in Host Machine Metrics
The OverViews page provide lots of useful information about our SQL servers including being able to see all of the disks on the host machines. However the order of the disk names seems random. Can we have sorting enabled in this section so we can sort by space used or Disk
4 votes -
Add additional perfmon counters
It would be useful to have configurable perfmon counters available in "Analysis" above and beyond the out-of-the-box counters.
65 votes
Daniel Rothig
responded
For SQL Server perf counters, you can create a Custom Metric against sys.dm_os_performance_counters. For Machine perf counters, you have to use CLI at the moment
-
Do other tasks than send email on new alert
It would be nice if it was possible to allow other tasks when a alert is raised. Other tasks which could be called: Script file, url, exe file.
94 votes -
Easily determine am/pm from the graphs.
Currently it isn't clear by looking at a graph if the times are AM or PM. It would be helpful if hovering included AM/PM as well as the left and rightmost times shown on the bottom of the graph. It is confusing and takes effort to determine if I"m looking at morning or night.
1 vote -
Login via https
Is there a configuration setting to force the SQL Monitor login page (or entire site, preferably) to https?
10 votes -
The "Output" area for Deadlock events should be resizable
When viewing a Deadlock event, you can go to the "Output" tab to get details on what T-SQL was running when the deadlock occured. However, that window is quite small, and is not resizable.
3 votes -
REDGATE Monitor 5.1.2.3497 e-mail alert body should give detail with deadlock victim spid and query
REDGATE Monitor 5.1.2.3497 e-mail alert body should give detail with deadlock victim spid and query
2 votes -
Overview screen show as a list
Show the overview screen as a list of servers. If you have a large number of servers to be monitored, there is no way to see all of them at once (other than zooming out of the screen). It defeats the purpose of monitoring if you can't see everything.
4 votes -
Have audible alerts on SQL Monitor
It would be very helpful to have a configuration setting to make alerts audible (something like a beep or alarm ring). In the office we have a screen that displays the SQL Monitor where the alerts are only noticed when people look at the screen, which is not very often.
An audible alert of 'red' alerts would prompt us to action them straight the way.
32 votes -
Monitor if all SQL Server related Windows services are running, especially Redgate SQL Backup Agent.
I have found that backup jobs fail, due to SQL Backup service not running. Knowing that the service has stopped would be a great metric to have. This could then be extended to monitor other Windows services.
9 votes -
allow more configuration options for the 'Job duration unusual' alert
The 'Job duration unusual' alert is based off of the last ten runs of a job. I think allowing a configurable number of runs to be a baseline or better yet, the last x runs at the same time of day would be ideal.
33 votes -
SQL Monitore: I would like to see the response time I/O of database files.
SQL Monitore: I would like to see the response time I/O of database files. Currently it is showing only on instance level but how can I see response time of a particular
database.11 votes -
I only have one SQL Server, take me to the instance Overview instead of global dashboard
I only have one SQL Server instance, instead of seeing one small bit of info and having to click that in the new global dashboard, take me directly into the instance so I can get relevant info on first login/site visit. Think about your design when we just have one server.
5 votes -
Group / Sort custom metrics
We have a lot of custom metrics and the current interface is not robust, being able to group / sort metrics in folders or in a tree would be very useful. Also the selection box in the analysis tab is not large enough to navigate a useful number of custom metrics
5 votes -
Baseline machine metrics across cluster failovers
CONTEXT: Using the Analysis graph for historical performance analysis of machine metrics on a cluster that failed over at least once
PROBLEM: Machine metrics are collected per node. Baselines of only one node can be shown at a time, and so no baseline view of performance on the "active" component can be synthesised.
EXAMPLE SOLUTIONS:
• Enable multiple simultaneous baselines
• Implement synthetic (bimodal) baselines across cluster nodes
• Provide synthetic metrics for entites on the "active" component of a clusterWhat do you think about these solutions? Got another idea? Let us know in the comments!
18 votes -
Jobs in calender formart so you can see when they are all schedualed.
It would be nice if you could see all jobs on the server. Perhaps in a calender format so that you can see when they are schedualed. It would be nice if you could drag and drop so that it changes start times. It would be nice if you could see the job history as well.
83 votesDaniel Rothig
responded
We like the idea – if this idea gains traction, we’ll look into implementing something like this
- Don't see your idea?