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
747 results found
-
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
-
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 -
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 -
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 -
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 -
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 -
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 -
Search by Query hash in Top queries
As discussed in https://forum.red-gate.com/discussion/91306/search-by-query-hash-in-top-queries/p1?new=1
it would be very useful to be able to search by Query hash in Top queries.Scenarios:
- for complex (and parametrized) queries it may not be enough to be searched by QueryText, DatabaseName or ParentObjectName;
- if queries impact is also investigated and tracked in external systems the QueryHash may be (the only common) field to quickly identify and find that query in Redgate Monitor.10 votes -
Schema name in the Indexes tab and Top procedures tab on the overview page
In SQL server it is possible to have indexes with the same name on different tables. It is also possible to have tables with the same name on different schemas. Therefore, you can have indexes with the same names on tables with the same names on different schemas. The same is true for stored procedures.
Since there is no data on the index and stored procedure's schema in the Indexes tab and Top procedures tab on the overview page, one does not know which exact SP or index is in the table.
17 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 -
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 -
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.
-
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 -
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.
3 votes -
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 -
Link to alert within Teams notification
I would like to see a direct link to redgate monitor alert within the teams notification. At the moment I have to search for the alert in the WebUI manually instead of clicking a direct link like it is in a mail notification with "View full alert details" button.
5 votes -
Custom disk alerts in a cluster is lost when instance is moved to a new host
We often use customized disk alerts for larger disks i.e. instead of using the default alerts we might configure a High alert at 200 GB and a medium at 250 GB.
These custom alerts is not set on the instance level so when we move the instance to a new host the custom alerts will not follow the instance and the alert has to be set up again.
As our largest cluster is 9 node cluster with 23 instances and 3 disk each this cause us to configure these alerts at a maximum of 621 instead of 69 times. That…
21 votes -
domain
Have the Redgate Monitor application support multiple AD domains for users. I have over 4 domains with users that want access to the application.
3 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.
-
Customize Estate Version Thresholds
On the estate tab, it would be nice to customize the thresholds that define the yellow and red state. For example, a server behind on one CU might be yellow, but others red.
5 votes
- Don't see your idea?