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.


683 results found

  1. Showing Unlicensed and will not allow you to stop monitoring

    I added a server that I needed to monitor for a couple hours. When I was done, I swapped out the license and attempted to pause the monitoring to remove the blue banner at the top:

    You have unlicensed servers. Unlicensed servers will not be monitored and will not raise alerts.

    However, I was unable to pause the monitoring as it just refreshed the page, with the blue bar at the top, and the "pause monitoring" button still enabled and "resume monitoring" button still disabled. Ideally, there would be a way to say I don't want to monitor this server…

    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)
  2. Alerts for suspect_pages

    We would like to see alerts for suspected pages.

    Errors Recorded in suspect_pages Table

    The suspectpages table contains one row per page that failed with an 824 error, up to a limit of 1,000 rows. The following table shows errors logged in the eventtype column of the suspect_pages table.

    Error description eventtype value
    823 error caused by an operating system CRC error or 824 error other than a bad checksum or a torn page (for example, a bad page ID) 1
    Bad checksum 2
    Torn page 3
    Restored (The page was restored after it was marked bad)

    17 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. Analysis graph exclude set times over long time range such as 28 days

    It would be great to be able to set exclusion times such as the "maintenance windows" when index maintenance activities take place such as every day between 12pm-2am in our case. During these times disk queue length will be predictably high due to the maintenance activities taking place.
    When viewing graph analysis for a 28 day period for disk queue length you see peaks which are from the maintenance activities and these events end up skewing the overview of BAU activity.
    It would be great to be able to define an "exclusion time window" in the analysis report window to…

    14 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)
  4. temporary alert configuration

    I have a SQL Agent job that is failing daily. I have already alerted the dev who is repsonsible. I now have two options:
    1. Change the alert setting at the job level to not raise an alert when this specific job fails. Saves me from irrelevant alerts, but one day the dev will fix the problem and I will probably forget that I should turn this back on.
    2. Leave the alert setting as is and spend a half-minute or so each day to clear the alert. Not a good use of my time and very annoying,

    Please consider…

    9 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. Group instances, not servers

    For example: when I have a database cluster running multiple instances I would want have the possibility to put one instance in a development group and another instance from that same cluster in a different group. In this way managing alert settings etc on a group level becomes much more convenient.

    34 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)
  6. Option to include @Channel or @User in Slack Channel Notification

    Provide an option for individual alerts to include @Channel or @User to the slack channel notification.

    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)
  7. filter the queries to see in the top queries and long running queries section

    In top queries and long running queries section, I can see the queries executed by the db system but I want to filter out such queries.

    16 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. blocked by (number)

    This should be easy to implement..

    "blocked by [some number]"
    If available show the security context/or username associated to the session number.

    It would be a time saver, and enable me to react or ignore faster

    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)
  9. Set alert rules on specific AG nodes

    Our AlwaysOn AG groups are backed up from the secondary node (the preferred node). Not Backed Up alerts still show for the primary node. We would like to be able to filter these out.

    14 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. Set up multiple custom alerts for a single custom metric

    For some custom metrics, the ideal number is not a fixed number. (E.g. ideal number of VLFs depends on log file size). In those cases I write a custom metric that returns a "percentage of ideal number". I like to be warned both when the actual number is too high and when it is too low so I would like to set up two custom alerts for this.

    This is currently not possible without creating a copy of the custom metric, which of course wastes resources. Please consider adding the option to set up multiple custome alerts for a single…

    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. Create Duplicate of Default Alerts

    Hi, it would be great to create 2 Default alerts with deffernt setting for differnt servers
    and to seperate AO Group when creating Alerts
    so that a Backup Replica wont go into some alerts that serve the production Servers

    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)
  12. Blocking process Hover Information should show Total Blocking Duration

    The (Restored in 8.0.6) hover over the Alert List's "Last Updated" column shows the duration of the Alert itself, NOT the total time involved.

    Unless you memorize the configuration of this Alert for each of its 3 severity levels, and assume they never change, and never vary by server, nor by database... you must sill open each event to see the "Total blocking duration for all descendants" published under the "Details" tab, then add that to the event duration, for which you must now do time subtraction as there is no "Duration" on the Status line... (another omission).

    Having to…

    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)
  13. I would like to be able to enter a sql handle and see the history of query time and plans

    I would like to be able to enter a sql handle or query hash and see the history of query time and plans in the zoomed time frame.

    17 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)
  14. be able to be advised if a certain query (sql_handle or query_hash) is suddenly taking much longer than normal to execute. Not only to see

    I would like to be able to be advised if a certain query (grouped by sqlhandle or queryhash) is suddenly taking longer than normal to execute.

    The query may or may not be included in the top 10 queries.

    /Rasmus

    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)
  15. Customize Disk Space alert for C: drive on all servers

    SQL Monitor allows me to set global settings for Disk Space alerts, and then override for a complete server group, for all disk of one single server, or for a specific disk.

    What I want is to have different settings for the system drive (C:) as compared to the other drives, Currently I need to set this for each individual C: drive, so one change per server.

    Please make it possible to specify global settings (applying to all disks on all servers), and then add an override for C: on all servers.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. SQL Monitor acquiring shared locks on objects

    Is it necessary for SQL Monitor to acquire shared locks on objects when monitoring a SQL instance?

    We experienced a deadlock on our system when SQL Monitor was trying to query a system table msdb..backupset at the same time that on of our maintenance plans was deleting backup history as one of its sub tasks.

    It would be nice if we could either set the isolation level per alert or if you guys would amend your code to use nolock query hints?

    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)
  17. domain

    Have the Redgate Monitor application support multiple AD domains for users. I have over 4 domains with users that want access to the application.

    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)
  18. Timestamps in UTC

    Currently, timestamps in charts and elsewhere are displayed in local webbrowser timezone. I need all the timestamps in UTC. I need to share screenshots with colleagues in different timezones and having them in UTC is a must have.

    11 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)
  19. Clone a report and change the server name globally within it

    I have crafted a report for my servers. I understand there's some behind-the-scenes scripting I can do to replicate a report, but the GUI could provide a "Clone Report" option, allowing me to change the server name reference on all the widgets. Sure would make deploying one extra server easy.

    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)
  20. View trace queries without alert

    It would be nice to be able to view Trace queries without an alert. For example a separate page to go through the queries against the DB even when an alert is not raised.

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

Suggestions

Categories

Feedback and Knowledge Base