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.


44 results found

  1. Add scheduling for monitoring suspension and resumption

    Using Azure SQL Database in serverless mode with an auto-pause is a useful feature to save money when the db is not in use. SQL Monitor keeps the db from sleeping overnight.

    Suggest addition of scheduling for Suspend/Resume operations, similar to alert suppression scheduling.

    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)
  2. Password is blank when accessing the edit credentials in Monitored servers

    Password is blank when accessing the edit credentials in Monitored servers for the monitored sql instance .
    If any options need to be changed will need to update the password for the SQL and OS credentials

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

    The password is intentionally blank. This is to prevent users that don’t have access to the server from changing these settings.

  3. Add button to hide new grouping and use old grouping

    Although the grouping seemed interesting at first, it means now our servers don’t fit on our screen anymore.

    I would suggest adding a button to the "Group by" header that says "no headers" (or maybe a checkbox somewhere).

    This button (or checkbox) would show the "old" layout again with the grouping on the left side as here: https://www.red-gate.com/wp-content/uploads/2019/10/SQL-Monitor.png

    There is much more horizontal screen real estate than there is vertical; because of these new grouping headers we now need to scroll to see our DEV servers.

    I am fully aware I can click the headers to minimize the content 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…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    declined  ·  Neil Turner responded

    Hi Andy.

    Thanks for the feedback. Groups can be opened and closed and the card sizes can be changed to control the number of instances visible. We feel that it’s important to show the group headings on the dashboard.

    Thanks,

    Neil
    (Lead product designer – SQL Monitor)

  4. Be alerted when a database approaches it's maxiumum file size

    Whether or not autogrowth is enabled, I'd like to be alerted when a database approaches it's maximum file size.

    1 vote
    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. Another Field to Change the Display Order of Servers on the Dashboard

    On the dashboard, server instances are currently ordered by two fields - Name or Severity which is selected via a drop down list. Can we have another field - Sort ID (int), to give users another way to sort? This field can either be hidden or displayed.

    1 vote
    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)
    declined  ·  Neil Turner responded

    Hi Dean,
    This is currently possible by setting an alias for an instance (hover over the righthand corner for a card, click the menu icon and select ‘Alias…’).

    For example you might set:
    1_AliasA
    2_AliasB

    Selecting ‘Order by Name’ in the drop down will then allow you to use this ordering within a group on the dashboard.

    Alternatively you can pin instances to the top of the dashboard (hover over the righthand corner for a card, click the menu and select ‘Pin to top’).

    I hope that helps.

    Neil Turner
    SQL Monitor design lead

  6. Every alert should be able to be cleared

    I recently ran into an issue where a specific alert ("Monitoring error") could not be cleared. Support staff told me this is by design.

    I thnik this is bad design. Every alert, no matter how serious, no matter how breaking, should be clearable.
    Whatever the issue is, once I am aware it is up to me to decide whether I want to continue to be alerted or not. If I know I'll fix it later, or I know I won't (or can't, as was the case for me) fix it, then I want to clear it.
    By not clearing an…

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

    Hi Hugo,

    I’m sorry to hear that you’ve experienced issues with this. There is a setting within ‘Configuration > Display settings’ (see screenshot) to not force errored instances to display red on global overview.

    It sounds like this is the issue that you’ve experienced. If you activate this setting then monitoring errors will not behave in this way on the Global dashboard.

    Neil Turner
    (Lead designer – SQL Monitor)

  7. handle case insensitivity with regex

    We can configure some alerts to be ignored based on names/objects that are matched using reguler expressions.

    Regex is case sensitive, but to avoid having to put all possible combinations in the regex boxes, could that be handled internally by SQL Monitor - for example by uppercasing (or lowercasing) all text before comparing?

    1 vote
    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)
    declined  ·  Neil Turner responded

    Hi,

    SQL Monitor supports all standard .NET regex characters, and uses the IgnoreCase option. All regular expressions are therefore case-insensitive.

    Thanks,

    Neil Turner
    (SQL Monitor product designer)

  8. Add Clear, Unclear, Read, Unread buttons to the end alerts list.

    Add Clear, Unclear, Read, Unread buttons to the end alerts list.
    I like to have 100 alerts per page and its very unpleasant to clear several alert that are on the end of the page.

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

    The ‘Clear’, ‘Unclear’, ‘Read’, ‘Unread’ and ‘Add Comment’ buttons are pinned to the top of the alert inbox list. The buttons are therefore always available as you scroll down the alert inbox.

  9. MONITORED INSTANCES

    Hello good day
    When you enter the Global Dashboard session, it stays loaded and shows the blank page.

    Annex image of the page.

    1 vote
    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. Classic Dashboard Mode

    The new global dashboard is great but it is harder to read at a glance then the old dashboard. Please add in a classic dashboard option.

    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)
  11. A Comprehensive Manual for SQL Monitor

    Currently there is a serious lack of information about SQL Monitor and that's bad for everyone and not just the user base for DPA. Therefore DPA needs a head to toe, top-down comprehensive manual that details every single aspect of DPA from the metrics it captures to the settings it uses and every single function/feature no matter how insignificant needs to be documented in a single manual/guide. When complete there should not be any part of DPA that is not detailed in this manual. While I can see no reason for why something this comprehensive would not be made available…

    1 vote
    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. removed an evicted node

    I would like the ability to remove an evicted node from a cluster. As of today, we have one in such a state and there is no option to manually remove just that single node from "Manage Servers".

    1 vote
    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)
    declined  ·  Daniel Rothig responded

    (reason: bug report)

    Hi Matthew, SQL Monitor should automatically remove evicted nodes after a short period of time – if it doesn’t please contact support and we’ll do our best to resolve the issue

  13. have help page on server where red gate installed . server can not get to internet

    have help pages on server where red gate installed . server can not get to internet to get help info as it is secure site

    1 vote
    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)
    declined  ·  Daniel Rothig responded

    much of our help cross-references external sources, so an offline help would be less valuable (and increase the installer size)

  14. Option to display time zone with time display.

    Example:

    Long-running query Server1 2:05 AM (UTC-5)
    Blocking Server2 8:15PM (UTC+2)

    etc.

    Thanks

    1 vote
    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)
  15. Specify databases for custom metric using wildcards

    We have multiple databases for each of our clients - each type of databases uses the same schema and follows a consistent naming convention. For example:

    XXXXMain
    XXXX
    Extra
    XXXX_Management

    YYYYMain
    YYYY
    Extra
    YYYY_Management

    I want to add a custom metric that only applies to "_Main" schema so in order to choose databases to collect from I need to specify each database explicitly. This proves challenging as the number of clients grows and we add more servers / instances to our environment.

    It would be preferable if i could instead use some form of wildcard to specify databases…

    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)
    declined  ·  Daniel Rothig responded

    A bit of an edge case that would make things a lot more complicated for all users

  16. have the Time Range drop down keep it's selected value

    There's a small bug in the analysis screen. When you choose a time range from the drop down list, it always changes the value to Custom. The dates update properly, the graph shows the right data, it's just the drop down always says "Custom".

    Example in screen shots below, I choose 24 hours, the drop down says Custom (1 day). It should say "24 hours"

    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)
    declined  ·  Daniel Rothig responded

    Thanks for raising this – we’re tracking this as a bug internally. I’m not actually declining it.

  17. Job step failure - trigger an alert, even if the job itself doesn't fail

    CONTEXT: If job step "On failure action" is set to "Go to next step" or "Go to step xy...." and the step fails, we would like to be alerted. The alert should be triggered immediately (as opposed to at the end of the job).

    PROBLEM: SQL Monitor "Job failed" alert doesn't alert in such cases.

    EXAMPLE SOLUTIONS:
    • A new alert.
    • Expanding options on the "Job failed" alert.

    53 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. Compact mode

    The new "touch friendly" layout is annoying and wastes a lot of screen real estate. Please add a compact mode.

    2 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)
  19. Index on msdb..backupset

    One of my servers has a db with many filegroups and does log backups every 5 min. For this reason the msdb..backupset table is very big and SQL Monitors query
    SELECT DBNAME(DBID([databasename])) AS [DBNAME(DBID([databasename]]))], MAX([backupfinishdate]) AS [MAX([backupfinishdate]])], MAX([backupstartdate]) AS [MAX([backupstartdate]])], [type] AS [[type]]] FROM msdb..backupset WITH ( NOLOCK ) WHERE DBID([databasename]) IS NOT NULL GROUP BY DBNAME(DBID([database_name])), [type]

    reads ~3,500 pages per execution (CLUSTERED INDEX Scan) -> one of the TOP 10 queries (at least in the night :-)).

    The following index…

    1 vote
    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)
    declined  ·  Daniel Rothig responded

    Sorry, we can’t add indexes to our users’ production servers to speed up our queries!

  20. Latch Wait Time Explanation

    In SQL Monitor 4.0, the explanation refers to sys.dmdboperational_stats which does not actually exist.

    Should this be sys.dmdbindexoperationalstats?

    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)
    declined  ·  Daniel Rothig responded

    (not actually declined, but we are tracking this separately as a bug)

← Previous 1 3
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base