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.
- or
721 results found
-
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
768 results found
-
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% drop is my only option and that would mean that orders stopped completely. In which case, the rate of change is a useless option since I could have just alerted that there were 0 orders in the last 10 minutes.
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 votes
Daniel 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 email (nor nearly often enough in the web UI).
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…
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.
120 votesGood idea! If this suggestion gets more traction, we’ll implement this.
-
When a custom metrics targets specific databases then only those database should be listed on the Analysis tab
Currently a custom metric is listed in the left most list box and the databases are in the right most. Some custom metrics are specific to a single database or a specific group of databases.
In either of these cases the database list in the last list box could be filtered to be only the databases that the metric relates to. This would save clicks and shorten the time taken to get to view the analysis trace.
16 votes -
exclude all of my system databases from the log backup alert
I would like to exclude all of my system databases from the log backup overdue alert as I only perform daily full backups on them. At the moment I have to go into the Config settings and change the alert to disabled for those DBs on each servers.
50 votesDaniel Rothig
responded
When we’ll be improving the alert configuration UI, we’ll keep that use case in mind
-
UI global overiew - add tickerbox with unread alerts
To get a instant view of the unread alerts and their context/importance it might be a good idea to create a tickerbox at the leftmenu of the global overview page.
Currently to know what kind of alert has occured, I have to zoom in/navigate everytime to the alert page.
Layout example: Grouped by server, level, category, datetime
As addition it might be an option to create a tickerbox hide option .
1 voteDaniel Rothig
responded
(Gathering feedback)
Hi brendo, how would you expect the tickerbox to behave if there is a large volume of alerts incoming? Would you expect to always see the x most recent ones, or would you like to be sure that all alerts show up in this tickerbox over time?
-
Alerts with and/or (boolean) logic
To determine performance problem b it is needed to monitor several counter values at once. For example when counter x and counter y and counter z are all below 10 then you have a memory problem. I would be nice to contruct that kind of logic to get true performance alerts.
4 votes -
Alert statistics over time
I would like to see which alerts are firing more frequent over time.
It would be nice to be able to see alert statistics over time, tabluar or graphical.14 votesWe’re reviewing this and would appreciate any more context on what you would like to do with the information.
- Don't see your idea?