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. Analysis Graph Tab

    This is about the Statistics for the Disk avg. read and write metrics.

    There are times when based on the results for a server the statistics are presented in seconds. More often than not it will be 0.0, 0.2 sec, etc.
    This is not very helpful, and I often find myself having to download the Export (csv) and get the average.

    It would be much more beneficial to just show all results in milliseconds, or present an option to the end user of seeing ms or seconds.

    Thank you

    3 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      3 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Filter for VMWare virtual machine list under Manage VMWare hosts

      Add a filter in the vmware host to list only monitored servers. On and off checkbox would be enough.

      6 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • SQLMonitor consider the SQL Server cluster name as an instance

        SQLMonitor consider the SQL Server cluster name as an instance

        6 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          4 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • Remove a user/group from SQL Monitor

          It would be desirable to be able to remove a user and/or group from SQL Monitor.
          At present, there are no options to manage them, only add them.

          7 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • Tag alerts for reporting

            I would love to be able to create custom tags for alerts so I can later report on them. For example, we have process that run regularly that causes blocking sessions here and there. I would love to be able to add multiple tags to an alert that later I can run reports to see if those process have a regular pattern of interrupting business.

            3 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • Job duration taking too long - triggering WHILE job is still running

              CONTEXT: If a job is taking a long time (outside of some predefined threshold), we want to be alerted about it. That’s often an actionable alert – we could decide to stop the job, we could let the users know that report XY will be late as a consequence etc. One step further is being alerted on the job STEP level as well.

              PROBLEM: Current alert “Job duration unusual” is triggered AFTER the job completes, if it meets the alert's criteria. We need an alert to trigger WHILE the job (or job step) is still running, but the criteria is…

              41 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                1 comment  ·  Flag idea as inappropriate…  ·  Admin →
              • Be able to customize sql agent job failure notifications turn on/off at the specific sql agent job level

                Be able to customize sql agent job failure notifications turn on/off at the specific sql agent job level.

                6 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • Email Reports as an attachment

                  I know that it is possible to email report on a schedule basis.
                  But it only sends a clickable Link to the report.

                  Is it possible to send a PDF as an attachment on a schedule basis?

                  14 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • Access rights on database level

                    CONTEXT: We want to give our developers access rights to there databases alerts (long running queries, blocking processes, deadlocks ...).

                    PROBLEM: Access rights are only allowed on sql server instance level. Database1 should only see dev team1, database2 should only see dev team2. This is not possible at the moment.

                    7 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • see the sql_handle under query details under top 10 queries

                      to find an execution plan in the plan cache when the plan is recreated

                      13 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • save list of top 10 queries to excel

                        I would like to be able to save the list of top 10 queries to excel to deliver to developers in different sort orders

                        5 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • Add Clear, Unclear, Read, Unread buttons to the end alerts list.

                          Add Clear, Unclear, Read, Unread buttons to the end alerts list.
                          I like to have 100 alerts per page and its very unpleasant to clear several alert that are on the end of the page.

                          6 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • Filter alerts by Comment

                            Add back in the filter options, the filter on Have/Doesn't have Comment.
                            Add the possibility to search by comment.

                            Wold be great if there was some sort of "Tags" that you can apply to an alert and to filter based on those tags.

                            8 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • Comments in alerts list

                              Show the comments or at least the first 50 symbols of a comments in the Alerts list.

                              7 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • Shift Click to select multiple alerts

                                Add the possibility to select multiple alerts by using Shift + Click.
                                This was possible in the versions before alert grouping.

                                9 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                • I would like to give aliases to queries for easy recognition

                                  I would like to be able to give an alias for a query text and have that alias show up on the top 10 list.

                                  This to enable easy recognition of "known offenders". We have a lot of queries that are almost identical and drilling into each of them to check the where clauses to determine the actual query is getting tiresome.

                                  1 vote
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Group expensive queries by query hash

                                    I would like to have a section where the query execution counters are aggregated per query_hash.

                                    We use Dynamics Ax ERP and in order to avoid parameterisation issues we enabled passing company literals instead of parametres. This now leads to a single expensive query "taking up" as many of the top 10 query slots as there are companies executing this query.

                                    Ideally it would be possible to show the top 10 query hash data on the top level and then drill into each sql handle and view the query statistics and history there.

                                    4 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Report Email Attachment Name

                                      Name the pdf attachment something other than "AttachedReport".
                                      The report has a title and a date which could be used to name the attachment. That would really simplify the process of saving the reports for baseline purposes.
                                      e.g. "Server2_ProcessUtilization_20180308.pdf"

                                      3 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Monitor for unavailable disks

                                        I'd like to see SQL monitor check for disks that were previously available but are no longer. Example: I have a machine were a disk is online, something goes wrong and the disk goes offline. I would like SQL monitor to alert me to this. If the disk contains database files I would get a database unavailable alert, however if it is a drive that holds backups there would be no notification until the backups start failing.

                                        This would have to be setup differently for clusters where a disk may exist on any node in the cluster due to failovers.

                                        7 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • scroll through the overview graph and zoom in/out

                                          It would be a lot easier if we could scroll through the overview graph and zoom in/out. For instance, on Monday morning I need to inspect a long (2 to 3 day) ETL job with 4 main parts. Currently I have to select the last timestamp I like to see in the graph and then select "Last 2 days". Then I can drag the sliders to highlight the area I want to investigate.

                                          It would be easier to click the graph and drag it left/right and use the mouse wheel to zoom in/out

                                          1 vote
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          • Don't see your idea?

                                          Suggestions

                                          Feedback and Knowledge Base