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
733 results found
-
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 -
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 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 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 -
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 -
Tags in "About" section are viewable, but not selectable or copyable
The tags in the about section in a monitored Server are viewable, but not copyable.
We use tags for the category or a contact person or person of charge or additional information hints.This information as tags are a easy appoachable and fast way to see those information from a sql server.
But there is no easy way to copy the content of a tag. You can easily drop a tag or create a new tag, but is impossible to select/copy (somehow select + right click + copy or select + ctrl c) the content of a tag.
…
6 votes -
Include instance-specific name (@@SERVERNAME) on alert mails
The alert mails for a SQL Server cluster contain the cluster name but not the actual instance virtual name. It would be nice if the mails contained the actual virtual name (as given by "select @@servername") so that the email contained all the details needed to connect to an alerting instance.
My cluster name (i.e. CLUST01) is a different IP than my virtual names (i.e. VIRTUALSQL01), which means that I can't connect to my "FOO" instance by "CLUST01\FOO" as the alert email seems to indicate. Instead I need to connect via "VIRTUALSQL01\FOO" which is not present anywhere in…
20 votes -
Raise Free Space alerts on disks that are mounted, rather than simply drive letters/volumes
In our clustered environments, instances are given a small drive for mounting the larger data/log/etc volumes within them.
Whilst we always get a "disk full" warning on the mountpoint drives (subsequently disabled), there appears to be no ability to monitor the volumes that are mounted within, where we do care about free space.
I do see that metrics for IO, latency etc are done on a per volume (not drive letter) basis, so would be great if we could have consistency.12 votes -
Email Alerts subject info
Change the subject to the email alert, remove the SQL monitor ID number as taking up space without adding value, making it more difficult to gather the neccesary info from the subject line for job failure etc when viewing email through a portable device iPhone etc.
6 votesSQL Monitor V 3.3. has now released. This release contains improved subject lines and message bodies of alert emails to help you quickly understand problems before logging in to SQL Monitor.
Thanks,
SQL Monitor Development Team -
Show 1 hour time on timeline
Show 1 hour time on timeline, 6 hours is too loong for frequent databases
1 vote -
Prompted for update to version 8.0.12 but website is a dead end
The "update" link in the SQL monitor console takes me to a "learn more" page with no link to an update EXE. I am referred to a zip file with a SQLBundle EXE which doesn't contain the Monitor, or an outdated version of SQL Monitor.
1 voteHi,
Thank you for reporting this, and apologies that you encountered it. We removed version 8.0.12 owing to a bug, and have since released 8.0.13.
I will close this suggestion, but if you require further assistance with this issue, please could you let us know using the support forum https://forum.red-gate.com/categories/sql-monitor-7
Kind regards,
Adam
SQL Monitor Development Team -
Allow the pinning of availability groups to the Global Dashboard
I'd like to see the status of my AGs on the Global Dashboard without having to find them inside the server. Would also nice to see stats on latency on this widget.
6 votes -
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 Job Description in Job Alerts
I'd like to see the job description in job alerts. We use this field in sql server to add notes about what the job does, who to inform on failure and rerun steps.
6 votes -
Remove sys from Top Queries as a filter
On the dashboard “Top Queries” grid, a way to filter out any queries that were system wrote or 'sys' wrote. This way you can monitor only the queries that you have written.
4 votes
- Don't see your idea?