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.
- or
716 results found
-
See Transaction Isolation Levels in Blocking Alerts
There are two methods I have been using to understand blocking situations on our servers:
The processes tab in the Blocking Process alert
The blocking processes section in the server overviewI can get a lot of information from both of these methods but I don't seem to be able to get the isolation levels of the blocking or blocked queries which would be helpful in understanding why the blocking situation has occurred.
Prior to using SQL monitor, we used the blocked process report to monitor blocking and these include the isolation levels. Unfortunately, I still have to…
1 vote -
In SQL Monitor, I want to use a variable description in a custom alert.
Some custom metrics could be about things like a specific disk, job or DB-object. At this moment it's not possible to specify those in a generic Alert.
If besides the metric value a descriptive value was allowed, it would be possible to parse the descriptive value into the Alert.3 votes -
Report Poller Error - turn off the PFUR
There is an administrative event error in windows event log occurring every minute or less. This error is unrelated to report poller and is product feature usage reporting (PFUR) unsuccessfully reporting back to redgate. I have been assured this message is harmless, but I think anything that is happening every minute on the server is bound to have some detrimental effect.
Please add a feature to turn off this usage reporting.
3 votes -
Allow trace to be set at the individual alert level and severity
SQL Trace can highly impact the performance of the server. I can't benefit from trace right now as it's set on any alert to launch a trace.
Other monitoring tools, for instance Sql Sentry, allow the individual alert to be configured with settings for trace.
For example: A long running job might benefit from a trace, while a "dbcc checkdb " hasn't been run in a long time should not trigger a trace. This increases storage and server load for no benefit.
Please look into allowing traces to be configured based on the alert AND the severity level…
6 votes -
Use a private route for AWS RDS instances to remove the need for a public endpoint to monitor the instance
The current configuration only allows for the specific format my-db-identifier.random-chars.aws-region.rds.amazonaws.com / my-db-identifier.random-chars.rds.aws-region.amazonaws.com.cn. We would like the ability to use any dns name to allow intra-cloud or hybrid cloud scenarios for the ability to use a private/internal route to the RDS instance so that we do not have to use the public route for monitoring.
3 votes -
Change management for all changes made to your application and a report for the manager to review this change
Change management for all configuration change made in SQL Monitor and a report for the manager to review this change
4 votes -
Add Unallocated Disk Space % to the History view for a database
For Azure SQL Databases, this view currently has check boxes for DTU, CPU, Data IO, and Log IO, which are all checked by default. It would be great to add a check box for Space, which would not be checked by default and would show Unallocated Disk Space %.
1 vote -
Drop markers on the graphs and add annotations
While working on performance tweaks it is customary to consult the analysis reports on a regular basis to see if our changes moved the needle. More often than not the tweaks are released one small batch at a time and it'd be nice to drop markers and custom annotations directly on the charts. I'd like to use that feature to add short phrases describing what was changed that led to the improvement, or degradation for that matter, of performance.
This would be by server (cluster/node) and by metric with the same retention period as the base data for that chart.
…
61 votes -
Expand lower section of overview window
I would like the ability to expand the sections in the lower portion of the overview window or break them out into separate windows. For example, when viewing the Top 10 Queries or Waits it is very difficult because there is not enough room. Also because the individual tabs scroll separately from the main window, scrolling is a pain. The top graph section shrinks, but it still takes up too much screen area. Being able to break out in individual sections or expand them to fill the screen would be very helpful.
See attached screenshot for an example.
6 votes -
be able to add individual machines instead of an entire cluster
Right now when adding a node to Redgate Monitor and if it's part of a cluster, the entire cluster is added (even when switching off the auto-discovery of the clustername as this is only applied to the name itself).
Especially with large cluster estates, it's not possible to add a single node instead of the entire cluster.
This has impact on licenses, as the entire cluster needs to be licensed instead of each individual node that you actually want monitoring for.12 votes -
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/
-
Preserve license after the upgrade
During an in-place upgrade of Redgate Monitor, the license is lost. This poses a significant challenge for offline environments where internet access is restricted. As a result, Redgate Monitor ceases monitoring after the upgrade until a new permit file is generated and uploaded, leading to gaps in monitoring history.
This issue could be mitigated if Redgate allowed a short grace period of trial or honored the previous license during the transition.4 votes -
Be able to report on current alert configuration at All Servers and Specific Servers/Instance levels
Be able to run a report or create an output file that lists default and customized alert settings at All Server, Server and Instance level (Including notification setup).
This is a common request from management and at this point the only option I can think is to setup a spreadsheet and start going through all the alerts.
1 vote -
Link executions of top 10 queries
I had an issue with a query that runs slow every other day. For a specific slow day I could find it in the top 10 queries. I'd like to be able to easily compare the days when it was previously executed . I did manage this by opening a new tab to select the fast day - the query was hard to find as there were many other queries in the top 10 on the fast day. I'd like to be able to lock in on a specific query and monitor the server/query stats at the time/duration of…
5 votesThank you for this suggestion. A graph showing a query’s history was added to the Server Overview Top Queries table in Version 7.1.11 in November 2017. This allows you to see a query’s performance over time, view its execution count, duration, reads, and writes, and the points in time a query’s plan changed.
We will close this suggestion, but please do raise another suggestion if you have other specific improvements you’d like to see.
Kind regards,
Adam
SQL Monitor Development Team -
Add a scroll bar to the backup list (bottom within the specific database)
When we go to the "Databases" at the bottom and we expand a specific one we get the list of the backups that happened during the period we have filtered.
For a better experience, this list should have a vertical scroll bar it it it will show more than 5/10(?) entries.
Otherwise the general scroll bar will become smaller, the page height increase a lot and we need to scroll much more
2 votes -
Add previous/next navigation to Alert Details
On the Alert Details screen it would be extremely convenient to have the ability to navigate between issues within the same screen. Right now you have to either go back through all of the screens to get back to where you initially went to view the details of the alert, or use your browser's back button, which gives inconsistent behavior. This makes going through a high volume of alerts tedious and cumbersome.
This could be handled by something as simple as a "previous/next" buttons on the Alert Details screen. Something akin to the "oldest/older/newer/newest" buttons on the Alert Inbox screen.
…
41 votesWe have now implemented this suggestion in v3.1.
During our usability testing we found that ‘newer/older’ was less ambiguous than ‘previous/next’. Filters now persist on the Alert inbox until they are manually cleared, so you can navigate away and always return to the filtered alerts.
We’re interested to hear your feedback on this feature so please let us know at usability@red-gate.com. Thanks again for the suggestion and comments.
-
Export/Import Custom metrics/alert configurations
I'm using RedGate SQL server with different clients. Since the environments are not connected I have to manually create custom metrics/alert configurations for each client which takes quite some time. Also, any change to the custom metrics/alert configurations has to be then deployed by cilcking. Some export to XML or something similar and import wia PowerShell API would be nice.
15 votes -
Add Query Impact metrics into analysis graphs
Add the ability to report on Query Impact metric in the analysis section to monitor trends.
3 votes -
Offer integration with power bi
I've love the ability to integrate SQL monitor with Power Bi for building dashboards of analysis graphs. Since Power BI is offering a powerful way to setup dashboards with metrics users/managers care about this would be a great way to enhance many analytical report options by outsourcing the creation of those to users more and more, and offering the integration with power bi to make it easy to do.
SQL Sentry offers an integration with their cloud product to work with their metrics and Power BI in case you want to evaluate how it might be used. https://www.sqlsentry.com/Company/News-Article/20150505-power-bi-content-pack-sql-sentry
20 votes -
Email reports monthly
I just upgraded to SQL Monitor V7 and it's great being able to have custom metrics in reports. We have a metric that records how many customers are notified in a monthly process (runs overnight on the 1st of the month). We need a way to send out this report via email on the 1st of every month (current options are only to send it weekly)
10 votesThe ability to email reports on a monthly schedule has now been released.
Please make a new suggestion if there are any areas of the reporting you think could be improved.
Kind regards,
SQL Monitor Development Team
- Don't see your idea?