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.
44 results found
-
Allow Groups to be created on Instance name rather than server name
For multiple instance hosts, each instance can have a separate functional purpose. However groups do not allow instance level granularity. It would be useful to have distinct instances from the same host in separate groups.
30 votesTags can be used to indicate functional purpose for instances. See https://documentation.red-gate.com/sm/adding-and-managing-monitored-servers/applying-tags-to-monitored-servers.
-
Add an index to Alert.Alert on AlertType to remove index scan
Here's the index. It really helped speed up the system (monitoring 20 servers)
USE [RedGateMonitor]
GO
CREATE NONCLUSTERED INDEX [AlertType]
ON [alert].[Alert] ([AlertType])
INCLUDE ([AlertId])
GO3 votesClosing as it’s being tracked as a bug – thanks Phil!
-
SQL Server agent job alert
Say somehow the sql server monitor wasn't enabled and some job failed on one of the monitored servers that time; when the SQL Server monitor comes back online I would appreciate, it showing this error, in the same manner, the monitor tool shows the overdue alerts for Integrity check, backups etc
1 voteWe decided against this in order to avoid a scenario where users are greeted by an onslaught of Job Failure alerts when they add a new monitored server
-
Choose aggregation used in the analysis graphs
(Posting for a user)
Would it be possible to request a change to the graphing data algorithm to allow for the user to select (when adding a metric to the analysis graph) whether to use AVG (mean) aggregated or MAX aggregation. Although you could allow for any of the aggregation operators to be used, see screen mock up below from the SQL Monitor Analysis tab where you add the metrics to the graph.
I think it would significantly enhance the analysis of peak (local or global maximums) and it would prevent peak values being artificially dragged down to a local…
25 votesUnfortunately this is a fundamental constraint of sampled data: The peaks you see in SQL Monitor are the result of spaced sampling as well, and are therefore (informartion-theoretically) no different from the average aggregation that you see when you zoom out in SQL Monitor.
We could make it so that when you zoom out, we show you the highest data point in our data set, ie. the highest partial average, but that’s not really mapping to anything real, so would be quite misleading
-
add custom metric for tracking use of deprecated features
I think it should be possible, using Extended Events or some other method, to create a custom metric that allows SQL Monitor to track the use of deprecated features. This data is useful for upgrade planning or best practice reviews. I realize some of this can be found via server-side tracing, but I have heard that Extended Events may be more efficient.
1 voteWe tend to avoid sharing custom metrics that affect server state (such as creating a new XE). However, you can implement this yourself – the following article should point you in the right direction: https://www.mssqltips.com/sqlservertip/1857/identify-deprecated-sql-server-code-with-extended-events/
-
Add hide/show button for metric in Analysis Graph page
Add an ability to quickly hide/show lines of metrics in Analysis Graph. It would be very useful when looking for correlation findings.
3 votesWe tried this out and couldn’t get it to work without making the interactons on the UI more confusing
-
The ability to publish custom metrics and alerts to your website for review and easy addition to community driven submissions. I have tested
The ability to publish custom metrics and alerts to your website for review and easy addition to community driven submissions. I have tested on my own systems and would like to quickly post up the custom metric and alerts I have created instead of current process.
1 voteCurrently we use an email submission system – our sumission volume is still too low to implement an automated process
-
Some alerts show 2 different time zones on a single alert event
On the alerts page I open a Database Unavailable alert that indicates a time of 10pm. The new page opens, and I see "Time raised = 10pm" but on the Details tab I see "Time = 6am"... it's showing UTC time instead of local time here. (Unless I've got something misconfigured!)
2 votesThanks – tracking this as a bug
-
Disk Space / tempdb / Custom Alerts
Hi,
I have couple of suggestions as per my present system architecture ...
1) For disk space alerts, user should be able to configure this alert for as many disk/drives as user wants out of the total disks/drives are available on the server. If needed, user should also be able to ignore a particular drive. Right now, SQL monitor checks for all the disks/drives on the server
2) For database level alerts, there should be a exclusive alert for tempdb space
3) In custom alerts, SQL Monitor should be able to display a resultset of a SQL query and publish…5 votesClosing as this is multiple ideas – please raise a separate suggestion for each
-
Average SQL Duration
SQL Executions, New metrics.
Number of statements executed during the current interval.6 votesWhich queries to include/exclude in this KPI depends a lot on the enviroment – so it’s best implemented as a custom metric
-
Show Stored Procedure Argument values in Long Running Query alerts
Showing me the CREATE PROCEDURE XXX_sp would be far more helpful if I could see what parameters had been passed into the procedure.
The run times of some of our procedures vary significantly depending on the client or account they are being run for. Knowing what values were passed in to the SP is essential information in troubleshooting the problem.
16 votesDue to our agentless architecture, SQL Monitor cannot do this without incurring a significant performance overhead on the monitored entity.
-
Custom metrics in Analysis tab - allow grouping by metric type (machine / SQL Server instance / database)
In Analysis tab in the metric choice window all custom metrics are currently grouped together and sorted alphabetically. I'd like to see them grouped by type similar to the out-of-the-box metrics (machine / SQL Server instance / database) - the type could be a new parameter for each custom metric, manually entered / changed.
That would help when one has a lot of custom metrics.The result:
- Machine metrics
- SQL Server metrics
- Database metrics
- Custom machine metrics
- Custom SQL Server metrics
- Custom database metrics
- (maybe also this: Custom uncategorized metrics)?3 voteswe have found that this is not how people use custom metrics in general, so adding this split by default would go against the practices of most of our users – the best workaround for those that do have this split is to add a prefix to their custom metric name – they are ordered alphabetically
-
collect table scan density percentange
We would like to collect the "dbcc showcontig" table scan density percentage so that we can alert on levels below a certain percentage.
3 votesThe best way to do this is using custom metrics
-
Type mismatch error
When viewing a SQL instance, getting "An error has occurred. Try refreshing the page: the problem may be temporary". Error details are:
http://hostname/static/3.2.1.231/Scripts/RedGate.Response.js: 2346
Type mismatch.1 vote -
Different colours when comparing
I think it would be easier to differentiate the two lines when comparing (for example today's values with last week's).
For example Red vs blue lines.7 votes -
where is sql server database mirror status
i want see sql server database mirror status
10 votesWe’ve seen mirroring to be used by a vanishingly small portion of our userbase, and it’s not growing.
However, you can create Custom Metrics and alerts to get the same information into SQL Monitor
-
why It splits the server and port
when I try to add the sql instance to monitor , I have to use port and when I do so it splits into two servers. also host and instance is bit confusing , why it goes as local for anyserver you addd to monitor
0 votes -
maintenance windows
To track 'up-time' (probably using a custom metric) which can be used at 3, 6 and 12 month intervals to show the servers uptime accurately. But it would be useful to ensure that data from with the Maintenance Window is not included. Therefore it would be very useful to have the option to either suspend data collection for some or all custom metrics during the Maintenance Window, or even suspend all data collection during the window.
7 votesquite an invasive change to how maintenance windows work to serve an edge case – See this for a better approach: https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/12881094-custom-reports-against-alerts-queries-and-metrics
-
Navigation Inconsistent
This is minor, but but it seems the links in the header on the alert detail page should link to the alerts page for that instance, not the overview.
1 voteI agree it’s counterintuitive, but it’s intentional
-
Export the analysis graphs to PDF and add printing support.
I would like to be able to print nice well formatted reports from SQL Monitor so that it can be shown to Management. I guess exporting to PDF could accomplish that.
13 votesPlease use our CSV export instead – Tools like Excel will help you visualise your results in a variety of ways
- Don't see your idea?