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
-
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
-
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 -
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)
-
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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.
-
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 -
To show top server Process memory usage
Under the "Processes", it would that we can sort the top memory usage as well. There are times we got alert that the server memory usage is high and we need to know what other OS processes is utilizing the server memory other than SQL.
1 vote -
Exclude databases with state = 1 (RESTORING) in page verification alert
During a restore the page verification alert gets triggered, even when the database has CHECKSUM page verification. Please exclude database with state = 1 (RESTORING) in this alert! Thanks!
6 votesThanks for this suggestion.
Version 9.0.4 has now been released and the Page Verification Alert will no longer alert when a database is being restored.
We hope this works as you expected and will mark this as complete, but please do let us know if you have any further comments.
Kind regards,
SQL Monitor Development Team -
Display maintenance windows on timeline
When looking at the timeline graph with the CPU/IO/Waits stats it would be very nice to see the maintenance windows, for example as a difference background color.
This would help immediately recognize why IO is spiking for example. I realize that can also be accomplished with the Baseline for regular maintenance but I don't see it as mutually exclusive since a maintenance window can be configured at any time.3 votes -
be able to show basic SSIS monitoring graphs/sparklines on the overview page (Buffers spooled, Buffers in memory, rows read,...).
There is currently no SSIS monitoring in SQL Monitor. You can add custom metrics for performance counters available through SSISDB but these can only be seen on the Analysis page and only after you have selected all of them.
It would be nice to be able to select SSIS as an option for a server and then see these counters as graphs/sparklines on the overview page.
8 votes -
contained
Add support for Contained Availability Groups (CAG) in SQL Server 2022
This is actually a feature that broke with the new version. There is no ability to monitor SQL Agent Jobs.10 votes
- Don't see your idea?