Skip to content

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

  1. 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: CRITICAL

    Please augment SQL Monitor to do the equivalent alerting.

    30 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Daniel Rothig responded

    Custom metrics on sys.dm_io_virtual_file_stats are the best way to get this today

  2. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. 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
    Etc

    In 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. 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 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  5. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    declined  ·  1 comment  ·  Admin →
  9. 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 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    under review  ·  Neil Turner responded

    There 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.

  10. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  11. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  3 comments  ·  Admin →
  12. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. 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 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  Carlos Eriksson responded

    Available 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.

  15. 6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. 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 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  Adam responded

    Thanks 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

  18. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
1 2 9 11 13 36 37
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base