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.


  1. Attach Custom Documentation To Alerts

    I'd like to be able to customize things like an alert that job X has failed with a link to our own documentation on how to troubleshoot that job. It would be even better if these links could carry forwards into the slack notifications but even just having them on the alert page in SQL monitor for that particular alert would be immensely useful.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  2. Add link to disk details on Server details page.

    From the Estate - Disk Usage tab we can select the specific drive to get usage details for that disk.
    When you navigate to a server from the Overview there is a section that shows the Disk Usage at a high level, but no links to drill into the specific disk.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  3. Send alert notifications at the central/parent base monitor

    Context: We have a base monitor at our office connected to one or multiple base monitors at our clients environment.

    Problem: Not all client base monitors are connected to the internet or opening an extra network port is a hard thing to get done. This makes it harder to setup alert notifications from that base monitor.

    Desired solution: Send notification from the parent/central base monitor. This way we only have to set up notification on one central base monitor instead of multiple and use various notification types.

    12 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  ·  Flag idea as inappropriate…  ·  Admin →
  4. Central configuration of child base monitors from the parent/central base monitor

    Context: We have a base monitor at our office connected to one or multiple base monitors at our clients environment.

    Problem: To configure the base monitor at our clients location, we need to connect to that base monitor. In order for us to reach that base monitor we have a to connect through multiple VPN's and steppingstones, which makes a simple click a time consuming action for us.

    Desired solution: We want to be able to configure a child base monitor from our central base monitor at our office. For example adding a member tot a group or check on…

    18 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  ·  Flag idea as inappropriate…  ·  Admin →
  5. Add Active/Ended as SELECT drop-down options for Events

    The current Alerts page Select drop-down has None/All/Read/Unread

    For events, such as Disk Space, being able to Select "Ended" to get rid of the noise, helps focus on what needs to be addressed.

    If the list doesn't have any Event-type row, don't offer this pair of 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  ·  Flag idea as inappropriate…  ·  Admin →
  6. Add Active/Ended as SELECT drop-down options for Events

    The current Alerts page Select drop-down has None/All/Read/Unread

    For events, such as Disk Space, being able to Select "Ended" to get rid of the noise, helps focus on what needs to be addressed.

    If the list doesn't have any Event-type row, don't offer this pair of options.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  7. Improve filters available for alerts

    A recent incident I have been working on revealed to me that filters work based on last update which makes it hard to find alerts that you know would have started around a specific time. The ability to filter on start/end times as well as show this information in view returned.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  8. Avg. lock wait time alert

    Be able to have the Avg. lock wait time metric as a configurable alert.

    this metric is already available in the analysis tab, but we can't define alert on it.

    Avg. lock wait time
    The average wait time (in milliseconds) for each lock that could not be satisfied immediately and had to wait for resources.

    Equivalent PerfMon counter: SQLServer:Locks - Average Wait Time (ms)

    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  ·  Flag idea as inappropriate…  ·  Admin →
  9. Provide a report on queries with suggestions on improving performance

    When viewing the top 10 queries, we can see suggestions on what may improve the performance for the specific query. Can this functionality be summarized in one report per database to suggest and what indexes could assist with improving performance.

    I would like to see:
    SQL Query, Query statistics, Query plan, Suggestion(s)

    (similar to top 10 but more extensive.)

    Also provide searching capability to look for any suggestion that relates to a specific object.

    This will assist DBAs to specifically drill into a specific issue query and provide instant suggestions on what can be done to improve performance for that…

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Be able to see and dissect alerts for deadlocks on the AWS RDS platform.

    Currently, SQL Monitor does not raise deadlock alerts for AWS RDS database instances. I'd like this functionality to be added, as it's a major feature and selling point for the product.

    The current workaround we're using is a combination of AWS performance insights and a SQL script. A "single pane of glass" would be much more efficient.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  11. have more flexibility with user permissions.

    I'd like to be able to customize permissions. For instance, I would like an AD group to have the ability to set and remove alert suppressions (operational) but not have admin access to the monitor (administrative).

    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  ·  Flag idea as inappropriate…  ·  Admin →
  12. Monitoring of Windows Server Failover Cluster

    We would like to have the option to monitor Windows Server Failover Clusters as an integrated part of SQL Monitor. Considering that over 50% of our infrastructure is implemented as Always On High Availability Groups, operating on WSFC, we would like to have monitoring and alerts if something on WSFC level goes wrong such as a node disconnecting, a File Share Witness going down, errors reported in the WSFC console etc... At the moment, if something happens at WSFC, such as loosing quorum due to a file share witness going down, we are not being alerted and will not know…

    4 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  ·  Flag idea as inappropriate…  ·  Admin →
  13. Trigger a device check-in via powershell

    We use powershell scripts to shut down and start SQL services before and after maintenance. The scripts create a suppression window before and after as well. However, if the suppression window is removed too soon after the services are up, alerts are still fired because SQL Monitor thinks the server is still down. We workaround this by adding a delay in the scripts, but it's annoying to sit and wait for it. I'd like to be able to force SQL Monitor to check in with the server before removing the alert suppression window.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  14. If a job fails the alert should not be cleared until the job has run successfully again

    If a job fails the alert should not be cleared until the job has run successfully again. It doesn't make sense clearing the alert just because a job has been restarted. The alert should remain active until a completely successful run.

    4 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  ·  Flag idea as inappropriate…  ·  Admin →
  15. Control Alerts For Managed Instances Separately From On Prem.

    Some guidance for Azure SQL Managed Instances is different from on prem SQL Instances. For instance, there is information out there not to just do routine index maintenance and instead do statistics and only rebuild indexes when there is an obvious problem. Having a way to keep our current alerts for on prem and turn this off for Azure would be 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…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Tom,

    Thanks for your suggestion. Can you provide a bit more context for your suggestion? What goal are you trying to accomplish?

    Would the current ability to control alert settings by group not be sufficient for this?

    Thanks,

    Neil
    (SQL Monitor product designer)

  16. Provide a tile for an Availability group on the main page

    Should be able to see status of an availability group from the front page

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Monitor repliction

    Monitor replication (same as replication monitor)

    5 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  ·  Flag idea as inappropriate…  ·  Admin →
  18. Monitor SSRS

    Monitor Reporting services

    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  ·  Flag idea as inappropriate…  ·  Admin →
  19. Database name "like" filter for "Database Unavailable" alert

    In our environment we have several systems (3rd party ETL/reporting packages) that create and drop databases as part of their normal operation.

    Would be good if the "Database Unavailable" alert allowed configuring to ignore drops of database names either matching a "LIKE" filter or perhaps more advanced a regex filter.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  20. In the backup check would like it if we could select the times of the backup to then show that group

    in the Estate > backup page you are able to see issues such as RPO 1 week. it would be good to be able to click on this to then show the backups listed (fade the not appropriate backups).

    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  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 30 31
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base