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 — often the SQL Monitor team will initially stay quiet about new suggestions to see what you have to say!
If you have any questions visit the Redgate Monitor forum.
683 results found
-
Modifying of several alerts for specific entity could be more user friendly
1) after change tree in left panel with all servers collapse and again should expand nodes down to place where I left
2) color of changed records could be more visible, maybe some light background could be added4 votes -
be able to set top level notification settings through powershell module
I want to be able to use Redgatesqm.ps1 to configure smtp server, default email list and other top level notification options.
1 vote -
Long Running Open SSMS Transaction
Would be really helpful to have an alert that can alert on long running open SSMS transaction and the alert can return the user running it and query being run and on what server we often see it when users forget to commit or role back there transaction.
4 votes -
Only Query Serverless Azure SQL Databases if they are Online and not Paused
As mentioned in the below post, SQL Monitor will keep serverless Azure SQL databases from pausing and saving us the money they are supposed to. I would like the Azure SQL monitoring piece to be rewritten to use the Azure API to determine both if the Azure SQL DB is serverless or not and if it is AND paused, don't run any queries that would wake it. Yet if it is NOT paused, get info about it and update SQL Monitor.
3 votes -
Uptime of my SQL server database servers
I need to be able to account for yearly uptime for my SQL server estate and also receive proactive alerts when they are shutting down.
4 votes -
Add database changes details based on the zoom range
In the "Databases" section when selecting one, we would like to have a list of the database changes that happened based on the "zoom range" period.
Right now I'm thinking based on the SQL Server error log
Example:
1 - Database Status changed. Online/Offline/Read-Only/Read-Write/etc
2 - Compatibility Level changed - This will be great to co-relate some situations with the CL change.
3 - Page Verify
EtcIn the end, any message that uses any of these texts:
SELECT * FROM sys.messages
WHERE text like '%Setting database%'This includes query store changes
7 votes -
Outlook calendar style view for SQL Agent jobs
This would be very useful for viewing all scheduled jobs in an Outlook-style calendar view. Also useful for scheduling new jobs to prevent conflicts.
6 votes -
Grant more granular report level access
I can grant report level access to a user by adding them to the Reports User role and I can restrict the servers which they see reports for.
However, this role gives the user more permissions than I would like to give - they can still view any other page - alerts, server overview etc
Can we change this so they can see the reports only?
2 votes -
TempDB Percentage Free Space Monitor/Alert
Common practice is to put TEMPDB files on a dedicated disk and size TEMPDB to fill the entire disk.
When TEMPDB grows unexpectedly it can quickly use all the space on the disk and is a common cause of SQL Server issues.
We have great observability about TEMPDB issues in SQL Monitor now but no default alerts.
We have some metrics we can alert on such as TEMPDB Free Bytes, but a literal value is not much use in a mixed environment where some servers have 1TB+ TempDB databases and some have only 30GB.
We collect a custom percentage free…
5 votes -
AG sync progress
Implement Availability Group data synchronization progress.
We use Automatic seeding and stats can be observed under "sys.dmhadrautomaticseeding" and "sys.dmhadrphysicalseeding_stats".
Maybe that info not 100% accurate when Traceflag 9567 is ON, but anyway somehow helpful1 vote -
Allow Job Name to be used for Long-running query alert exclusion
For a Long-running query alert, the Job Name is being collected but cannot easily be used for avoiding specific alerts from being triggered.
7 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 -
Add ability to collapse the "Query details"/"Wait type"/"User memory" list under a specific query.
Often we want to screenshot the execution pattern, the graph below all these areas and because all of those occupy a big chunk of space on the screen, this becomes harder.
We end by "zoom-out", crops, or even picking multiple screenshots and doing collages.
Thanks
2 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
2 votes -
Set a configurable delay to send the Resolved/Ended emails
Sometimes the emails sent by SQLmonitor to PagerDuty are delayed for some minutes
In this case it can happen that PagerDuty received the "Resolved/Ended" emails before the "Raised" emails because this one has been delayed for too long and because the alert was resolved after 1 or 2 minutes...
When it happening the alert is never closed and generate a useless phone call
So to fix this issue we would like to delay all the "Resolved/Ended" emails send by SQL monitor to be sure that PagerDuty received the "Raised" emails before "Resolved/Ended" emails4 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 -
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 -
Who ran the query and what time
I would like to see in sql monitor who was the person that ran the query and what time the query was run.
10 votes -
I would like to set up an alert for disk space projection threshold
Wanted to know if we can set up and alert when it reaches the threshold of less than a month of projection for disk - this is in the disk monitoring estate for Redgate .
image.png
Regards,
Shaily.1 vote -
Number of rows returned by query
I'd like the ability to view the number of row returned by a query. Tools like Dynatace, XRebel, New Relic are able to display this and it's extremely useful in identifying queries that are selecting too many rows and in need for application logic / code rework.
1 vote
- Don't see your idea?