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
741 results found
-
Select and store a static baseline for future reference
CONTEXT: When comparing server performance over longer periods of time or across deployments, the baseline functionality in SQL Monitor's analysis section is useful.
PROBLEM: SQL Monitor creates a dynamic baseline based on previous data. While this baseline is a realistic idea of what's "normal" it requires us to keep a lot of data in SQL Monitor
EXAMPLE SOLUTIONS:
• Aggregate data in SQL Monitor so that it can be retained for longer without using much space
• Allow us to "freeze" a baseline so that the data doesn't get deleted.What do you think about these solutions? Got another…
41 votes -
Alert on long I/O operation
Hosting Company raised an alert that there is absolutely no trace of as an issue according to SQL Monitor:
ALERT NAME: Rackspace - SQL I/O Error
TIME: 6/22/2011 7:02:21 PM
REASON:
Event Description: SQL Server has encountered 174 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [M:\xcp_trans.mdf] in database [xcp_trans] (5). The OS file handle is 0x0000000000000BBC. The offset of the latest long I/O is: 0x000023b6d20000
SEVERITY: CRITICALPlease augment SQL Monitor to do the equivalent alerting.
30 votes
Daniel Rothig
responded
Custom metrics on sys.dm_io_virtual_file_stats are the best way to get this today
-
Database name "like" filter for "Database Unavailable" alert
In our environment we have several systems (3rd party ETL/reporting packages) that create and drop databases as part of their normal operation.
Would be good if the "Database Unavailable" alert allowed configuring to ignore drops of database names either matching a "LIKE" filter or perhaps more advanced a regex filter.
16 votes -
Keep from Locking Account When Registering Server with wrong password
The process of registering a server should try only once with a credential failure, looks like it keeps on trying and if you have typed in a wrong AD password it will lock your account.
5 votes -
Detect Unsupported SQL Server Versions When Upgrading Versions
I was running v4 with a MSSQL 2005 database and decided to upgrade to v6. The installer finished successfully, however when it took me to the Web App page, there was a warning that the database upgrade did not complete successfully. The reported error was "Cannot assign a default value to a local variable". I knew right away it was a problem with my old SQL Server version. I checked the forums and indeed, 2005 is no longer supported with version 6. I understand that, and have no problem with it. However, ya'll would have saved me the headache of…
6 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 -
Deploy the latest API when updating Redgate Monitor
I would like when installing the latest version of Redgate Monitor to have an option for it to deploy the latest version of the API as well to a location. The last few times I have done the install I have not updated the API right away as it been a set and forget thing. Comes the evening when it runs it fails due to the versions not being the same.
I have checked within the Program Files and 2/3 of the files are not there. (RedgateMonitor.psd1 and RedgateMonitor.psm1), so I cannot just have it import…4 votes -
Control the delay before getting "Error on Base Monitor"
We have perhaps a unique use case where one of our Base Monitors is at a remote site with a very high latency (700+ ms). Monitoring works surprisingly well since one of the later updates but unfortunately we are getting regular “Error on Base Monitor” emails (10+ per day) even though the connection itself is stable (just very slow).
We would like to be able to control the delay before that error is raised, I’m guessing that slightly increasing this "timeout" would fix all our issues.3 votes -
Periodically or manually request "check disk size" for when SAN Drives are reconfigured on the fly
We resized the log drive from 100GB to 170GB. SQL Monitor shows 100GB until the base monitor service is restarted.
Periodically, i.e., once a day, re-check disk sizes.
Perhaps on the configuration page, show a button to "re-evalute server base characteristics", which would include disk drive sizes.
10 votesDisk capacity is re-evaluated regularly (every 10 minutes or so)
-
Change unable to connect error messages to include DNS issues
Added a server via IP address as it's in a remote DC, test ran fine. After clicking Add to monitor the server, SQL Monitor resolved the IP to the cluster name, and attempted to add the 2 cluster servers via name (which is great, much easier to recognise servers via name than remember the IP), however SQL Monitor failed to connect, with WMI errors, RPC Server unavailable etc.
These errors were misleading, as the real reason it wouldn't connect is that the server couldn't resolve the DNS names. Adding them to Hosts file sorted it straight away.…3 votes -
Add Database Filtered in Top 10 Queries\Wait Section
Can you Add Database Filtered in Top 10 Queries\ Wait Section.
We have more than 500 databases in instance . If you add Databases filtered than we will very helpful.5 votes -
Monitor Table Growth and get projections
It would be nice if in the Estate tab under disk usage, we could dig deeper and see table growth and projected growth over time.
19 votes -
Provide Mobile version of Alert Monitoring Screen
It may be just me (since no one sle has yet to suggest this) but a mobile friendly version of SQL Monitor for the ALERTS tab would be of great benefit. Currently I check the ALERTS on my SMART PHONE which has a screen waaaayyyy to small to do this but since I have no tablet option I have no other choice.
A mobile option at login to SQL Monitor would let those with smaller sized computing devices acccess the ALERTS tab so as to monitor/check in on their SQL Monitor instance remotely.
Thanks
16 votesThere are currently no plans for a SQL Monitor mobile app. We hope to improve the experience when using SQL Monitor on a mobile device. However at the moment we can’t give a timescale for when this might happen.
-
Login to SQL Monitor using a CAC
For members of the military or contractors, they login to systems using Common Access Cards (CACs). It would be great to allow users that are authorize to login to SQL Monitor, to be able to log in with just using their CAC and pin number.
1 vote -
why It splits the server and port
when I try to add the sql instance to monitor , I have to use port and when I do so it splits into two servers. also host and instance is bit confusing , why it goes as local for anyserver you addd to monitor
0 votes -
Overview database growth estimation
When planning new server we have to estimate how much space will be taken by database during life cycle of new SQL server and when SQL monitor watching server for us I would like to have possibility see following:
- Database file size portion
- Log File size portion and how much of that contain free space
- Estimated growth (as information in Alert)
- Summarized size per disk (if possible with how much space left)
- Have this available as summary tile in the report, so I can reactive this info as email.
Thanks and regards,
//Radek
1 vote -
We would like to have a log of users that did use RedGate Monitor
In that way we could create a report of the users when they did use RedGate Monitor. example a weekly or monthly report showing how many times a user did use the application.
3 votes -
Estate view (SQL Server version) Discrepancies
For the SQL 2016 versions of SQL Server, we are seeing the software is flagging as "not current". However, we do have the latest SP/GDR.
This issue lies with the Azure Connect Feature which only applies to connections to Azure based on an article we read. . (https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2016/build-versions)
We do not use Azure so we feel that this should not be a required patch.
3 votesAvailable from version 14.0.13 (July 19, 2024).
The Versions page under Estate will no longer recommend users to update instances of SQL Server 2016 to the latest Azure Connect Feature Pack GDR unless that instance is already using an earlier version of it.
-
I only have one SQL Server, take me to the instance Overview instead of global dashboard
I only have one SQL Server instance, instead of seeing one small bit of info and having to click that in the new global dashboard, take me directly into the instance so I can get relevant info on first login/site visit. Think about your design when we just have one server.
5 votes -
Pie chart in SQL versions estate page to have CU patch status rather than SQL server version
Pie chart in SQL versions estate page to have CU patch status rather than SQL server version
6 votes
- Don't see your idea?