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
-
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 -
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 -
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 -
Have a free-text notes field for each server\instance
A notes field can be used for any useful information such as business contacts, service hours or documentation links, etc.
16 votes -
Long-Running Query Alert - Occurrences tab to refer only to instances of that query
In the long running query alert, the occurrence tab shows a history of occurrences of the long running query alert. These alerts are the history of any long-running query rather than just the query in the alert
It would be helpful to be able to see a long running query alert and see just the alerts for that query to be able to quickly understand whether this query is a regular problem, or something new.
I appreciate it is possible by highlighting the time period in the server overview page, finding the query and then viewing the query history but…
4 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 -
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 -
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 -
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 -
Add a scroll bar to the backup list (bottom within the specific database)
When we go to the "Databases" at the bottom and we expand a specific one we get the list of the backups that happened during the period we have filtered.
For a better experience, this list should have a vertical scroll bar it it it will show more than 5/10(?) entries.
Otherwise the general scroll bar will become smaller, the page height increase a lot and we need to scroll much more
2 votes -
Being able to set alerts based on existing KPIs (Analysis Graph) instead of create a new custom metric
If I want to create an alert based on some existing KPIs, I need to write the query and can't leverage the existing one.
Example:
I want to create an alert when the "Tempdb: Free bytes" is lower than X.
I can't use the existing "SQL Server metrics" that contain this KPI.
Instead, I need to create a new custom metric and build the query. (which in the end it will be exactly the same). Only after that I can create an alert.2 votes -
When "Totals" is selected, on mouse over still display average values for the metrics
When we change from "Avg. per execution" to "Totals" the row order can change.
With bigger numbers, it becomes harder to quickly know if the average is high or not to decide to take a further look.
Instead of need to "Track query" and then click back and forth with "Avg. per execution" / "Totals" having the average on the tooltip when "Totals" is selected will be helpful.
2 votes -
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 -
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 -
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.
-
See Transaction Isolation Levels in Blocking Alerts
There are two methods I have been using to understand blocking situations on our servers:
The processes tab in the Blocking Process alert
The blocking processes section in the server overviewI can get a lot of information from both of these methods but I don't seem to be able to get the isolation levels of the blocking or blocked queries which would be helpful in understanding why the blocking situation has occurred.
Prior to using SQL monitor, we used the blocked process report to monitor blocking and these include the isolation levels. Unfortunately, I still have to resort to…
1 vote -
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 -
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 -
Environment specific Reports
As we have option to create different reports on SQL Monitor, We would like to have the option to create the reports as per environment (Dev,UAT,Prod) for Disk Space,Server Downtime etc. It will be more feasible if we can get a filter to create reports for the specific environment.
1 vote
- Don't see your idea?