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.


679 results found

  1. 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)
  2. 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)
  3. 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)
  4. 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)
  5. 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)
  6. 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)
  7. 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)
  8. 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)
  9. 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.

    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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. 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)
  11. Make it possible to mark a query to be tracked from the database menu

    On the "Top queries" within the database menu, we can only "View estimated plan" and "Copy query text".

    It would be handy to have here the "Track query" option too.

    Nowadays, if I find it here, I need to filter on the top and only then I can "Track query"

    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)
  12. I would like to set up an alert for disk space projection threshold

    Wanted to know if we can set up and alert when it reaches the threshold of less than a month of projection for disk - this is in the disk monitoring estate for Redgate .

    image.png
    Regards,
    Shaily.

    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)
  13. Number of rows returned by query

    I'd like the ability to view the number of row returned by a query. Tools like Dynatace, XRebel, New Relic are able to display this and it's extremely useful in identifying queries that are selecting too many rows and in need for application logic / code rework.

    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)
  14. Long-Running Query Alert - Occurrences tab to refer only to instances of that query

    In the long running query alert, the occurrence tab shows a history of occurrences of the long running query alert. These alerts are the history of any long-running query rather than just the query in the alert

    It would be helpful to be able to see a long running query alert and see just the alerts for that query to be able to quickly understand whether this query is a regular problem, or something new.

    I appreciate it is possible by highlighting the time period in the server overview page, finding the query and then viewing the query history but…

    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)
  15. Database Tags

    It would be great if, in addition to Instance Tags, we could assign tags to individual Databases as well. This could help in various ways in trying to determine what the purpose is of the vast number of databases we need to monitor and manage.

    9 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)
  16. Make "Source" hyperlink in Alert take you to the specific date time on the Server Overview Page

    If I click on the "Source" Hyperlink in alert, this opens the server overview page for the relevant server, however, the displayed time frame is the default (24 hour period ending at the current time)

    It would be helpful if the server overview page opened at the date / time of the alert as it is highly likely after clicking the hyperlink, that you are going to want to view the point in time of the alert

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

    We're currently reviewing this suggestion as part of general usability improvements.

  17. Banner Messages for planned Downtimes

    Hi!

    We want to put Banners on Top Global Dashboard to inform Users, that we planning Downtimes on SQL Monitor.
    SQL Monitor has build in banners for unlicensed Servers and stuff like that. Would it be possible to show User Messages that there will be a Downtime on SQL Monitor?

    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)
  18. Add a scroll bar to the backup list (bottom within the specific database)

    When we go to the "Databases" at the bottom and we expand a specific one we get the list of the backups that happened during the period we have filtered.

    For a better experience, this list should have a vertical scroll bar it it it will show more than 5/10(?) entries.

    Otherwise the general scroll bar will become smaller, the page height increase a lot and we need to scroll much more

    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. Being able to set alerts based on existing KPIs (Analysis Graph) instead of create a new custom metric

    If I want to create an alert based on some existing KPIs, I need to write the query and can't leverage the existing one.

    Example:
    I want to create an alert when the "Tempdb: Free bytes" is lower than X.
    I can't use the existing "SQL Server metrics" that contain this KPI.
    Instead, I need to create a new custom metric and build the query. (which in the end it will be exactly the same). Only after that I can create an alert.

    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)
  20. When "Totals" is selected, on mouse over still display average values for the metrics

    When we change from "Avg. per execution" to "Totals" the row order can change.

    With bigger numbers, it becomes harder to quickly know if the average is high or not to decide to take a further look.

    Instead of need to "Track query" and then click back and forth with "Avg. per execution" / "Totals" having the average on the tooltip when "Totals" is selected will be helpful.

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

Suggestions

Categories

Feedback and Knowledge Base