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
756 results found
-
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 -
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/
-
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 -
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 -
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.
…
64 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 -
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 -
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)
-
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 -
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 -
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 -
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 Cname as a connection string instead of instance name
RGM usually connects with the instance name it automatically pulls down via the WMIC commands it runs on the nodes -There may be times were you have set the systems up that all connection certificates used the CNAME set up rather than the instance name for connection
Adding the ability to replace the instance name with a CNAME for connection will allow RGM to connect to the server securely18 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.
-
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 -
group similar queries
I have queries which are created by string concatenation in a legacy product.
These queries differ by some IDs in a IN clause.In SQL monitor, these queries are all shown as different queries in the "top queries" section.
I would like that all those similar queries are shown as one query in the "top queries" section so that I can better find long running/problematic queries.
11 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 -
Re-Check an alert
It would be helpful to have a "ReCheck Monitor" button for all of our alerts in Monitor. We have some checks that are only performed once per day. When those checks create alerts, we make quick work of resolution, but the alert doesn't clear for a long time (next day). It would be very helpful to have a button to force an immediate re-check. This would validate the fix and get us back to an all-green status quickly.
4 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 -
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
- Don't see your idea?