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.
741 results found
-
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 votes
Daniel 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.
-
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.
42 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.
-
Make software FIPS 140-2 compliant
Currently SQL Monitor is not FIPS 140-2 compliant
5 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
responded
Hi, 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
-
62 votes
-
Deal better with extremely spikey data
CONTEXT: Some counters displayed by SQL Monitor is extremely spiky. SQL Monitor scales its graph such that the any spike fits on the y axis
PROBLEM: If there is one extreme spike, all the other data gets scaled such that it's very close to the x-axis, making any patterns in the data hard to see.
EXAMPLE SOLUTIONS:
• allow to manually zoom into the y axis
• allow extreme spikes to be beyod the drawing area of the graph (still with some indicator of how high the spike is)
• have an option to show the graph on a logarhithmic…133 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
-
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 -
Provide Mobile version of Alert Monitoring Screen
It may be just me (since no one sle has yet to suggest this) but a mobile friendly version of SQL Monitor for the ALERTS tab would be of great benefit. Currently I check the ALERTS on my SMART PHONE which has a screen waaaayyyy to small to do this but since I have no tablet option I have no other choice.
A mobile option at login to SQL Monitor would let those with smaller sized computing devices acccess the ALERTS tab so as to monitor/check in on their SQL Monitor instance remotely.
Thanks
16 votesThere are currently no plans for a SQL Monitor mobile app. We hope to improve the experience when using SQL Monitor on a mobile device. However at the moment we can’t give a timescale for when this might happen.
-
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
- Don't see your idea?