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
-
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 -
Show 1 hour time on timeline
Show 1 hour time on timeline, 6 hours is too loong for frequent databases
1 vote -
Support Individual query monitoring in Azure SQL Database
This sounds like a useful feature. I wish it was available for my environment.
4 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 -
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
-
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 -
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 -
Set database file usage per drive level on the DATABASE LEVEL
, i know we can set database file usage per drive level on the server level. But there are many times when a vendor created db, they have multiple data files mdf/ndf and have them set to limits. So i was wondering can we get even more granular. I want to be able to drill down to the database and select a particular file group and say ignore this drive, it has met its capacity and even though its 100% filled data is no longer being written there. And the reason behind that is there can be multiple data files…
1 vote -
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 -
Requirement of more reports as described below
Can have the following reports
1)fragmentation level of the indexes in all the databases in all the servers .It can be tabular format with each of the current information as column and all servers and its info as row
2) Server summary for all the servers (in a table format )
3) Replication status of all the servers in the estate
4) Permission of users in dbs in all the SQL Instance
5) To see the compliance level based on a CU or patch for all the servers . It is more like I can…
1 vote -
Save DMV Snapshots for Analyzing and monitoring changes
Idea is to save snapshots of DMV's so that the changes can be analyzed. For example sys.dmexecprocedure_stats shows only total, last and average elapsed time. It will be great to know how the average changed over a period of time.
Common use case: sysproperties
31 votes -
Clear Select Alerts from Dashboard when ended
I'd like the ability to close alerts from the Latest Alert board if they are ended. A checkbox in Alert Configuration to self-close alerts once Ended would be good to have
Eg: I have certain 5-minute jobs that fail once a day if their corresponding run completes I'd like the Alert to clear itself.I can configure the Alert Ended to send email notification stating its ended but it still stays active on the Alerts list in SQL Monitor.
10 votes -
Fix the column headers for the Top Queries when scrolling
On the Server Overview "Top Queries" section, it would be helpful if the header row of the table didn't scroll off the screen. I keep scrolling back up to work out if I'm looking at reads/writes/CPU Time/etc.
5 votes -
Mask sensitive data from deadlock and top queries
We want to let developers use SQL Monitor, but for that sensitive data has to be masked. Two places that come in mind where we can things like literals in WHERE clause etc are deadlock and top queries. This would ideally be combined with a security group which which the masking should apply.
6 votes -
Password is blank when accessing the edit credentials in Monitored servers
Password is blank when accessing the edit credentials in Monitored servers for the monitored sql instance .
If any options need to be changed will need to update the password for the SQL and OS credentials1 voteThe password is intentionally blank. This is to prevent users that don’t have access to the server from changing these settings.
-
search Top Queries
I have a process that reports on stored proc outliers. When I go to SQL Monitor, it is very difficult to search the top queries to find the particular stored proc.
For instance, if I do a ctrl+f and search for "I.Invoices", the search may find that snippet in "hidden" areas (in the dropdowns) but I cannot tell where the found items are.
A query syntax search of the top queries would be extremely helpful.
9 votesQueries can now be searched. This is available from version 11.2.10.
Query search is still in preview. Please send any feedback to SQLMonitorFeedback@red-gate.com.
-
Add more narrow time intervals in Reports
We are using the reports part of SQL Monitor to show them on a TV screen in a proactive way and we find this very helpful.
Now we have a question, would it be possible to include more narrow intervals like 6 h, 2 h and 30 min in the reports?
Because even if we lower the reports to 12 h and has auto refresh every 1 min it’s kind of hard to see and react on the spikes in the graphs.
An example can be seen in the attached fil - Batch request/sec report, it’s hard to spot the…12 votesThanks for this suggestion.
Version 9.0.8 has been released which has added 30 minutes, 1 hour, 2 hours and 6 hours to the Reports time filter values
https://documentation.red-gate.com/sm9/release-notes-and-other-versions/sql-monitor-9-0-release-notesWe’ll mark this as completed and welcome any further feedback you might have.
Thanks,
SQL Monitor Development Team
- Don't see your idea?