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.
714 results found
-
allow analysis graphs to update with realtime data without having to manually refresh them
We have SQLmonitor analysis graphs running on wallboards to show us data that is useful to us, but we continually need to click the button to "jump to present", as the timeline does not update as more data is collected to show the most recent history. We want the graph to move automatically to match the current time of day.
Maybe a "play" button that would allow thye display to automatically refresh the graph along the timeline and a pause button should you want to drill deeper into a certain time period when investigating issues. Having the graph update automatically…19 votes -
In the Analysis tab, it would be better to have an option to change the font from grey (very hard to see) to black/dark blue or something
In the Analysis tab, it would be better to have an option to change the font from grey (very hard to see) to black/dark blue or something
6 votes -
More options for Custom Metric Frequency
Would it be possible to have a custom option for the Custom metric gathering, as it stands the data can be collected at intervals of 1,5,10,30,60,1440 minutes
it would be nice to be able to select a custom value and values less than a minute, the standard metrics that are gathered appear to be gathered every 20 seconds which isn't an option here
Thanks for your time and concideration
Ste9 votes
Daniel Rothig
responded
Note that you can currently hack an arbitrary “seconds” value into the SQL Monitor database – but changing the Custom metric configuration via the UI will reset the collection interval to one of the default values.
-
Custom metric: alert when value changed
I want to be alerted if someone creates or deletes a database. The metric itself is easy (select count(*) from sys.databases - executed for the master DB on all servers).
But in the alert setting I can only define that it should trigger if the new result is abover or below a set value but not for value changed (compared eigther to the previous value or the "baseline").
So I have to create two metrics / alerts for DB drop (below) and create (above) AND have to define / modify the number of databases as alert threshold for each server…
19 votesDaniel Rothig
responded
-
Search through (closed) alerts for a string.
It would be great if we could search closed alerts for a string. For example I want to see all the alerts that have included a particular view in the query text.
(Also include comments in the search)
69 votesDaniel Rothig
responded
We’re looking into this – no ETA at the moment
-
Allow Fractional Alert Thresholds.
When you use the "Calculated rate of change" functionality on a custom metric, the results come back in fractional values and you should be able to alert on these values. In my case, I want to monitor number of orders for the last 10 minutes. There are always relatively few orders at night and many during the day, but if order flow drops off drastically in a short period of time, I want to know about it.
Unfortunately, I can't just alert when the rate of change drops by 25% (-.25) because alerts can only happen on integer values. 100%…
4 votesDaniel Rothig
responded
A current workaround is to multiply the result by a factor, eg. 100 to make the result a percentage.
-
Add an analysis metric for Total bytes sent/received over the network interfaces
There is an analysis metric that currently exists for Network Utilization, which I believe is calculated based on the total bytes sent/received over the network interfaces divided by the bandwidth of the network interface. It would be great to add the raw delta bytes/megabytes sent/received/total as a metric on the analysis and overview pages of Sql monitor.
14 votes -
Capture cursor SQL for long running queries
It would be great if SQL Monitor would capture the SQL statement being executed for long-running cursors. Currently it shows "FETCH CURSORNAME001"
Cursor SQL can be found with this query when the cursor is still open:
SELECT c.sessionid,
c.cursorid,
c.properties,
c.creationtime,
c.isopen,
c.fetchstatus,
c.dormantduration,
s.logintime,
t.text
FROM sys.dmexeccursors (0) c
JOIN sys.dmexecsessions s
ON c.sessionid = s.sessionid
CROSS APPLY sys.dmexecsqltext(c.sql_handle) t14 votes -
Ability to change the width of list of metrics at analysis page
The small width of list of metrics makes difficult to read list of metric if it has metrics with names over 20 chars. See attached screenshot.
5 votes -
Option to filter(replace) sensitive SQL from alerts displayed/recorded
Similar regex functionality to how processes/queries can be excluded from an alert but to hide or better yet not record sensitive SQL/SQL fragments
10 votesDaniel Rothig
responded
Good idea – thanks!
-
Add day name(sat, sun, mo etc) of date to analysis screen
Add the day name of date to analysis screen.
Currently only the date and time is displayed on the graph lines dots.
6 votes -
Add plus/minus tolernaces for unusual job durations
Allow different tolerances to the plus and minus percentages for the "Job Duration Unusual". In some circumstances (especially when there may be a lot of data coming in and the disks are extremely busy), I don't mind a deviation of a few hundred percent positive in the deviation. But a negative deviation of 90% would likely indicate some of the expected data was missing (thus a problem).
1 vote -
Customizing alerts without loosing inherited settings
Would be great to have the possibility to customize alerts on lower levels without loosing the inerited "customizations".
Otherwise there is the need to "copy" all the exclusions made on higher or highest level to the level that should be customized...
In example : i want to add a keyword for a specific query on Database Instance without loosing all the exceptions made for backup and so on.7 votes -
Allow email configuration at the time you configure a new alert.
Once you configure an alert, it automatically defaults to notify the default recipient. However, if I want another user to receive these emails, I have to configure this through Alert Settings. I'd like the ability to set up the email address in Custom Metrics setting, so that everything is done in one integrated place.
3 votes -
Allow custom metrics to be optionally created as "event" alerts rather than default "continuous" alerts.
I have installed the "Used/available database space increased alert" which alerts when defined thresholds of used space have been exceeded. However, once activated, the alert remains in an active state with no additional notifications (easily missed). I'd prefer to have this metric run daily and notify each time a threshold is exceeded.
20 votes -
Include instance-specific name (@@SERVERNAME) on alert mails
The alert mails for a SQL Server cluster contain the cluster name but not the actual instance virtual name. It would be nice if the mails contained the actual virtual name (as given by "select @@servername") so that the email contained all the details needed to connect to an alerting instance.
My cluster name (i.e. CLUST01) is a different IP than my virtual names (i.e. VIRTUALSQL01), which means that I can't connect to my "FOO" instance by "CLUST01\FOO" as the alert email seems to indicate. Instead I need to connect via "VIRTUALSQL01\FOO" which is not present anywhere in the alert…
20 votes -
Monitor an application server
You can already monitor a 'host' machine which does not host any SQL Server instances, but it would be nice if we could also monitor application log locations, services etc.
Maybe Custom Metrics which can use something other than t-sql?
3 votes -
Add capability to export Alert information in csv, xml format for analysis
It would be good to be able to export Alert information for downstream analysis of frequency and timings for Alerts. E.g. Deadlocks over a period of several weeks - allows to identify hotspots and trends for certain Alerts
19 votesDaniel Rothig
responded
(Gathering feedback)
Hi, is frequency analysis something that we could offer in-app, or would you specifically prefer to export the data first?
-
MS DTC down alert....
I would like to see an Alert if MS DTC (the DTC service) has stopped\failed or doesn't restart after a reboot.
1 vote -
Per database table fragmentation.....
I would like to see a a Sql Monitor "information" page that shows the "top 10" fragmented tables on a per database level.
114 votesGood idea! If this suggestion gets more traction, we’ll implement this.
- Don't see your idea?