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
723 results found
-
new altert for service state of PowerBI Reporting Services PBIRS like "SQL Server Reporting Service status (2017+)"
In addition to SQL Server Reporting Services SSRS, we have more and more PowerBI Reporting Services PBIRS.
For SSRS since 2017 there is a separate alarm "SQL Server Reporting Service status (2017+)" in Redgate.
This tells us when an SSRS is no longer running. This also works.However, as far as I can tell, this alert does not cover PBIRS.
Recently, customers increasingly want PBIRS instead of SSRS and unfortunately we do not currently see the status of the PBIRS service in Redgate and do not receive an alert if this service is not running.We know that PBIRS and SSRS are different products that are not an official part of SQL Server (anymore).
SSRS and PBIRS are very similar from our administrator's point of view.
However, SSRS and PBIRS are additional service extensions of the SQL server at this point, which we have to monitor in some way.It would be fantastic if Redgate could also display/report the status of PBIRS services.
In addition to SQL Server Reporting Services SSRS, we have more and more PowerBI Reporting Services PBIRS.
For SSRS since 2017 there is a separate alarm "SQL Server Reporting Service status (2017+)" in Redgate.
This tells us when an SSRS is no longer running. This also works.However, as far as I can tell, this alert does not cover PBIRS.
Recently, customers increasingly want PBIRS instead of SSRS and unfortunately we do not currently see the status of the PBIRS service in Redgate and do not receive an alert if this service is not running.We know that PBIRS and…
11 votes -
Make reports from database extended properties and sort it by database name for CMDB purpose
Make reports from database extended properties and sort it by database name for CMDB purpose
1 vote -
Make configuring alerts easier
Currently we have several instances grouped into three top-level groups and then several subgroups underneath. This structure allows us to set alerts at the group level and then drop instances in and out of that defined set.
If we select a group and configure an alert setting, when the page refreshes it does not return back to that same sub-group, instead opting to go back to the very top 'All Servers' level which if not spotted can mean you then select the next alert to configure and inadvertently change the setting for all servers.
This seems like basic functionality but I cannot find anywhere else to raise this as its clearly a design choice instead of a bug, just a bad one in my opinion.
In a related note, its not always clear which instances have 'overridden' rules and the bold type face doesn't always appear if the alert is on a job or disk buried several layers deep. It would be nice to see a way to show "only overridden alerts" or something as a filter.
Currently we have several instances grouped into three top-level groups and then several subgroups underneath. This structure allows us to set alerts at the group level and then drop instances in and out of that defined set.
If we select a group and configure an alert setting, when the page refreshes it does not return back to that same sub-group, instead opting to go back to the very top 'All Servers' level which if not spotted can mean you then select the next alert to configure and inadvertently change the setting for all servers.
This seems like basic functionality but…
5 votes -
implementing user permission settings at the instance level, rather than at the cluster level.
In my company, it is crucial to implement permission settings at the instance level, rather than at the cluster level, for accessing overviews and creating summarized reports. ~
This feature is extremely important because our clusters are shared by multiple tenants/instrances, and we need the ability to assign specific permissions to the respective owners of each instance.4 votes -
Uncover hidden tuning opportunities by toggling graphs to a different scale
Two problems, one suggested solution: First, too often something important to us is hidden, because the graph showing the critical metric is skewed by another event. In order to show the peak of that event, the graph is scaled such that other activity is just a flat line at the bottom. Second, graphing multiple measures in a single graph, when their scales vary widely, makes interpretation difficult--for a contrived example, imagine plotting CPU (scales to 100) and batches per second (scales to tens of thousands for our web site). A tool for tuning MongoDB provides a beautiful solution, by allowing you to toggle between decimal and logarithmic scale. See the two graphs depicting the same period on this documentation page, in the "Logarithmic Scale" section, and notice the richness of information you can get from the log scale: https://rueckstiess.github.io/mtools/mplotqueries.html. I have used this to point developers to performance tuning opportunities that were otherwise hidden. I would love to see it in Redgate Monitor!
Two problems, one suggested solution: First, too often something important to us is hidden, because the graph showing the critical metric is skewed by another event. In order to show the peak of that event, the graph is scaled such that other activity is just a flat line at the bottom. Second, graphing multiple measures in a single graph, when their scales vary widely, makes interpretation difficult--for a contrived example, imagine plotting CPU (scales to 100) and batches per second (scales to tens of thousands for our web site). A tool for tuning MongoDB provides a beautiful solution, by allowing…
2 votes -
Ignore Selected Procedures in Top Procedures Grid
In the Top Procedures grid, a checkbox for toggle if the stored procedure in the row is one that you would want to ignore and not examine for any metrics during that or any given time
3 votes -
Show Schema Name For Each DB on Top Procedures Grid
On the Top Procedures grid, within the row data - showing the schema name within the database if it exits.
3 votes -
Add DTU, CPU, DATA I/O, Log I/O to grids 'Top Queries', 'Tracked Queries', 'Top Waits'
On each of the Top Queries, Tracked Queries and Top Waits grids a way to customize the columns to show metrics for DTU, CPU, DATA I/O, Log I/O
3 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 -
Current Activity (sp_whoisactive) History
I would love to see snapshots of current activity (sp_whoisactive) taken on a regular cadence (e.g. every 5 minutes would be very useful for troubleshooting).
So in the current activity tab I can select a snapshot time from a dropdown of taken snapshot times. Backwards/Forward buttons advancing to the next/previous snapshot would very powerful.Having the top queries and waits etc. is super useful, but being able to see a snapshot of the active running queries around an incident would add a lot of value.
Appreciate that is potentially generating a significant volume of data so appropriate retention/default capture options/server configuration/snapshot frequency would be required.
I would love to see snapshots of current activity (sp_whoisactive) taken on a regular cadence (e.g. every 5 minutes would be very useful for troubleshooting).
So in the current activity tab I can select a snapshot time from a dropdown of taken snapshot times. Backwards/Forward buttons advancing to the next/previous snapshot would very powerful.Having the top queries and waits etc. is super useful, but being able to see a snapshot of the active running queries around an incident would add a lot of value.
Appreciate that is potentially generating a significant volume of data so appropriate retention/default capture options/server…
2 votes -
Show "HostPID" on deadlocks
Add "Hostname" and "Hostpid" detail to blocking processes and long running queries in RedGate, this information is available deadlocks.
This would help us to identify the process causing the blocking to further investigate fixes vs trying to work out the process from the SQL code, which can often look similar to other queries.
2 votes -
Feature for Integration of Redgate Monitor with Share point
Integration with SharePoint to display the dashboard without needing to login
1 vote -
Possible AI usage for Alerts in Red Gate Monitor
The alert system for Red Gate Monitor could be improved with some more intelligence. For example Full backup jobs and differential backups, weekly full, daily differential. Of course the differential will take a lot more time just before the full backup in comparison with the differential backup just after the full backup. If Monitor could "learn" the environment and only give alerts when things are really off then this would be much better.
4 votes -
Datawarehouse Database for older data
There should be an option to transfer older data to a datawarehouse database and still seamless be accessible from the Red Gate Monitor tool. This way the primary database can be small and quick in normal day to day use.
2 votes -
Index Analysis -- Index Object Filtering
Index Object Filtering -- Ability to Exclude Objects.
It would be nice to be able to exclude the RedGate indexes, or exclude specific databases, or other specific objects. Currently, filtering is more inclusion based but frequently exclusion is easier.
1 vote -
compare query metrics across instances
I would like to be able to compare query metrics across SQL Server server instances.
We have a number of environments - Dev / QA / UAT / Production
the data generally increases in volume and gets more "real" the further up the chain we go which can mean something that performs well against the "small data" on the dev server can become an issue when it hits UAT which has real volumes of data
It would be useful to be able to compare a query across instances so if we release a feature which comprises of a number of SQL queries and one of those SQL queries performs poorly on live, but has been acceptable on other environments, it would be useful to compare query historys (those seen in the server overview page) to the query histories on one or more of the other environments (each environment has its own SQL Server instance)
I would like to be able to compare query metrics across SQL Server server instances.
We have a number of environments - Dev / QA / UAT / Production
the data generally increases in volume and gets more "real" the further up the chain we go which can mean something that performs well against the "small data" on the dev server can become an issue when it hits UAT which has real volumes of data
It would be useful to be able to compare a query across instances so if we release a feature which comprises of a number of…
5 votes -
see a greater time range in the Overview
Often customers would like to see a broader overview, eg a whole week or a classic working week (Mon-Fri). It would be great if we can extend the overview to 5 or even 7 days.
5 votes -
Support Monitor Ubuntu with another port ( not port default 22)
Dear Development Team,
Currently, I'm using SQL Server running on Ubuntu ( with SSH port 5678). I can't connect to OS Linux via SSH port 5678. I don't see where to input the port (not the default port). I want the Team to enhance the feature allow to the input SSH port.I have created an issue to discuss here (https://productsupport.red-gate.com/hc/en-us/requests/305026)
Thanks,
Khoa.Nguyen2 votes -
more results per page
Results per page. Increase the number of results per page or in the waits section there is a checkbox for maximum 50 results too custom number
1 vote -
Grant user access down to SQL instance or database level
Currently the lowest level we can grant users access to cluster level. In multi-instance clusters this gives too much. Need to scope user access to instance and database level.
1 vote
- Don't see your idea?