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. Add AND/OR conditions for disk alerts

    We are using SQL Monitor to monitor disks and we also send these disk alerts to our NOC(24/7 monitor team) and when they receives an alert they are calling us on our On-Call service when outside office hours.

    The alerts are not always relevant as the alert can be like for example:
    Disk free space less than 5 % but actual space left is 300 GB, which is more than enough and no alert and phone call had to be triggered.

    We are trying to set custom disk alerts but as we have 1000+ disk alerts to configure it’s impossible…

    44 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. show client host name for queries in top SQL

    In the TOP SQL, I see login and program name, but not client host name. It would be helpful to see the client host name, too.

    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)
  3. Backup overdue alert - RegEx filter

    I have many non-production databases on production SQL Instance, that make no sense to backup. I know I can turn this alert off one by one on each database. RegEx filter by database name would be help.

    12 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. Monitor SQL Server running on AHV hosts

    Whilst you have added the ability to monitor vmware hosts, I would like to be able to monitor other virtualization technologies. E.g. AHV (Nutanix)

    6 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)
  5. Customize Estate Version Thresholds

    On the estate tab, it would be nice to customize the thresholds that define the yellow and red state. For example, a server behind on one CU might be yellow, but others red.

    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)
  6. See the last X weeks of User transactions/SQl statments ran on the server

    Have a view in SQlMonitor that can be used to do a quick search on what querys a user has run on SQL Server over the last X weeks.
    For our user case we would just need the data for the last two weeks but sure if storage allows user's would like to hold the data for longer.
    This is to enable some auditing functionalty to quickly find what a user has ran for reporting.
    e.g.
    What did user1 run yesterday,
    What was run and by who over the last hour

    This could also help with finding performance issues. For…

    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)
  7. Blocking process report does not display database name

    I would like to see databasename and also starttime and endtime in the blocked process report. It qwould also bee good to be able to scale the picture in size.

    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)
  8. Monitor Distributed Availability Group Metrics

    Monitor Distributed Availability Group Metrics, currently there doesn't appear to be any metrics tied to distributed AG. Could be as simple as using the monitoring query her:
    https://tracyboggiano.com/archive/2017/11/distributed-availability-groups-setup-and-monitoring/

    13 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. Exclude a database, instance or the entire alert based on an actual alert

    It would be a nice feature to be able to click on an alert and get the option to exclude future alerts:
    1 - for this specific database
    2 - for this specific instance
    3 - for this specific alert

    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)
  10. Monitor Resource Governor

    Possibility to monitor Resource Governor Pools:
    • Show statistics on pools
    • Show workload of groups: cpu, io and memory

    18 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. "Index searches/sec"

    Why in SQL Server metrics there is no “Index searches/sec”.
    In your description for “Full scan/sec”, you mention “The ratio of Index searches/sec to Full scans/sec should generally be no more than 1000:1.”.

    It would be very useful to have this counter without having to go through performance monitor under windows

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. Job Duration Unusual: Threshold higher than 100%

    Currently when configuring different threshold in the "Job Duration Unusual" alert we are limited to a maximum of 100% of the baseline. So for example if I wanted an High alert when a job is 5 times the baseline it's not currently possible, I'm limited to 2x.

    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)
  13. be able to move database to another server

    Sometimes I need move database to another server. I did it last time and I lost access to historical data. Moving databases is very common practice.
    I think it is a big disadvantage.

    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)
  14. Add waits, CPU, & IO to the "sort by" options on the Global Dashboard.

    Currently there are only two choices to sort by for the Global Dashboard screen:

    Name & Severity

    It would be nice to add more options, as they are displayed in the tile view. The options of course would be waits, CPU, & IO.

    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)
  15. compare different times in analysis graph

    We have upgraded SQL and changed servers for one system It would have been nice to compare in the same graph different timeslots and different machines

    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)
  16. Query Plan Regression

    Ability to track queries and alert when query plan regresses or duration increased beyond a given threshold.

    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)
  17. Add support for Windows Server Core

    Server Core has a lower attack surface, uses less RAM and disk space and is the default way to install Windows Server

    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)
  18. Raise an Event Alert when a database is dropped

    There is currently no alert when a database is dropped or detached from a server. SQL Monitor should create an Event alert to record when the drop happened. Obviously this might be intentional (e.g. the alert you have now that records a database is offline), but it might be accidental or unknown to the DB team (E.g. a vendor drops their database).

    Because it will (hopefully) be an intentional action, and quite probably no plan to ever re-attach the database, the alert should be an event alert rather than a normal alert (the normal alert would never end)

    A similar…

    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)
  19. Sort top queries by logical reads, or cpu usage.

    Same idea that is already being done with duration. These are the 3 aggregates most commonly used. Being able to sort by avg vs total would be ideal. Performance Reports in SSMS can do this, so that idea.

    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. Show Job name instead of ID in query related alerts

    This is a follow-up on: https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/1865305-show-job-name-not-job-id-value-for-job-related-ale

    The job ID was replaced by the job name in Job Failing, Job Duration, Job Cancelled alerts but I would like to see the same for query related alerts, specifically Long-Running query but the comments in the other item also mention Block Process and Deadlocks.

    12 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