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. 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.

          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 →
          • 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 →
            • be able to show basic SSIS monitoring graphs/sparklines on the overview page (Buffers spooled, Buffers in memory, rows read,...).

              There is currently no SSIS monitoring in SQL Monitor. You can add custom metrics for performance counters available through SSISDB but these can only be seen on the Analysis page and only after you have selected all of them.

              It would be nice to be able to select SSIS as an option for a server and then see these counters as graphs/sparklines on the overview page.

              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 →
              • Just like you can configure multiple alert thresholds for: JOB DURATION UNUSUAL ALERT you should be able to do so for: JOB FAILING ALERT

                This would allow notifications for failed jobs to be sent to different functional recipient(s) (e.g. Dev vs. Support vs. Ops teams) based on key words and other criteria.

                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 →
                • Notifications to Slack Only

                  Would be nice to have the option to send some alerts to slack only, at the moment the only option is to send to slack and email, or don't send to either.

                  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 →
                  • In reports display results of a query from our own data (multiple columns)

                    We have a table in our administration database that contains usefull information for our management. This consists of multiple columns. It would be very helpfull to run a query in a tile in a report where the results of that query can be displayed. A bit like the long running query results in the reports but then with our own data from the administration database.

                    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 →
                    • Save the deadlock graph as pdf

                      I would like to be able to save the deadlock graph as pdf or maybe be able to send the page as an email

                      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 →
                      • Exclude tempdb/ReportServerTempDB from Alerts at a GLOBAL level, WITH EASE

                        It makes no sense for there to be Alert configuration settings for tempdb for Consistency Checks, Backups, and any other irrelevance.

                        If the ONLY reason for the existence of SSRS databases is because of Microsoft's idiotic requirement for SSRS to actually be configured in 2014 before permitting an in-place upgrade to 2016, there is no ACTUAL reason why one would care two hoots about the state of either SSRS DB on ANY instance affected by this "demand". OK, I have just 21 instances to drill down to SHUT UP ABOUT SSRS DATABASES!

                        Please provide a better way to manage SYSTEM…

                        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 →
                        • Monitor Log Shipping

                          SQL Monitor should be able to give me metrics on log shipping latency for native or SQL Backup Pro Backups

                          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…)
                            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                          • Total data file size/used metrics - add filegroup level

                            CONTEXT: We have some databases with multiple filegroups, I’d be useful to be able to drill down from the DB level to the FG level on the “Total data file size” and “Total data file used” metrics.

                            PROBLEM: Not being able to slice totals by FG is problematic, since different FGs often have different capacity / performance requirements, different space used speed/patterns etc.

                            EXAMPLE SOLUTION: For “Total data file size” and “Total data file used” add an additional selector window after the database selector: a list of filegroups + an (All) option at the top. So, the selectors would be:…

                            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 →
                            • Customise Email Settings For Each Alert Setting

                              It would be great if you could have an override on each alert to allow for a customised email setting just for that alert.
                              Currently an alert can have a different email address BUT it only uses the default settings, if I wanted to fine tune for that alert I can't.
                              Thanks, Steve

                              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…)
                                1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                              • Retain user last selection and update current default time options to be more flexible

                                On the Overviews of an instance Server/Host Metrics the default selections are always the last 24 hours as well as having all 4 boxes ( CPU, Memory, Disk I/o and Waits) select.

                                I am constantly having to uncheck the Memory box and most individuals look at the last 6 hours or would prefer ( 1 or 3 hours) and have to change from the default last 24 hours to last 6 hours each time navigating to this page. I would like to be able to have SQL Monitor remember my last setting(s) or at least be able to change the…

                                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 →
                                • Long Running Query Alert - Update Process Fragment Info for Agent Jobs with SSIS Packages

                                  One of the most common alerts that we get is the Long Running Query alert. However, when the query is due to a package executing from an agent job, there is little to no information about what is running long. The attached image is an excerpt from one of the alerts we got this morning. We can tell it is from an executing job, because of the SSISDB database specified. But beyond that, we are left trying to figure out which job/package was the culprit by digging through execution logs and schedules, then trying to match execution lengths with where…

                                  2 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 →
                                  • Setting Maintenance Window via API service

                                    That would be very nice if there as an API service which we would use to set maintenance window for a given sql host or a group of hosts.

                                    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 →
                                    • 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.

                                      19 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 →
                                      • open alert link in new tab or window

                                        When viewing an alert within the side-bar on the Overview page, clicking on the 'Go to the full details' arrow redirects the page to the intended alert. You have to then click back to see the overview page again.

                                        It would be great for the ability to be able to open click through links on a new tab or window instead of the same window to prevent navigating away from the overview 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 →
                                        • Share alerts via Email

                                          The ability to share alerts details via Email from the "Alert Details" page.

                                          Sometimes we don't want to share a direct link to the monitor.

                                          E.G
                                          Click "share" which will open a mailto: with the relevant alert details.

                                          2 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 →
                                          • Don't see your idea?

                                          Suggestions

                                          Feedback and Knowledge Base