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.
710 results found
-
deadlock Detailed Report
Please create a detailed deadlock report.
In addition to the existing DeadLock summary report, can you please create a DeadLock Detailed report for all deadlocks for a given time range.
Looking for a DETAILED report of deadlocks (all deadlocks for the time range) that will include:
1. Date / Time of the event
2. Blocking SPID and full query text
3. Duration of the block
3. All Child or deadlock victim SPID and full query text of the victim
Similar to the summary report, will need to be able to select the SQL server instance and / or database to…3 votes -
custom RPO time
Custom RPO time. Have the ability to adjust the RPO to its values, for example 5 or 10 min. Not only 15minutes.
3 votes -
See job history beyond one month
Currently the Estate Job page only offers a view of a day, week or month, but sometimes we need to see trends beyond one month.
Is it possible to add a variable window? Or a fixed one of a year?3 votes -
Increase SQL Monitor email Alerts to larger than 400 KB
We have some alerts for important servers that require you to login to SQL Monitor to see the full details because they exceed 400 KB. The alert currently reads:
"Details
Details omitted because they exceeded 400KB. Please log into SQL Monitor to view them.
View full alert details
Configure alert"Please increase this value so that we can see the full alert details within an email instead of having to login to SQL Monitor to see them.
Thank-you!
3 votes -
Update the password of the account with powershell module
I do not want to use the base monitoring account, to monitor the different databases. So I need to use a separate account for that. In order to regularly be able to rotate the password of this account, I would need the PowerShell module be updated with a function to update the password.
3 votes -
azure overview
Azure SQL databases display differently than SQL server databases on the overview page, which makes them difficult to see. And even with the Azure SQL databases, there are further differences if the databases are members of elastic pools or not.
Please change the Overview Page to either a) show them more consistently, since there's no other indication of what's different.
or b) rearchitect the way Azure SQL DBs are displayed on the overview page so it's clear they are Azure SQL and that would also give you the ability to show them whatever way makes the most sense for the…3 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 -
SQL Monitor to Authenticate Directly with Office 365, Exchange Online
Hello, it would be great if SQL Monitor could authenticate directly with Office 365 rather than having to use an on-premises SMTP server. Exchange Online is probably the most widely used email service for business and the application is unable to successfully authenticate with it. Thanks.
3 votes -
Monitor Partitioned Tables in SQL Server
Be able to monitor and alert on sql paritioned tables. Such as if a retention of a table is 30 days and it retains data greater then 30 days, I should be able to get an alert. Be able to get alert on things like if older partitions are not merging or new partitions are not splitting or data being stuck in one partition...etc Able to see growth and changes in the partitions...
3 votes -
Create smaller timeframes on the server overview page.
Currently if you dive into the overview page of a certain server the default timeframe is 24 hours, you can narrow this into 12,6,3 and 1 hour.
I would like to have the opportunity to narrow it down into minutes.like a custom time frame. This helps to do a more clean investigation.
3 votes -
Superimpose the Disk I/O for VMWare Host on graph for Disk I/O
I'd like to get the Disk I/O for the VMWare Host superimposed on the graph just as I get CPU and Memory, it is very helpful to see the load on the host together with the load on the actual VM.
3 votes -
Banner Messages for planned Downtimes
Hi!
We want to put Banners on Top Global Dashboard to inform Users, that we planning Downtimes on SQL Monitor.
SQL Monitor has build in banners for unlicensed Servers and stuff like that. Would it be possible to show User Messages that there will be a Downtime on SQL Monitor?3 votes -
Limit user access on clusters
I would like to be able to grant specific AD users / groups access to specific instances on a cluster. Currently its only possible to grant access at the cluster level which gives more access than is necessary. This would be a supremely useful feature for me!
3 votes -
Make "Source" hyperlink in Alert take you to the specific date time on the Server Overview Page
If I click on the "Source" Hyperlink in alert, this opens the server overview page for the relevant server, however, the displayed time frame is the default (24 hour period ending at the current time)
It would be helpful if the server overview page opened at the date / time of the alert as it is highly likely after clicking the hyperlink, that you are going to want to view the point in time of the alert
3 votesWe're currently reviewing this suggestion as part of general usability improvements.
-
Make it possible to mark a query to be tracked from the database menu
On the "Top queries" within the database menu, we can only "View estimated plan" and "Copy query text".
It would be handy to have here the "Track query" option too.
Nowadays, if I find it here, I need to filter on the top and only then I can "Track query"
3 votes -
Being able to type the (graph) zoom range time
Sometimes is hard to quickly get to the time range we want to analyse.
It would be handy if we could have a "free text" time box to type:
Zoom range Start: 11:10
Zoom range End: 11:313 votes -
Add the ability to use "special" characters (@, #, etc) when using searching in "Top Queries"
Hi, I'm trying to search some query patterns on the "Top Queries" grid for example "INSERT INTO @" or "INSERT INTO #" (to get all inserts on table variables or temp tables) however, in both situations, the @ and the # is being ignored.
Please include those (and other chars) to refine our searches.
Not sure if "RegEx" would be another option that would be even broader.
Thanks
3 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 -
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.
3 votes -
Estate Licensing - Align with Microsoft HA/DR Licensing policy
Estate licensing appears to tally all licenses for servers in an WFC/HA config. 3 node cluster 4 cores, 12 licenses (when it should be 8). Please provide the process to identify an HA or DR node, which will allow the Redgate Estate portal to align with Microsoft SQL Licensing: https://download.microsoft.com/download/e/2/9/e29a9331-965d-4faa-bd2e-7c1db7cd8348/SQL_Server_2019_Licensing_guide.pdf.
3 votes
- Don't see your idea?