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.


219 results found

  1. Job duration taking too long - triggering WHILE job is still running

    CONTEXT: If a job is taking a long time (outside of some predefined threshold), we want to be alerted about it. That’s often an actionable alert – we could decide to stop the job, we could let the users know that report XY will be late as a consequence etc. One step further is being alerted on the job STEP level as well.

    PROBLEM: Current alert “Job duration unusual” is triggered AFTER the job completes, if it meets the alert's criteria. We need an alert to trigger WHILE the job (or job step) is still running, but the criteria is…

    118 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  2. Be able to customize sql agent job failure notifications turn on/off at the specific sql agent job level

    Be able to customize sql agent job failure notifications turn on/off at the specific sql agent job level.

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  3. Email Reports as an attachment

    I know that it is possible to email report on a schedule basis.
    But it only sends a clickable Link to the report.

    Is it possible to send a PDF as an attachment on a schedule basis?

    16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  4. Group expensive queries by query hash

    I would like to have a section where the query execution counters are aggregated per query_hash.

    We use Dynamics Ax ERP and in order to avoid parameterisation issues we enabled passing company literals instead of parametres. This now leads to a single expensive query "taking up" as many of the top 10 query slots as there are companies executing this query.

    Ideally it would be possible to show the top 10 query hash data on the top level and then drill into each sql handle and view the query statistics and history there.

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →
  5. Report Email Attachment Name

    Name the pdf attachment something other than "AttachedReport".
    The report has a title and a date which could be used to name the attachment. That would really simplify the process of saving the reports for baseline purposes.
    e.g. "Server2ProcessUtilization20180308.pdf"

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  6. Notifications to Slack Only

    Would be nice to have the option to send some alerts to slack only, at the moment the only option is to send to slack and email, or don't send to either.

    7 votes
    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 →
  7. Database File Usage Alert - Autogrowth

    Database File Usage Alert : Please consider autogrowth! So far, this alert is of no help.

    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  ·  Adam responded

    SQL Monitor v7.1.18 added an option to disable database file usage alerts when autogrowth is enabled. The setting can be found on the configuration screen for the database file usage alert.

    Thanks for helping us improve this feature with your suggestion.

    SQL Monitor Development Team

  8. 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)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    completed  ·  Neil Turner 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

  9. 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)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  10. SQL instances which are part of Availability Group does show if it primary or secondary in Global Dashboard

    When SQL instances which are in Availability Groups are being monitored, the global dashboard lists both the primary & secondary node.
    However though it does have 'AG' badge but it does not say which is primary or secondary.
    While looking at the SQL monitor it will key that we know upfront which is the primary instance and also when alerting it should say primary or secondary in the subject line.

    48 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  11. Exclude specific alerts from SQL SERVER ERROR LOG ENTRY alerts

    We have certain tools (mainly infosec related) that generate a lot of entries in the SQL server error log as part of their normal operation creating a lot of alerts. The only way to identify these and thereby determine that they are 'expected' is to go into each alert individually and mark it as read. The ability to ignore certain errors based on error number, severity or message would add a lot of value to this feature.

    47 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  7 comments  ·  Admin →
  12. display unlicensed servers in different color

    We started with RedGate Monitoring and added all our SQL Servers. As a result we consumed too much licenses. Although there's a warning on the top of the screen for this, the unlicensed servers are reporting 'healthy' which is a little tricky (especially for non-dba it'ers) because you don't know the state.

    I like to see the unlicensed servers in a different color ( for example gray) to see a better reliable overview

    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  ·  Neil Turner responded

    Unlicensed servers are now shown as grey on the global dashboard.

  13. Add a "Check for updates" link in the About section

    Alternative for when you've clicked away the "new version available" notification

    3 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 →
    completed  ·  Adam responded

    Hi,

    We have now added check for updates to the About section in version 7.1.16.

    Thanks for the suggestion. I’ll mark this as completed now, but do let us know if you feel it should be reopened.

    Thanks
    Adam
    SQL Monitor Development Team

  14. 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)
    You have left! (?) (thinking…)
  15. 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)
    You have left! (?) (thinking…)
  16. Link executions of top 10 queries

    I had an issue with a query that runs slow every other day. For a specific slow day I could find it in the top 10 queries. I'd like to be able to easily compare the days when it was previously executed . I did manage this by opening a new tab to select the fast day - the query was hard to find as there were many other queries in the top 10 on the fast day. I'd like to be able to lock in on a specific query and monitor the server/query stats at the time/duration of previous…

    5 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

    Thank you for this suggestion. A graph showing a query’s history was added to the Server Overview Top Queries table in Version 7.1.11 in November 2017. This allows you to see a query’s performance over time, view its execution count, duration, reads, and writes, and the points in time a query’s plan changed.

    We will close this suggestion, but please do raise another suggestion if you have other specific improvements you’d like to see.

    Kind regards,
    Adam
    SQL Monitor Development Team

  17. Please remove the 20 character size limitation from the Alias feature

    Given that actual server named instances can be longer than 20 characters (even if they are truncated on the display), it makes no sense to limit an alias to 20 characters. Please significantly extend this limitation.

    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  ·  1 comment  ·  Admin →
  18. Missing database name in blocking session alert

    When I receive an alert about a blocking session, it does not tell me the database. The mail starts with e.g.

    Blocking Session ID: 93
    Number of blocked descendants: 1
    Total blocking duration for all descendants: 00:03:02
    Blocking SQL fragment: CREATE PROCEDURE [dbo]...

    In the subsequent blocks (blocked sessions) it shows the corresponding database name, but only after much of scrolling, when the block cames from a long procedure (some with > 1000 lines).

    So please add the database name to the blocking session part too.

    5 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 the suggestion. Version 7.1.3 has now been released and improvements include adding the database name to the Blocking process alert.

    Kind regards,
    SQL Monitor Development Team

  19. 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)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    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

  20. 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)
    You have left! (?) (thinking…)
    completed  ·  7 comments  ·  Admin →
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base