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.


687 results found

  1. Schedule hourly reports to email out and base on groups

    I would like to be able to send hourly email report for example Failed sql agent jobs base on a group not just one server, covering certain period of time like 9-5 each day of the week Monday- Friday.

    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)
  2. Add date to legend when filtering across multiple days

    When we filter on the top graph across multiple days, on the legend below won't show the days, just the time.

    The image is the current case.

    What I would like is to have the days.
    Instead of "from 08:18 to 08:19"
    expected "from 18 Jun 08:18 to 19 Jun 08:19" or equivalent

    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)
  3. Being able to filter "TOP Queries" by any of the columns

    On the "TOP Queries" grid we can order it by any of the columns (besides "Database").

    I would like to be able to filter the rows by the amounts.

    Example:
    Filter queries where "Execution count > 100" same for other columns.
    Then apply the "order by".

    This way we can filter together with the "Enter search term" box.

    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)
  4. Estate Licensing - Align with Microsoft HA/DR Licensing policy

    Estate licensing appears to tally all licenses for servers in an WFC/HA config. 3 node cluster 4 cores, 12 licenses (when it should be 8). Please provide the process to identify an HA or DR node, which will allow the Redgate Estate portal to align with Microsoft SQL Licensing: https://download.microsoft.com/download/e/2/9/e29a9331-965d-4faa-bd2e-7c1db7cd8348/SQL_Server_2019_Licensing_guide.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…)
    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)
  5. Modifying of several alerts for specific entity could be more user friendly

    1) after change tree in left panel with all servers collapse and again should expand nodes down to place where I left
    2) color of changed records could be more visible, maybe some light background could be added

    4 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)
  6. be able to set top level notification settings through powershell module

    I want to be able to use Redgatesqm.ps1 to configure smtp server, default email list and other top level notification options.

    1 vote
    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)
  7. Long Running Open SSMS Transaction

    Would be really helpful to have an alert that can alert on long running open SSMS transaction and the alert can return the user running it and query being run and on what server we often see it when users forget to commit or role back there transaction.

    4 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)
  8. Only Query Serverless Azure SQL Databases if they are Online and not Paused

    As mentioned in the below post, SQL Monitor will keep serverless Azure SQL databases from pausing and saving us the money they are supposed to. I would like the Azure SQL monitoring piece to be rewritten to use the Azure API to determine both if the Azure SQL DB is serverless or not and if it is AND paused, don't run any queries that would wake it. Yet if it is NOT paused, get info about it and update SQL Monitor.

    https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/45670060-exclude-serverless-databases-from-monitoring

    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)
  9. Uptime of my SQL server database servers

    I need to be able to account for yearly uptime for my SQL server estate and also receive proactive alerts when they are shutting down.

    4 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)
  10. 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)
  11. Outlook calendar style view for SQL Agent jobs

    This would be very useful for viewing all scheduled jobs in an Outlook-style calendar view. Also useful for scheduling new jobs to prevent conflicts.

    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)
  12. Grant more granular report level access

    I can grant report level access to a user by adding them to the Reports User role and I can restrict the servers which they see reports for.

    However, this role gives the user more permissions than I would like to give - they can still view any other page - alerts, server overview etc

    Can we change this so they can see the reports only?

    2 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)
  13. TempDB Percentage Free Space Monitor/Alert

    Common practice is to put TEMPDB files on a dedicated disk and size TEMPDB to fill the entire disk.

    When TEMPDB grows unexpectedly it can quickly use all the space on the disk and is a common cause of SQL Server issues.

    We have great observability about TEMPDB issues in SQL Monitor now but no default alerts.

    We have some metrics we can alert on such as TEMPDB Free Bytes, but a literal value is not much use in a mixed environment where some servers have 1TB+ TempDB databases and some have only 30GB.

    We collect a custom percentage free…

    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. AG sync progress

    Implement Availability Group data synchronization progress.
    We use Automatic seeding and stats can be observed under "sys.dmhadrautomaticseeding" and "sys.dmhadrphysicalseeding_stats".
    Maybe that info not 100% accurate when Traceflag 9567 is ON, but anyway somehow helpful

    1 vote
    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)
  15. Allow Job Name to be used for Long-running query alert exclusion

    For a Long-running query alert, the Job Name is being collected but cannot easily be used for avoiding specific alerts from being triggered.

    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)
  16. Use a private route for AWS RDS instances to remove the need for a public endpoint to monitor the instance

    The current configuration only allows for the specific format my-db-identifier.random-chars.aws-region.rds.amazonaws.com / my-db-identifier.random-chars.rds.aws-region.amazonaws.com.cn. We would like the ability to use any dns name to allow intra-cloud or hybrid cloud scenarios for the ability to use a private/internal route to the RDS instance so that we do not have to use the public route for monitoring.

    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)
  17. Add ability to collapse the "Query details"/"Wait type"/"User memory" list under a specific query.

    Often we want to screenshot the execution pattern, the graph below all these areas and because all of those occupy a big chunk of space on the screen, this becomes harder.

    We end by "zoom-out", crops, or even picking multiple screenshots and doing collages.

    Thanks

    2 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)
  18. Add the ability to use "special" characters (@, #, etc) when using searching in "Top Queries"

    Hi, I'm trying to search some query patterns on the "Top Queries" grid for example "INSERT INTO @" or "INSERT INTO #" (to get all inserts on table variables or temp tables) however, in both situations, the @ and the # is being ignored.

    Please include those (and other chars) to refine our searches.

    Not sure if "RegEx" would be another option that would be even broader.

    Thanks

    2 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)
  19. Set a configurable delay to send the Resolved/Ended emails

    Sometimes the emails sent by SQLmonitor to PagerDuty are delayed for some minutes
    In this case it can happen that PagerDuty received the "Resolved/Ended" emails before the "Raised" emails because this one has been delayed for too long and because the alert was resolved after 1 or 2 minutes...
    When it happening the alert is never closed and generate a useless phone call
    So to fix this issue we would like to delay all the "Resolved/Ended" emails send by SQL monitor to be sure that PagerDuty received the "Raised" emails before "Resolved/Ended" emails

    4 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. Being able to type the (graph) zoom range time

    Sometimes is hard to quickly get to the time range we want to analyse.

    It would be handy if we could have a "free text" time box to type:

    Zoom range Start: 11:10
    Zoom range End: 11:31

    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)
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base