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. set the default email recipient per level

    I'd like to be able to override the default email recipient "per level", in the same way alerts can be configured.

    This would make it much easier to manage in a case where monitoring responsibilities are delegated for a specific server or group of servers.

    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 →
    • Execution Time on Alert Dashboard.

      In Alert Dashboard, Execution time helps to analyze long running query in priority,so it would help if execution time is displayed on Alert dashboard.

      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 →
      • Go to next alert once cleared

        If you're clearing a few a alerts and need to review each one, it would be great if clicking cleared then loads the next alert.

        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 →
        • Apply regex rules to existing alerts

          Filtering alerts with regex is great for new alerts but it would be better if we could confirm our new command work by running them on existing alerts. Either testing or just been able to the filter the events using custom regex expressions.

          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 →
          • 产品建议

            1)Overview界面显示的服务器信息指标可以增加定制功能,可以让用户自己选择主面板上显示神秘关键性能指标
            2)告警时的邮件发送增加不同的数据库可以发送给不同管理员邮箱。

            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…)
              1 comment  ·  Flag idea as inappropriate…  ·  Admin →
            • Add option(s) for manual purging of data (use case: removed instances, deleted databases)

              CONTEXT: When you remove a machine from monitoring in SQL Monitor / delete a database from an instance / rename a database... - data stays in the SQL Monitor database (e.g. machine/instance/database is still visible on the Analysis tab), at least until relevant monitoring data is purged.

              PROBLEM: If you have some purge settings set to "do not purge", that data never goes away. Sometimes that is OK (you want the history retained), sometimes it's not (bloats the SQL Monitor database, unneeded entries on the Analysis page...).

              EXAMPLE SOLUTIONS:
              Add options to manually (on demand) delete data for a chosen…

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

                6 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 →
                • we dont allow ping to cross vlans so i cannot add servers to monitor

                  we dont allow ping to cross vlans so i cannot add servers to monitor

                  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 →
                  • Expand lower section of overview window

                    I would like the ability to expand the sections in the lower portion of the overview window or break them out into separate windows. For example, when viewing the Top 10 Queries or Waits it is very difficult because there is not enough room. Also because the individual tabs scroll separately from the main window, scrolling is a pain. The top graph section shrinks, but it still takes up too much screen area. Being able to break out in individual sections or expand them to fill the screen would be very helpful.

                    See attached screenshot for an example.

                    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 queries from top 10 queries

                      I would like to be able to exclude specific queries from Top 10 Queries. We use SQLQueryNotificationService which means our top 10 queries based on duration are always showing these queries as they have a waitfor. I would like the ability to exclude items from the top 10 queries.

                      Typical query I would like to able to exclude:
                      WAITFOR(RECEIVE TOP (1) message_type_name, conversation_handle, cast(message_body AS XML) as message_body from [SqlQueryNotificationService-07e6439b-8276-45aa-963f-bed011b3ef2f]), TIMEOUT @p2

                      22 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 →
                      • remember

                        Remember time period in overview of an instance or change the default from 24 hours. I tend to look at the overview of an instance using the last 6 hours however every time I click down in the overview I have to change from last 24 hours to last 6 hours, this is very frustrating. I would like to be able to remember my last setting or at least be able to change the default for me as a user.

                        6 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 →
                        • Alerts in SERVER Time Zone, NOT Browser!

                          Back in June 2016, I added the following to the now-defunct "Previous version" SQL Monitor Forum. The responder said it was in the Q for the next sprint, no promises as to its inclusion. DISAPPOINTMENT/FRUSTRATION continues to be experienced 6 MONTHS later!

                          Alerts at SERVER time, NOT UTC! PLEASE!

                          For the love of all DBA's with servers in multiple time zones (yes, this happens), for goodness sake STOP emailing the time of the Alert based on the SQL Monitor's Regional Settings.

                          In 2016, this statement from the page at https://documentation.red-gate.com/display/SM5/Alerts, is nigh on unbelievable, "All alert times in SQL…

                          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 →
                          • Sortable System Processes Grid

                            On the Alert Details page, it would be nice if I could sort the grid under the "System Processes" tab. It currently shows processes sorted alphabetically by name. I would like to sort it by CPU or memory utilization to see top consumers. I currently have to copy the data to a spreadsheet to do that.

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

                              Hi,
                              I think it's very important to show Suspended status of a monitored host/instance should be shown in dashboard.
                              I had suspended monitoring on an instance and forgot to resume so I've missed monitoring for a while.
                              I suggest to show the state of monitoring (Active or Suspended) maybe graphically/iconic, in the dashboard and Server overview pages

                              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…)
                                1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                              • Historical graph of how one query/Stored procedure is performing now compared to 2 months back

                                Choose from top 50 of worst queries and check what is the difference now compared to the stats in the past in graphical view and create custom reports with graphical view

                                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 →
                                • View queries against specific database in real time

                                  View all running queries against a specific database with the details of the query and its duration.

                                  This will help in monitoring a specific query in any particular time

                                  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 →
                                  • improve speed when navigating through the GUI

                                    It takes quite sometime to navigate across the screens on V6.0 would be a welcome relief if we have performance improvement on the UI

                                    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 →
                                    • Resize the columns

                                      Be able to dynamically resize, refit columns so details could be seen.

                                      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 →
                                      • Specify a "details" query for custom metric

                                        When I define a custom metric it would be super-helpful to be able to see some details that gave rise to the metric value. For example, I have one for "count of failed SQL logins in the last 10 mins". But to find out which logins failed, I have to go run queries in SSMS.

                                        I'd like to be able to define a "details" query on the custom metric, the results of which are captured at time of collection, and are then available from the alert.

                                        15 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…)
                                          2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • I want to be able to document in SQL Monitor why an alert is set a certain way.

                                          On the alert configuration screen for any alert, at any level I would like to see a comment type box where I can enter in the box the reason the alert is set as it is.

                                          For example if I have disabled the backup overdue alert for a particular database I would like to be able to save that reason in this comment box. Or if I have changed the disk space usage for a particular drive on a server different than the default I want to be able to document the reason why.

                                          I want to see this box…

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

                                          Suggestions

                                          Feedback and Knowledge Base