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.

In SQL Monitor, I want to...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Custom Duration for Purge data Setting

    Set either a customer/user defined field for purging datatypes (Machine/SQL/Alerts), or increase options in the 1-3 month range, for example 6 weeks, 10weeks, 14 weeks. Each site will have different drivers that affect how long their reasonable data retention should be. If they only need 6 weeks, and not two months, why pay for the storage space?

    1 vote
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • see a comments field on every configuration setting so I can enter the reason I have an alert set the way it is.

      I would like to see a comment field on every configuration setting page. This would be at the global level and for everything below the global level. I would like to use that comment field to document why I have decided to set something the way I did. For example, why do I have the disk space threshold different on server XYZ.

      2 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • When using Windows authentication I want the read-only account/group option.

        I like the windows authentication but it doesn't have the read-only option. I would like to be able to add users and AD groups where I can limit the servers, but also make the data read-only, just like the options when not using Windows Authentication.

        3 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • 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
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • Make dead lock alerts easier to read by displaying a deadlock graph

            Display the transactions involved in the dead lock in a graphical manner

            2 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • Use the Base Monitor Service account to query Active Directory when using AD Credentials

              We are using a Managed Service Account to run SQL Monitor so we don't have to manage passwords. However we still need to have a regular domain account to query AD because there is no option other than to specify a username and password.

              What would be great is to have an option to use the base monitor service account to query AD instead of having to specify a username and password.

              This would work in a similar way to what already exists when setting up credentials for the server you monitor, where you can choose to connect to the…

              3 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • Dashboard for product teams - Make it more DevOpsy

                It'd be great if more than just Operations and the DBA's got anything of use out of the dashboard. The development teams would benefit greatly from feedback on how certain aspects of their database / jobs are doing. e.g. Deadlocks, failed jobs and job performance. Development and product teams will have a greater benefit from visibility of this.

                Could an ability to create users beyond Admin, Standard and read only be created? e.g. custom read only users that could be assigned visibility of certain servers and certain alerts / metrics. But also have a dashboard layout that is less noisy…

                5 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • Trigger a Maintenance Window or Monitoring Suspension

                  We have a big application that creates a lot of Blocked Processes during its deployment action.
                  I would like a way to Trigger a Suspension of Monitoring or Maint Window. i.e API?? Or TSQL INSERT / UPDATE

                  3 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • 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
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • Embed analysis graphs in external website

                      For building a global monitoring dashboard, I would like the ability to set up an analysis graph and embed it as an image from a different webpage.
                      Some way to embed basic stats/alert counters and the like would also be handy.

                      2 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Exclude deadlock alerts for named databases

                        We have a vendor system that generates a lot of deadlocks naturally and there is nothing I can do to mitigate that. As such, the ability to set deadlock alerts settings per database would be much appreciated.

                        9 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • 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:

                          XXXX_Main
                          XXXX_Extra
                          XXXX_Management

                          YYYY_Main
                          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 (e.g. "%_Main" or "*_Main")…

                          4 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • Analysis parsing of dates and multiple baselines using a text input search

                            Allow the analysis and other date filters to provide the option to paste and try parsing the date based on matching common patterns (maybe even allowing user to define options in config file).

                            For example, the standard SQL datetime2(0) of yyyy-MM-dd HH:mm:ss pasted would convert to the date it parses.

                            Maybe even consider taking a page from the freaking great design Simple Bank has started applying which is a text based filter applying friendly syntax. I have found this incredibly useful.

                            They let you type in the search filter

                            "last 3 months"
                            "last week"
                            "date:1/1/2015-1/15/2015"
                            "date:1/1/15-1/15/15"

                            and it immediate updates…

                            3 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • Trace should be alert specific

                              The triggering of a trace should not be at any alert, but instead you should specify in the alert configuration that the high, medium, or low level alert would qualify for a quick trace. For instance, dbcc_integrity check alerts shouldn't trigger a trace, but a long running job at the high level could be set to run the trace.

                              This is a big deal, as some competing products build this in, allowing you to not impact server performance to trace except on the most important issues.

                              7 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • Use extended events instead of trace when trace initialized due to alert

                                I have seen a related idea https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/5717202-use-extended-events-for-deadlock-tracing-instead

                                However, I'm expanding this. If the SQL version is high enough the trace of current activity should be using extended events instead of a trace, this would reduce the total impact to the server performance while also expanding the available information.

                                4 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                • 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
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • comment markdown

                                    CONTEXT: I use comments on alerts raised by SQL Monitor to document root cause of the triggered condition and resolution action.

                                    PROBLEM: Comments only support plain-text. When creating/reviewing comments, it's often useful to add links for more detailed descriptions of the cause of the alerts, and links to ticketing systems for resolution steps. Simplified bulleting/numbering and bold/italicized text would also be helpful for breaking up monotonous text.

                                    EXAMPLE SOLUTIONS: Add Markdown (http://daringfireball.net/projects/markdown/) support to addition/review of comments. A couple implementations for examples of usage:

                                    - StackOverflow (http://stackoverflow.com/editing-help)
                                    - GitHub (https://help.github.com/articles/github-flavored-markdown/)

                                    4 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Monitor SQL Server 2014 failover clusters with Cluster Shared Volumes

                                      There is currently some trouble with monitoring a windows failover cluster with CSV - specifically, the error log is unreachable because base monitor apparently connects to the wrong network name to access files.

                                      3 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • 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.

                                        12 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Install SQL Monitor without needing to provision a (large) SQL Server database

                                          CONTEXT: One challenge with installing SQL Monitor is that we need to provide a connection to a SQL Server database.

                                          PROBLEM: This can be costly or complicated. It would be better if SQL Monitor had an alternative backend.

                                          EXAMPLE SOLUTIONS:
                                          • Offer a hosted data store
                                          • Automatically deploy a free backend alternative such as mongoDB or PostgreSQL
                                          • Reduce data collection so that SQL Express can be used for small deployments
                                          • Provide greater granularity over data retention policies

                                          What do you think about these solutions? Got another idea? Let us know in the comments!

                                          82 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            17 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 10 11
                                          • Don't see your idea?

                                          Suggestions

                                          Feedback and Knowledge Base