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.
686 results found
-
Activity monitoring for DDL & DML
Add an element that will track all DML/DDL activity within a SQL Server instance and log this to a tamper proof archive. If linked to performance trends this can corrolate performance to T-SQL executed against the instance.
This has scope for aiding with Compliance with PCI-DSS & SoX.
10 votes -
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 respondedA current workaround is to multiply the result by a factor, eg. 100 to make the result a percentage.
-
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 respondedGood idea – thanks!
-
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 -
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 -
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 -
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 -
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 -
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 -
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 -
Make software FIPS 140-2 compliant
Currently SQL Monitor is not FIPS 140-2 compliant
5 votes -
The ability to pull ALL job names
from an instance view their statuses have a high level overview of the success to failure ratios on the jobs listed. Then the ability to export the results to different formats (csv/pdf/html)
9 votesDaniel Rothig responded -
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 -
Collect SQLServer:Memory Manager counters.
This would be especially useful for SQL 2012 where counters have been removed from the buffer manager exist in the memory manager counters. For SQL Server 2012, I have observed that there is a memory leak and this is revealed by observing the Memory Manager Optimizer Memory (KB) counter.
1 voteDaniel Rothig respondedHi, we’re monitoring a few of those out of the box and the rest can be covered via the custom metrics feature – check out sys.dm_os_performance_counters
-
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?
-
How about a custom metric or alert to return data in character value as opposed to just numeric scalar or NULL
I want to have a function much like profiler to collect login data, who logged on & be able to filter on the data collection, for instance, if I only want to see when domain\me connects to the sql server, I would like to track that information. I am aware this can be done with profiler, but I would really like to have the ability to use one tool.
4 votes -
Collecting custom metrics for multiple databases at the same time
ATM, a custom metric can return one value, but sometimes collecting the metric for one database takes the same amount of time as collecting it for all of the databases.
Having a multi-database metric (maybe something that returns a database id -> value map (as a two col table)) would be especially useful if it takes a long time to collect the metric (in my case it takes nearly 30 secs to collect it).
12 votes -
Option to exclude custom metric from Analysis Graph page
When setting up a custom metric, have the ability to exclude it from the Analysis Graph page. E.g. I set up a metric that checks the AutoUpdateStatistics setting for each database and then creates an alert if a database is set to OFF for this setting.
It is however not needed in the Analysis Graph page as it is purely an alert.4 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 -
Add more visibility to captured system processes
A view of all system processes is available whenever an alert is clicked. It would be nice to get the same view of system processes with their CPU and memory consumption for a specified time even of there is no alert to click on at that time.
6 votes
- Don't see your idea?