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
721 results found
-
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 -
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”.
-
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 -
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 -
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 -
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 -
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 -
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
-
Monitor Cluster Shared Volumes
Under the “Analysis” section, there are cluster metrics which include four different options relating to Cluster Shared Volume usage.
• Used Bytes
• Used %
• Free Bytes
• Free %If we click on the above, we can review our CSV’s to see whether we are approaching the drives maximum capacity.
What isn’t included is the performance of the disk. For instance, under the Machine metrics section, the following is available:-• Disk avg read time
• Disk avg write time
• Disk read bytes/sec
• Disk write bytes/sec
• Disk transfers/sec
• Avg disk queue length.However, these…
10 votes -
"Index searches/sec"
Why in SQL Server metrics there is no “Index searches/sec”.
In your description for “Full scan/sec”, you mention “The ratio of Index searches/sec to Full scans/sec should generally be no more than 1000:1.”.
It would be very useful to have this counter without having to go through performance monitor under windows8 votes -
Allow configuration -> monitored servers to have configurable retries and wait timeouts.
We have a vpn between our sqlmonitor and several of our sql servers. I'm not sure how often sqlmonitor will retry or wait between retries when that vpn is unavailable due to any number of reasons. When the monitoring becomes unavailable, I would like to be able to allow sql monitor to retry every X seconds for up to X hours or X times as it attempts to reconnect.
33 votesAs of SQL Monitor 5.0, the retry logic is much more robust, and most users have reported no more issues with SQL Monitor reconnecting
- Don't see your idea?