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.
765 results found
-
Customized Alerts
Hi,
Can we get a report which shows top 10 databases by growth over a certain period of time, across all the monitored SQL instances?
There should be one graph which shows top 10 databases by growth, gathering data from all the databases scattered across multiple SQL instances, rather than multiple graphs showing top 10 databases by growth.
It would be nice to have so that we can determine what databases do we need to focus on.
Thanks,
Hammad2 votes -
Generate Notifications using a RESTful API Call
Considering the various ways that your customers may want to receive notifications, the ability to make calls to a RESTful API would be a big win.
9 votes -
Specify a "details" query for custom metric
When I define a custom metric it would be super-helpful to be able to see some details that gave rise to the metric value. For example, I have one for "count of failed SQL logins in the last 10 mins". But to find out which logins failed, I have to go run queries in SSMS.
I'd like to be able to define a "details" query on the custom metric, the results of which are captured at time of collection, and are then available from the alert.
76 votes -
Apply filters to more SQL Server alerts
In configuring Long Running Query, I'm able to specify a filter on the process name (e.g. wanted to exclude my "Barracuda" backup processes - and did so successfully). I'd like to do the same for other Alerts such as Deadlocks and Blocking Processes.
5 votes -
Print the server overview
Print the server overview (scroll) to share with team members to assist in correction of failures.
3 votes -
Add COMPARE BASELINE option to the Reports in SQL Monitor
In SQL Monitor 6.0.17.6667 the new Reporting feature is terrific, however I would like to see the addition to add the COMPARE BASELINE option to the Reports like Analysis option currently has. This would allow us to see if measurements like CPU, user connections etc are in line with a baseline of, say last week or way off.
31 votes -
Allow extended email addresses "xxx<myemail@yyy.com>" or custom prefixes for subject line
I send my alerts to a tech-staff group and would like to add specific text for end users to filter all SQL monitor emails against. Either allowing extended email address like "xxxmyemail@yyy.com"
or some global prefix that can be added to subject (or body for that matter). Right now I don't see any reference to redgate or sql monitor to distinguish it from other monitoring email I receive.1 vote -
Please make a mobile app for iphone / ipad like SQL Sentry do!
Please make a mobile app for iphone / ipad like SQL Sentry do!
44 votes -
I wish the blocking Process report included the resource the Blocked processes are waiting on.
My Dev write 500+ line procedures and functions so the SQL "Fragment" is seldom very helpful.
It would be much more helpful to identify the resources the processes are blocked on. Even just the waitresource and waittype columns from sys.dmexecrequests would help.I know some of the resource types are tough to parse in T-SQL.
27 votes -
Monitor Windows 2012 R2 CSV Volumes (Cluster Share Volumes IO/space and other metrics)
CSV Volumes have their own windows performance counters and can be used by resources owned by any of the Windows Cluster
43 votes -
In the ability to compare metrics with historic performance I would like to drop certain days (or hours)
Most of my SQL usage is a mon-Fri pattern so adding in the 2 weeekend days creates a much wider band of "normal" than is realistic. I would like to be able to create a pattern of timeperiods to add in to the comparison so I can drop out days (and maybe hours) which are not representative of "normal" running
3 votes -
Create summary tile with alert search results
I'd like a summary tile to show failed jobs. To be more flexible, a functionality to save an alert search as a summary tile would be a nice feature.
3 votes -
Filter Longest Running Queries Tile by Database
The Longest Running Queries Tile on the Reports screen would be more useful if we could target only one database.
20 votes -
Configurable Thresholds Based on Time
The alerts would be more useful if we could apply maintenance or quiet periods to them.
I understand we have the maintenance window and that is perfect for things like planned downtime, index maintenance etc.
Regards,
CliveHowever, the issue I currently face is that I suppress the processor under utilised message. Like a prolonged spike in CPU activity, a massive drop off could be a concern too. However, I have a current mean of 18.6% on one example server. I can set a threshold of 15% as an example, but this would trigger alerts through the night when typically…
8 votes -
Poll the SQL Monitor Targets on Demand.
When we make a configuration change to address an Alert. By polling the TARGET on demand after making change, we want to make sure that the alert is addressed.
4 votes -
Go to next alert once cleared
If you're clearing a few a alerts and need to review each one, it would be great if clicking cleared then loads the next alert.
16 votes -
Blocking process alert based on number of descendants
While the alert for blocking process is great, it would be nice to be able to configure the trigger for number of descendants affected as well.
If a blocking process runs for 30 seconds and affects 10 people but the alert is configured for a one minute duration of the block it would obviously not let you know
6 votes -
Alerts in SERVER Time Zone, NOT Browser!
Back in June 2016, I added the following to the now-defunct "Previous version" SQL Monitor Forum. The responder said it was in the Q for the next sprint, no promises as to its inclusion. DISAPPOINTMENT/FRUSTRATION continues to be experienced 6 MONTHS later!
Alerts at SERVER time, NOT UTC! PLEASE!
For the love of all DBA's with servers in multiple time zones (yes, this happens), for goodness sake STOP emailing the time of the Alert based on the SQL Monitor's Regional Settings.
In 2016, this statement from the page at https://documentation.red-gate.com/display/SM5/Alerts, is nigh on unbelievable, "All alert times in SQL…
27 votes -
Add option(s) for manual purging of data (use case: removed instances, deleted databases)
CONTEXT: When you remove a machine from monitoring in SQL Monitor / delete a database from an instance / rename a database... - data stays in the SQL Monitor database (e.g. machine/instance/database is still visible on the Analysis tab), at least until relevant monitoring data is purged.
PROBLEM: If you have some purge settings set to "do not purge", that data never goes away. Sometimes that is OK (you want the history retained), sometimes it's not (bloats the SQL Monitor database, unneeded entries on the Analysis page...).
EXAMPLE SOLUTIONS:
Add options to manually (on demand) delete data for a chosen…27 votes -
global dashboard should handle multi-level groupings
Currently the global dashboard presents the SQL instance tiles according to their top-level group. So if I have 3 servers grouped such as:
App1
Prod
Svr1
Dev
Svr2
App2
Prod
Svr3it will present these under 2 groups: App1 and App2. This is fine if you're viewing all servers.
However when I filter the view to only show servers in the App1 group, I'd like the tiles to be grouped using the next level of grouping if there is one (in this case "Prod" and "Dev")
18 votes
- Don't see your idea?