Suggestions

Welcome to the Redgate SQL Monitor feature suggestions list. Tell us how we can improve SQL Monitor by voting on these suggestions or by submitting your own ideas.

This is the easiest way to make an impact on SQL 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 — often the SQL Monitor team will initially stay quiet about new suggestions to see what you have to say!

If you have any questions visit the SQL Monitor forum.

  1. Wire up Notifications to MS Teams (in addition to Slack)

    Wire up Notifications to MS Teams (in addition to Slack)

    12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  2. Don't check Agent status for Express Edition

    Whenever I add a server to the monitoring that is Express Edition, I get alerted that the SQL Agent service is not running.
    Well d'uh. It's Express Edition. The Agent service cannot run on it.

    Instead of always giving me this alert and then having me go in and disable it for yet another server, why not change the logic to not raise this alert at all when the edition is detected as Express?

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Add 2017 CU14 to Estate view

    Currently SQL Monitor shows the latest SQL Server 2017 version to be CU13 yet the latest is CU14. This should show the latest version.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. SQL Agent jobs with a 'cancelled' status are incorrectly flagged as 'Job failing' in the Alert Inbox

    With Always On related SQL Agent jobs, an initial job step is added to check whether the target database is Primary/Secondary on the cluster node. If 'Primary', then continue with subsequent job steps, if 'Secondary' then stop and do not attempt any further job steps. In circumstances where the job is stopped the last run outcome is shown as 'Canceled' - however, SQL Monitor shows these particular status jobs as 'Job failing' in the Alert Inbox. The job hasn't really failed and has been stopped in a controlled way. Can the status of these job be correctly identified please?

    11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  Adam responded

    Thanks for this suggestion, and for the additional comments which helped us decide quickly what solution to implement.

    Version 9.0.13 released 23rd May includes a new Job cancelled alert (off by default) and stops the existing Job failing alert being raised for cancelled jobs.

    We hope this meets requirements and will mark it as closed, but please do raise further suggestions for any improvements you would like to see.

    Thanks,
    SQL Monitor Development Team

  5. In the Estate view you are 2 CU's behind for SQL Server 2016.

    Currently SQL Monitor shows the latest SQL Server 2016 version to be SP2 CU4 yet the latest is SP2 CU6. This should show the latest version.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  6. Have more flexibility in Maintenance Window Schedules

    We do OS and SQL Server patching one Sunday a month for dev and QA and the following Sunday for production. I think if maintenance windows scheduler looked more like setting a schedule in an agent job it would be perfect for setting these kinds of maintenance windows. And if we could drive setting / modifying maintenance windows via T-SQL that would be even better.

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for this suggestion. SQL Monitor 10 now allows teams to suppress alerts, or just their notifications, over certain periods using alert suppression windows. Please see What’s New in SQL Monitor 10 for more details (https://www.red-gate.com/hub/product-learning/sql-monitor/whats-new-in-sql-monitor-10).

    We hope this meets requirements and will mark it as completed. Please raise further suggestions for any improvements you would like to see.

    Thanks,

    SQL Monitor product team

  7. suppress emails during maintenance window

    Allow the ability to suppress all alert emails during a maintenance window. Right now we have ~65 SQL servers and during windows when the OS team is patching and rebooting the servers we can receive 100's of emails as the servers go up and down. It would be great if we could set a schedule or at the very least a single use window when emails don't get sent.

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for this suggestion. SQL Monitor 10 now allows teams to suppress alerts, or just their notifications, over certain periods using alert suppression windows. Please see What’s New in SQL Monitor 10 for more details (https://www.red-gate.com/hub/product-learning/sql-monitor/whats-new-in-sql-monitor-10).

    We hope this meets requirements and will mark it as completed. Please raise further suggestions for any improvements you would like to see.

    Thanks,

    SQL Monitor product team

  8. Read Only users should not view Analysis page.

    When restricting "Read Only" users they can still see all servers when viewing the "Analysis" page. I think this should also exclude any servers not explicitly defined in the Managed Users page.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  Adam responded

    Thanks for this suggestion. This has been fixed in Version 9.0.6 (although I would suggest updating to the most recent version, v9.0.7 at time of writing) when we fixed the issue SRP-11791: AD user can see names of servers they don’t have access to fixed for Analysis and Backups.

    Hopefully this completes this suggestion.

    Thanks,
    SQL Monitor Development Team

  9. Remove wait type VDI_CLIENT_OTHER from the wait graph

    SQL Monitor shows high waits for SQL Server 2016+ systems that implement availability groups configured for automatic seeding. Since a multiple system processes called VDICLIENTWORKER are left running by design. This wait tends to be the top wait in an AG configuration and erroneously indicates a problem that does not really exist.

    10 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. New Licensing for Azure SQL Databases

    If you are going to start licensing by the number of Azure SQL Databases, at least provide the option of adding and removing databases from the Azure SQL Server.
    I have three databases on one Azure SQL Server that are costing me licenses, however two are data warehouses and one is paused. If they are not being monitored, why am I being charged for a license?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  Adam responded

    Thank you for this suggestion.

    The ability to add/remove individual licenses for Azure SQL Databases has been implemented in version 8.0.22, released on 13th November.

    We hope this meets your requirements and will mark this suggestion as completed, but please do let us know if you have any further feedback.

    Thanks,
    SQL Monitor Development Team

  11. PLEASE PUT BACK THE OPTION TO SELECT MULTIPLE ALERTS

    is anyone as frustrated as I am about the removal of selecting multiple alerts and adding a comment in one swoop?

    At least make it an admin option so that it can be turned on or off

    We are wasting so much time every day trying to clear alerts and it is unproductive

    26 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  Adam responded

    Thanks for letting us know this was important to your workflow.

    Version 8.0.23 has now been released and includes the return of the ability to add comments to multiple alerts.

    This was initially removed while developing the ability to group alerts, and it’s taken us longer than expected to reintroduce – apologies for the inconvenience this caused.

    We hope this solves this suggestion so will mark it as completed.

  12. Comment multiple alerts at once

    I would like the ability to add the same comment to all of my selected alerts before clearing them in the Alert Inbox.

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  Adam responded

    Hi,

    Thanks for this suggestion.

    Version 8.0.23 has now been released and includes the return of the ability to add a comment to multiple alerts.

    This was initially removed while developing the ability to group alerts, and it’s taken us longer than expected to reintroduce – apologies for the inconvenience this caused.

    We hope this solves this suggestion. We’ll mark it as completed, but please do reply if you have any further feedback.

  13. Comment multiple alerts at once

    I would like the ability to add the same comment to all of my selected alerts before clearing them in the Alert Inbox.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  Adam responded

    Hi,

    Thanks for this suggestion.

    Version 8.0.23 has now been released and includes the return of the ability to add comments to multiple alerts.

    This was initially removed while developing the ability to group alerts, and it’s taken us longer than expected to reintroduce – apologies for the inconvenience this caused.

    We hope this solves this suggestion. We’ll mark it as completed, but please do reply if you have any further feedback.

  14. reports timespan options

    Please add 14days as the timespan in the dropdown for the reports

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  15. 2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  Adam responded

    Hi, thanks for this suggestion.

    We have added a button to the query plan that allows the full in-truncated text to be copied to clipboard.

    We hope this improvement solves the suggestion so will mark it as completed. Please do let us know if you have any further feedback.

    Thanks,
    SQL Monitor Development Team

  16. See last backup of each type in Overview page

    Currently the backup section in a database on the overview page shows the backups that happened in the selected range, and it only shows the last backup of each type that happens. We have a database that does full backups once a week and then differentials.

    It would be helpful at a glance to see the status of the last backup of each type regardless of if it happened in the time window or not. Maybe hide the last differential if it happened before the last full.

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  Adam responded

    We have redesigned the Backups information to more clearly show the selected range it refers to, and also show when the last backups occurred prior to that. This can be seen in the latest version (8.0.25)

    We hope this improvement completes the suggestion and will mark it as completed. Do let us know if you have any further feedback

  17. Prompted for update to version 8.0.12 but website is a dead end

    The "update" link in the SQL monitor console takes me to a "learn more" page with no link to an update EXE. I am referred to a zip file with a SQLBundle EXE which doesn't contain the Monitor, or an outdated version of SQL Monitor.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  Adam responded

    Hi,

    Thank you for reporting this, and apologies that you encountered it. We removed version 8.0.12 owing to a bug, and have since released 8.0.13.

    I will close this suggestion, but if you require further assistance with this issue, please could you let us know using the support forum https://forum.red-gate.com/categories/sql-monitor-7

    Kind regards,
    Adam
    SQL Monitor Development Team

  18. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    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

  19. Alerting on Autogrowth Events

    Alerting on Autogrowth Events, some environments set the file size of their databases and would like to be alerted if autogrowth occurs since that indicates abnormal behavior

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  3 comments  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 6 7 8
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base