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. Dark Theme!

    Would love to be able to have a Dark theme for the UI.

    We use a number of other tools where this is an option and really appreciate the saving of the eyes from the sea of white/ other bright colours.

    48 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Simpler Upgrade \ Patch Process

    The upgrade process is a bit long winded. It would be great if the system could be upgraded or patch with a single click. Ideally within SQL Monitor but if not, downloading the file and just selecting upgrade would be great.

    48 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Rothig responded

    Thanks Phil – we are considering reworking the upgrade process. If this suggestions gains more traction, we’ll prioritise it higher

  3. Exclude specific alerts from SQL SERVER ERROR LOG ENTRY alerts

    We have certain tools (mainly infosec related) that generate a lot of entries in the SQL server error log as part of their normal operation creating a lot of alerts. The only way to identify these and thereby determine that they are 'expected' is to go into each alert individually and mark it as read. The ability to ignore certain errors based on error number, severity or message would add a lot of value to this feature.

    47 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Flag idea as inappropriate…  ·  Admin →
    Adam responded

    Thanks for this suggestion and the additional comments and votes.

    Version 9.0.13 released on 23rd May now allows you to exclude specific SQL Server Error Log Entry alerts by severity, error number and error message.

    We hope this meets requirements and will mark it as completed, but please add other suggestions for any further improvements you would like to see.

    Thanks,
    SQL Monitor Development Team

  4. Monitor Azure Managed Instances

    Redgate Monitor still does not appear to fully support Azure Managed Instances. As our primary business is about to move across solely to Azure Managed Instances, this is now a seriously high priority for us.

    We are heavy users of Redgate Monitor for our business, so this is now starting to be become a bit of a worry for us.

    46 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  5. Alerts related to SQL Jobs should show the job name not the job Id

    Process name: SQLAgent - TSQL JobStep (Job 0xECCD1234543A1FA439B02DE3CE12F139E : Step 1)

    45 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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.

    45 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  7. Run a custom SQL script when an alert is raised

    We use SQL monitor very heavily for our SQL and application monitoring, what we would like is for each alert to be able to define a custom sql script to run when the alert is raised, the output of this sql should be included in the alert.

    This would allow us to do things like capture whoisactive when blocking occurs or other application specific things and make responding to alerts MUCH easier.

    42 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. exclude all of my system databases from the log backup alert

    I would like to exclude all of my system databases from the log backup overdue alert as I only perform daily full backups on them. At the moment I have to go into the Config settings and change the alert to disabled for those DBs on each servers.

    42 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Rothig responded

    When we’ll be improving the alert configuration UI, we’ll keep that use case in mind

  9. Show a log of query activity

    CONTEXT: When investigating a performance issue, I want to know what has been running

    PROBLEM: SQL Monitor has rich query information on the overview screens, the performance diagnostics panels, and the query alerts, and the query trace in alert detail reports, but it's difficult to tie that information together

    EXAMPLE SOLUTIONS:
    - Implement a query log
    - Show query information on the analysis graph

    42 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  10. Add an option to schedule when custom metrics run against a given database.

    Currently when a custom metric is executed can only be controlled by the frequency (daily, hourly, etc).

    My primary purpose is for daily. I would like to schedule the time of day a daily metric is run per database, or at least server. The custom metrics I pull back are time sensitive so controlling when the metric is returned is a must.

    A more advanced option to this would be going beyond simply choosing the time of day for daily runs, but rather the ability to build a custom schedule of run times. An example might be Custom Metric A…

    42 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    11 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Configure Different Emails for alert levels

    Allow for customization of emails for alerts at each alert level, so that I can send to different emails for each alert level.

    So that I can send High alerts to one email address, medium alerts to another email address, etc…

    42 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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…

    41 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Monitor Windows 2012 R2 CSV Volumes (Cluster Share Volumes IO/space and other metrics)

    CSV Volumes have their own windows performance counters and can be used by resources owned by any of the Windows Cluster

    40 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Please make a mobile app for iphone / ipad like SQL Sentry do!

    Please make a mobile app for iphone / ipad like SQL Sentry do!

    40 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  15. Select and store a static baseline for future reference

    CONTEXT: When comparing server performance over longer periods of time or across deployments, the baseline functionality in SQL Monitor's analysis section is useful.

    PROBLEM: SQL Monitor creates a dynamic baseline based on previous data. While this baseline is a realistic idea of what's "normal" it requires us to keep a lot of data in SQL Monitor

    EXAMPLE SOLUTIONS:
    • Aggregate data in SQL Monitor so that it can be retained for longer without using much space
    • Allow us to "freeze" a baseline so that the data doesn't get deleted.

    What do you think about these solutions? Got another idea?…

    40 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Sort or Filter Monitored Servers

    In Configuration -> Monitored servers I would like to sort and filter the servers and have the grouping functionality applied to this screen. This would make it easier to find my server that I want to put a maintenance window on.

    38 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Alert when SQL Monitor is having a problem.

    We have the SQL Monitor database located on a different server from the Base and Web Service. We had an instance where the SQL Server hosting the SQL Monitor database went down. When that server went down it failed to send us an alerts and we didn't know that SQL Monitor was having no problems as it wasn't sending out any email alerts to notify us that it couldn't connect to it's database. A nice fix would be to have SQL Monitor send an alert to notify us that it can't do it's job.

    38 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Support SAML for Web Single Sign-On (SSO)

    SQL Monitor should be able to support Enterprise Single Sign-On using SAML. Is this on the roadmap?

    37 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. be able to customize email and Slack notifications

    Option to customize email and Slack notifications

    37 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Monitor SSAS databases

    I would like to be able to monitor SSAS cubes and data structures in the same fashion as SQL databases.

    35 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base