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
-
SQL Agents Job Display Time Windows that Jobs are executing
The SQL Agent Jobs screen is a great way to track all jobs across all monitored servers. I think it would be helpful to see the gaps of time that no job is running to help determine maintenance windows and also make sure that the jobs are properly spaced out.
13 votes -
See data in local server time
I'd like to all the data from a particular server in local server time instead of my time
2 votes -
Customize Disk Space alert for C: drive on all servers
SQL Monitor allows me to set global settings for Disk Space alerts, and then override for a complete server group, for all disk of one single server, or for a specific disk.
What I want is to have different settings for the system drive (C:) as compared to the other drives, Currently I need to set this for each individual C: drive, so one change per server.
Please make it possible to specify global settings (applying to all disks on all servers), and then add an override for C: on all servers.
18 votes -
Per database table fragmentation.....
I would like to see a a Sql Monitor "information" page that shows the "top 10" fragmented tables on a per database level.
121 votesGood idea! If this suggestion gets more traction, we’ll implement this.
-
LDAPS Support for user authentication for Redgate SQL Monitor
LDAPS Support for user authentication for Redgate SQL Monitor . Now organization want to make the ldap communication to be more secure and moving to LDAPS communication . LDAP will be discontinued soon . When can this be implemented
4 votes -
Forecast and plan disk/database capacity
CONTEXT: When looking after a large number of databases, we have to make sure that none of them run out of space or I/O capacity.
PROBLEM: SQL Monitor needs to show us:
• The current size of Database files (and which disks they are on) and how full they are, ideally with a forecast
• Autogrowth configuration
• Space remaining on disk, ideally with a forecast
• File and disk-level IO metrics, ideally with a forecastEXAMPLE SOLUTIONS:
• Provide this data as metrics in the Analysis Graph
• Create a Disk Overview report with this data
• Enhance…217 votesThank you for this suggestion. Version 8.0.10 released July 10th, 2018 includes a new Estate tab containing the new “Disk Capacity Planning” feature.
We hope this meets the requirements and will close this suggestion, but please do raise another suggestion if you have specific improvements you’d like to see.
Kind regards,
Adam
SQL Monitor Development Team -
Add ability to search Server Log
I would like the ability to search the error log or at least filter out some alerts. For example, we get about 45 "Log has been backed up" log entries every 15 minutes. It's very hard to actually find things on redgate without having to login to the SQL server and filter there.
8 votes -
Add Key Lookups to the SQL Server metrics
Though Page Splits and Full scans are useful metrics for index's, key lookups can be handy in finding areas where covering indexes are required and have been helpful in seeing where there is a regressed query from a bad plan - this would be a handy metric to have within the SQL Server metrics part of the main dashboard next to the other 2 mentioned.
21 votes -
Identify which Virtual Host a server is on
In our environment we have a number of different virtual hosts and clusters on which our servers are hosted. It would be quite useful if the SQL server summary information showed the name of the host and cluster on which it is being hosted. As well if host and cluster name could be displayed somehow on the analysis graphs that would be great.
12 votes -
Monitor sessions and stats on an Oracle Active Data Guard (open read only)
Currently, if you set up an Oracle Active Data Guard database in Red Gate, it detects that it is a standby database and doesn't gather any usage, session, activity, or other data from it. However since the database is open for read, there is session data, performance data, and other metrics created that are unique to this database. Basically, the request is to monitor an Active Data Guard database as a standalone database (with the caveat that it is read only).
If Red Gate could gather those stats without requiring sysdba privileges or connection to the primary that would be…
6 votes -
Stop being nagged about maintenance windows - because they don't fit our operation
The nag about "you haven't set up any maintenance windows" is something you could allow us to turn off. Period.
SQL Monitor's simplistic feature does not tie in with the way Rackspace performs their patching, so the feature is useless and the nag is annoying as it keeps on coming up and we keep on dismissing it.
Please, give us a "Turn of maintenance window reminders globally" option - it can't be that hard to do...
15 votesHi,
SQL Monitor 7.1.11.9625 has been released to check for updates and contains a fix for this bug (SRP-11455 fixed an issue where some informational messages were not dismissible).
Please do let us know if you continue to see this issue. Thanks for your patience.
Adam
SQL Monitor Development Team -
Exclude specific alerts from SQL SERVER ERROR LOG ENTRY alerts
We have certain tools (mainly infosec related) that generate a lot of entries in the SQL server error log as part of their normal operation creating a lot of alerts. The only way to identify these and thereby determine that they are 'expected' is to go into each alert individually and mark it as read. The ability to ignore certain errors based on error number, severity or message would add a lot of value to this feature.
47 votes -
Maintain Base Monitor Service Account between upgrades
Everytime you upgrade the base monitor (every 2 weeks), the service account that is configured to run the service gets reset to "Local System".
We have setup our system to run as a domain user to changing this everytime is painful.
The installer should respect the current user when upgrading.
3 votes -
Grant Web Client Access for Specific Elastic Pool, Instance or Database
We can currently share the web console out at the Server, Cluster or Replica level.
I would like more granularity and be able to share at lower levels:- SQL Server Instance
- Azure SQL Elastic Pool
- Azure SQL Database
We are a very large IT department with people dedicated to individual systems/databases.
I would prefer to hide things they don't own.3 votes -
basic microsoft active directory/exchange monitoring
since i have 2 unused licenses it would be very nice if could could monitor my exchange server and also my active directory domain server.
for instances how many mails are being send and received or are in the queue
was any user account locked? etc3 votes -
Showing Unlicensed and will not allow you to stop monitoring
I added a server that I needed to monitor for a couple hours. When I was done, I swapped out the license and attempted to pause the monitoring to remove the blue banner at the top:
You have unlicensed servers. Unlicensed servers will not be monitored and will not raise alerts.
However, I was unable to pause the monitoring as it just refreshed the page, with the blue bar at the top, and the "pause monitoring" button still enabled and "resume monitoring" button still disabled. Ideally, there would be a way to say…
4 votes -
Improve the performance of the user interface
When I access the user interface (hosted on IIS) it is quite slow to use.
It frequently takes several seconds between clicking on something and things happening.It does not appear to be a resource problem, as both the IIS/Monitor server and the database server has plenty of resources to spare.
14 votesI’m marking this as “closed” seeing as performance improvements will be indefinitely be delivered, so it would never make sense to consider this work “done”.
-
Improve alert troubleshooting by showing sql server error log
When viewing an alert it may be helpful to see the error log for the server for the surrounding time. RAISERROR can log to the error log, so this info could be useful to see.
8 votes -
Add a Description field in the Databases section
Dashboard, drill down to the Databases Screen. In that section, there are currently 4 fields or columns - Name, Availability, Transactions/sec, Database size. Will it be possible to add another string field to store a high level description of the database; this will be really useful for our users. Can the new field comes after the name, be 200-300 characters in length and can be a pop-up if a mouse pointer hovers over it. Many thanks.
1 vote -
maintenance windows
To track 'up-time' (probably using a custom metric) which can be used at 3, 6 and 12 month intervals to show the servers uptime accurately. But it would be useful to ensure that data from with the Maintenance Window is not included. Therefore it would be very useful to have the option to either suspend data collection for some or all custom metrics during the Maintenance Window, or even suspend all data collection during the window.
7 votesquite an invasive change to how maintenance windows work to serve an edge case – See this for a better approach: https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/12881094-custom-reports-against-alerts-queries-and-metrics
- Don't see your idea?