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
733 results found
-
Connect to Azure database via express route
Currently I'm only able to connect to Azure SQL Server (PaaS) via internet and URL servername.database.windows.net.
We have a direct connection to our Azure environment via Express Route. Therefore I want to use this also for the monitoring, but per default SQL Monitor uses external URL.
3 votes -
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 -
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 -
Integrate query store with monitor to find regressed queries
Query store already tracks regressed queries. Integrating this into the monitor and having the ability to alert on this would be extremely useful in having early notifications on when a query goes bad before application or system issues come up
5 votes -
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 -
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 -
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 -
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.
19 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 -
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 -
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”.
-
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 -
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 -
When using Windows authentication I want the read-only account/group option.
I like the windows authentication but it doesn't have the read-only option. I would like to be able to add users and AD groups where I can limit the servers, but also make the data read-only, just like the options when not using Windows Authentication.
8 votesApologies for not updating the status of this suggestion. We have supported this since version 6.0.17. When adding an AD user or group, you can now choose whether that user should be a standard or read only user (or an administrator). So you can do this, and can also choose the permission level for each individual user, rather than having to define it for the system as a whole.
Thanks for your patience,
SQL Monitor Development Team -
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 -
Reduce false positives due to log shipping / Mirroring
On secondary server for log shipping/mirroring false positives can be generated for overdue backups/databases unavailable. If these technologies are used for DR purposes then having the checks ignored is unsafe. It is trivial to filter these out with the below code and I'm sure there is something similar in place for Availability Group databases already.
SELECT *
FROM sys.databases
WHERE name NOT IN (SELECT secondarydatabase FROM msdb.dbo.logshippingsecondarydatabases UNION SELECT dbname(databaseid) FROM msdb.sys.databasemirroring WHERE mirroringrole_desc = 'MIRROR')18 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 -
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 -
check if there are any service packs or updates for my SQL Server instances
check if there are any service packs or updates for my SQL Server instances. This could then raise an alert to prompt me to investigate these updates.
14 votes
- Don't see your idea?