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
-
Few suggestions:
• Display the Job Name (character string) instead of hexadecimal value (SQLAgent - TSQL JobStep (Job 0x442BC6B49DA6FC41A98697F8C2F68956 : Step 1)
• In alerts configuration: Be able to exclude Long-Running query alerts (or any type of alert) for a specific time frame. For example: between 11:00PM and 5:00AM
• When selecting an alert details view, create a link to be able to come back to previous alerts summary screen instead of selecting Overviews link and then again narrowing down to alerts summary by server let’s say…80 votesHi, because these are multiple suggestions and it’s not clear who has voted on what, I am going to have to close this suggestion.
If you are interested in the Job Name request, please open a new suggestion for this
If you are interested in the Time frame suggestion, please vote on: http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/11122008-suppress-performance-related-alerts-during-mainten
If you are interested in returning to the Alert Inbox from the details view, this has been implemented in SQL Monitor 3.3
-
Job step failure - trigger an alert, even if the job itself doesn't fail
CONTEXT: If job step "On failure action" is set to "Go to next step" or "Go to step xy...." and the step fails, we would like to be alerted. The alert should be triggered immediately (as opposed to at the end of the job).
PROBLEM: SQL Monitor "Job failed" alert doesn't alert in such cases.
EXAMPLE SOLUTIONS:
• A new alert.
• Expanding options on the "Job failed" alert.53 votesThere is now a ‘Finding Job Step Failures’ custom metric available to achieve this (see https://sqlmonitormetrics.red-gate.com/finding-job-step-failures/).
See the ‘Adding custom metrics and alerts’ help page (https://documentation.red-gate.com/sm/metrics-alerts-and-notifications/adding-custom-metrics-and-alerts) for more about using custom metrics with SQL Monitor.
-
Should have feedback on missing index, its great know that I have a slow running query but some possible hints on how to improve them.
Should have feedback on missing index, its great know that I have a slow running query but some possible hints on how to improve them,
the infomation is avalible in SQLServer version 2005 onward in the following DMV
sys.dmdbmissingindexdetails
sys.dmdbmissingindexgroupstats
sys.dmdbmissingindexgroups
sys.dmdbmissingindex_columnsSo I still have to go off and check.
Overtime as database grow in size and data distribution of the tables changes therefore indexing requirements change, so unless you monitor these DMV's you may not notice that an index may be helpful.…34 votesThe missing indexes DMVs are not an exact science, so we’ve decided against presenting sometimes-helpful, sometimes-disasterous tuning advice in SQL Monitor.
However I’m confident that SQL Server itself will continue to evolve as a tuning platform, leaving SQL Monitor free to look at the bigger picture.
-
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.
-
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
-
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.
-
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
-
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
-
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
-
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 -
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
-
Add Clear, Unclear, Read, Unread buttons to the end alerts list.
Add Clear, Unclear, Read, Unread buttons to the end alerts list.
I like to have 100 alerts per page and its very unpleasant to clear several alert that are on the end of the page.6 votesThe ‘Clear’, ‘Unclear’, ‘Read’, ‘Unread’ and ‘Add Comment’ buttons are pinned to the top of the alert inbox list. The buttons are therefore always available as you scroll down the alert inbox.
-
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
-
Latch Wait Time Explanation
In SQL Monitor 4.0, the explanation refers to sys.dmdboperational_stats which does not actually exist.
Should this be sys.dmdbindexoperationalstats?
4 votes(not actually declined, but we are tracking this separately as a bug)
-
Classic Dashboard Mode
The new global dashboard is great but it is harder to read at a glance then the old dashboard. Please add in a classic dashboard option.
4 votesRefers to very old version of SQL Monitor (2016).
-
Specify databases for custom metric using wildcards
We have multiple databases for each of our clients - each type of databases uses the same schema and follows a consistent naming convention. For example:
XXXXMain
XXXXExtra
XXXX_ManagementYYYYMain
YYYYExtra
YYYY_ManagementI want to add a custom metric that only applies to "_Main" schema so in order to choose databases to collect from I need to specify each database explicitly. This proves challenging as the number of clients grows and we add more servers / instances to our environment.
It would be preferable if i could instead use some form of wildcard to specify databases…
4 votesA bit of an edge case that would make things a lot more complicated for all users
-
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!
-
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
-
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
-
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
- Don't see your idea?