Skip to content

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.


In SQL Monitor, I want to...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

182 results found

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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  2. TempDB unexpected growth

    I think it would be a good idea to have information about what caused random sudden growth in tempdb. I know we can see the DB size chart but theres no way to know what caused it.

    Information that would be nice to be captured:

    Table name
    What query created table
    What user created table

    47 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 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)
    Close
    Close

  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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close
    completed  ·  AdminNeil Turner (Admin, Red Gate Software) responded

    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

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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close
    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

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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close
    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

  7. "Installed Versions" tab needs to be aware of GDR updates

    Only Service Packs and Cumulative Updates are currently included in the version list maintained by Redgate, which drives the "Installed Versions" tab. GDR updates are not included.

    In my estate, this has resulted in SQL Server 2012 SP4 installations showing as being fully up to date, when there is a GDR update from January available, to address Meltdown/Spectre.

    Microsoft's official line on GDR updates for SQL Server is:

    "A GDR addresses an issue that has a broad customer impact, that has security implications, or that has both. A GDR is determined and issued by Microsoft as appropriate and when appropriate.…

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  8. Notifications support for Microsoft Teams

    Just like Slack (Webhook) notification support, it would be great if SQL Monitor could send notifications to Microsoft Teams.

    106 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    6 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)
    Close
    Close

  9. SQLMonitor consider the SQL Server cluster name as an instance

    SQLMonitor consider the SQL Server cluster name as an instance

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    4 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)
    Close
    Close

  10. 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)
    Close
    Close
    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)
    Close
    Close
    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

  11. Setting Maintenance Window via API service

    That would be very nice if there as an API service which we would use to set maintenance window for a given sql host or a group of hosts.

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close
    completed  ·  AdminNeil Turner (Admin, Red Gate Software) responded

    Thanks for this suggestion. SQL Monitor 10 now allows teams to suppress alerts, or just their notifications, over certain periods using alert suppression windows. Windows can be set-up using SQL Monitor, or via the API. Please see the example Scripts within Configuration for more details.

    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

  12. Use (Group) Managed Service Account Credentials for Server Monitoring

    Allow the use of managed service accounts (MSA and gMSA) as credentials when monitoring servers.

    Given the high-level permissions required to fully monitor servers, this would provide a higher level of security to match.

    48 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  7 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)
    Close
    Close

  13. Allow the pinning of availability groups to the Global Dashboard

    I'd like to see the status of my AGs on the Global Dashboard without having to find them inside the server. Would also nice to see stats on latency on this widget.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  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)
    Close
    Close

  14. Add more narrow time intervals in Reports

    We are using the reports part of SQL Monitor to show them on a TV screen in a proactive way and we find this very helpful.

    Now we have a question, would it be possible to include more narrow intervals like 6 h, 2 h and 30 min in the reports?
    Because even if we lower the reports to 12 h and has auto refresh every 1 min it’s kind of hard to see and react on the spikes in the graphs.
    An example can be seen in the attached fil - Batch request/sec report, it’s hard to spot the…

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 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)
    Close
    Close

  15. deadlock

    Add the ability to customize deadlock alerts. I want to able to ignore alerts if the deadlock was on table XXXXX or produced by stored procedure YYYYYY
    or have different alert levels depending on the database and table.

    45 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 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)
    Close
    Close
    completed  ·  Adam responded

    Thanks for this suggestion. We will close this now as there have been no new comments since we released the new filters.

    However, please do raise new suggestions for anything you feel hasn’t been addressed, so we are able to consider them as we continue to improve SQL Monitor.

    Thanks,
    SQL Monitor Development Team

  16. be able to choose the actions during maintenance window.

    During a monthly patch round along the servers, a restart or some downtime is mandatory. I want to be able to select the actions SQL Monitor will perform with the alerts triggered within that maintenance window. Most of the time I'm aware of the required Windows reboot, so I do not need an email telling me that the SQL Server was not reachable for a short period. So I would like to tell SQL Monitor not to trigger any alert during the maintenance window. (preferably a one-time maintenance window, see other suggestion)

    22 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close
    completed  ·  AdminNeil Turner (Admin, Red Gate Software) responded

    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

  17. Monitor a failover cluster in Azure

    I have two failover clusters in Azure using ClusterSharedVolume storage, migrated from terrestrial clusters.
    I've been using SQL Monitor to monitor all aspects of these clusters but now I've migrated to Azure, the monitor can't connect (I believe it's to do with the inability to ping the cluster load balancer in Azure).
    I'm sure, as more and more of us migrate to cloud services, that covering an Azure cluster would be most welcome.

    18 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close
    completed  ·  Adam responded

    SQL Monitor versions 7.1.6 and above support SQL Server Failover Cluster Instances and AlwaysOn Availability Groups hosted in Azure.

    https://documentation.red-gate.com/sm7/configuring-sql-monitor/adding-and-configuring-servers/adding-servers-to-monitor/adding-servers-on-a-different-network-from-your-base-monitor

    https://documentation.red-gate.com/sm7/configuring-sql-monitor/adding-and-configuring-servers/adding-servers-to-monitor/monitoring-sql-server-failover-cluster-instances-and-alwayson-availability-groups-hosted-in-azure-iaas

    There are lots of ways in which Azure clusters can be configured, so If you’d like to suggest how we could improve the feature, please drop us a line at sqlmonitorfeedback@red-gate.com

    Thanks,
    Adam

  18. export selected alerts

    it would be nice if we could export selected alerts (for instance full deadlocks related information) to forward to our "partner" so they can analyse the problem.

    21 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 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)
    Close
    Close

  19. Ability to view tempDB usage over past 24 or 48 hours

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  2 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)
    Close
    Close

  20. Pagerduty API/WebHooks and Better Notification channel

    We are in a high secure payments network, we do not wish to open ports used for email (smtp) however we would like integration with Pagerduty.

    Please create a generic web hook interface where the payload can be fully customised or direct integration via there API.

    I would like the option to pick what communication channel is used based on the severity of the alert

    Alert Rule XXXXXX
    H M L
    Email
    Pagerduty X
    Slack X

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    4 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)
    Close
    Close
2 4 5 … 9 10
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base

(thinking…)