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.
711 results found
-
Share alerts via Email
The ability to share alerts details via Email from the "Alert Details" page.
Sometimes we don't want to share a direct link to the monitor.
E.G
Click "share" which will open a mailto: with the relevant alert details.1 vote -
Identify and alert on heap fragmentation
Currently SQL Monitor does not have a way to identify and alert on heap fragmentation. I suggest you add this to the product.
I know having a heap is usually a bad idea and that heap maintenance is a pain (rebuilding a heap also rebuilds all the nonclustered indexes on it, SQL Server doesn't release a page of a heap table, and doesn't use free space in previously used pages unless you are doing deletes with TABLOCK hints), but there are some valid use cases for heaps.
14 votes -
Manually rerun a metric
When an alert pops up, after I fix the problem, I want to refresh the metric to ensure that it was fixed. There's no way to tell how often the data is refreshed.
4 votes -
Identify which Virtual Host a server is on
In our environment we have a number of different virtual hosts and clusters on which our servers are hosted. It would be quite useful if the SQL server summary information showed the name of the host and cluster on which it is being hosted. As well if host and cluster name could be displayed somehow on the analysis graphs that would be great.
12 votes -
Trigger Self Healing Script and Auto Close
It would be great if SQL Monitor could invoke a SQL script upon an alert threshold being crossed and then take action within itself (ie. clear itself, notify a team, etc) based on the value returned (0/1) or default to an action if there is an issue with the script execution.
This type of functionality would help administrators have a first line of defense before truly getting paged on an alert such as a drive filling (perhaps you have txt files you can purge or shrink logs (though I don't necessarily condone this, but you get the idea!)
25 votes -
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 -
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 -
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.
73 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
- Don't see your idea?