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

    20 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 →
    • Monitor Azure SQL DWH

      It'd be great to be able to monitor performance of queries on Azure SQL DWH, as there are a number of DMV's available to track usage. Also, the ability to see on the Dashboard what DWU level the Azure DWH instance is running on would raise value and awareness of the cost of it, at that point.

      10 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 bloat plan cache No. 2

        I have ~15k variations of this query in my plan cache, each with varying handles and a varying number of INSERTs.

        DECLARE @plans TABLE (plan_handle varbinary(64) NOT NULL)
        INSERT INTO @plans VALUES(0x06000b008697d33ae0e92c011c00000001000000000000000000000000000000000000000000000000000000)
        INSERT INTO @plans VALUES(0x06000b000ddbda05a03c83f01d00000001000000000000000000000000000000000000000000000000000000)
        INSERT INTO @plans VALUES(0x06000b00263e3902f0b1112b1900000001000000000000000000000000000000000000000000000000000000)
        INSERT INTO @plans VALUES(0x05000b009ee99729a0b9945b1600000001000000000000000000000000000000000000000000000000000000)
        INSERT INTO @plans VALUES(0x06000b0059af9b291063a6951900000001000000000000000000000000000000000000000000000000000000)
        INSERT INTO @plans VALUES(0x06000b0094ca3316501fee2c1600000001000000000000000000000000000000000000000000000000000000)
        INSERT INTO @plans VALUES(0x05000b0065c5a32880b2945b1600000001000000000000000000000000000000000000000000000000000000)
        SELECT plan_handle ,
        query_plan_info.query_plan
        FROM @plans
        OUTER APPLY sys.dm_exec_query_plan(plan_handle) AS query_plan_info

        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…)
          2 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • Easily determine am/pm from the graphs.

          Currently it isn't clear by looking at a graph if the times are AM or PM. It would be helpful if hovering included AM/PM as well as the left and rightmost times shown on the bottom of the graph. It is confusing and takes effort to determine if I"m looking at morning or night.

          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 →
          • Keep from Locking Account When Registering Server with wrong password

            The process of registering a server should try only once with a credential failure, looks like it keeps on trying and if you have typed in a wrong AD password it will lock your account.

            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 →
            • Allow option to exclude Integrity Check Overdue Alert for read only databases

              An alert configuration option should allow
              a database status to be checked when querying for last good integrity checks and read_only databases could be excluded from the alert. Even when integrity checks are performed on read only databases, the last checked date is not updated resulting in unnecessary alerts in most cases.

              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 →
              • Desktop notifications

                Desktop notifications would have (at least) 2 advantages:

                1) It would give much quicker access to the critical alert information than a regular alert email, since you could layout/format the notification with perfect flexibility (as opposed to default email client notifications which devote most of the real estate to the "from" address, and subject and body in plain text)

                2) With a couple buttons, the notification could give immediate access to actions such as "clear" or "mark as read"

                12 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 →
                • Block Specific Deadlocks by Lock Details

                  We've just updated to SQL Monitor 6. We was hoping there was a feature in this to change alert settings for Deadlocks with specific lock details rather than just all Deadklocks.

                  For example
                  we don't want email alerts on: Deadlock 'object: ReportServerTempDB.dbo.SessionLock, lock mode: Exclusive (X), index: IDX_SessionLock

                  However we wish to receive emails when: Deadlock 'dbid: 6, object id: 72057594038845440, index id: (9bf78693a4b4)'

                  However this feature doesn't exist. Would be great to have added to an update in the near future!

                  45 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 →
                  • Select different purge data ranges depening of what group a server belongs to.

                    We have different data retention requirements depending on what server is being monitored, but currently only 1 purge setting is available which covers all servers. An example of what I'd like to see would be to select to purge data older than 14 days for production/critical servers and a much shorter retention of data for test/development servers. This would be controlled by what group a server was a member of.

                    25 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 →
                    • auto refresh

                      I'd like the Analysis Graph to auto jump to present every 1 mintue

                      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…)
                        2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Sorting for columns in Host Machine Metrics

                        The OverViews page provide lots of useful information about our SQL servers including being able to see all of the disks on the host machines. However the order of the disk names seems random. Can we have sorting enabled in this section so we can sort by space used or Disk

                        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 →
                        • Replace SERVER identifier with a hosts file friendly name

                          As the ALIAS feature isn't working consistently across all pages and, in particular, email alerts, the means to replace the name of a monitored server is needed.

                          E.g., if someone, not a DBA or person familiar with SQL Monitor, set up each server as an I.P. address, or an equally meaningless Rackspace device ID, it is unreasonable to assume that I.P. or RS device translation to named server, which in our case is a customer name+nature combo, is held in every recipient's brain, or that we should carry around a pocket-sized hosts file printout...

                          If a simple operation such as…

                          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 →
                          • Relative-day maintenance windows

                            Rackspace maintenance days revolve around, for example, "Default week - Wednesday - 02:00 to 04:00", where "default week" is established in the service contract. That can change to early-week or (I forget the name) "late-week".

                            Current SQL Monitor Maintenance Windows are wholly inadequate to record a "Default week is 2nd week of each month, maintenance on that week's Wednesday, at (the time period)".

                            Without this, my PagerDuty Alerts go berserk during maintenance windows, and shy of having someone go and suspend monitoring at 2 in the morning and remember to turn it back on, it just keeps on sending out…

                            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 →
                            • Raise Free Space alerts on disks that are mounted, rather than simply drive letters/volumes

                              In our clustered environments, instances are given a small drive for mounting the larger data/log/etc volumes within them.
                              Whilst we always get a "disk full" warning on the mountpoint drives (subsequently disabled), there appears to be no ability to monitor the volumes that are mounted within, where we do care about free space.
                              I do see that metrics for IO, latency etc are done on a per volume (not drive letter) basis, so would be great if we could have consistency.

                              12 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 "not started within X minutes" delay before SQL Agent status alert raised

                                In an unpredictable maintenance window environment, as in, SQL Monitor's abilities in the window setting arena are inadequate, there are a reasonable number of times when SQL Agent is restarted with good reason.

                                As alerts are tied to pagerduty, it's a one size fits all Alert at present, which isn't helpful.

                                If a "delay emitting Alert for X time periods" could be added to this Alert, the short-duration bounces will go un-alerted, which really helps on call personnel to avoid unnecessary awakenings for "it is of no matter" Alerts.

                                In my case, there are 24 recorded incidents of this Alert,…

                                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 →
                                • REDGATE Monitor 5.1.2.3497 e-mail alert body should give detail with deadlock victim spid and query

                                  REDGATE Monitor 5.1.2.3497 e-mail alert body should give detail with deadlock victim spid and query

                                  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 →
                                  • Overview screen show as a list

                                    Show the overview screen as a list of servers. If you have a large number of servers to be monitored, there is no way to see all of them at once (other than zooming out of the screen). It defeats the purpose of monitoring if you can't see everything.

                                    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 →
                                    • See disk percentage free/used to Machine overview page

                                      It would be useful to see disk percentage free/used on the machine overview page next to the used / allocated column. This would give us a quick idea of how full the machine's disk is percentage-wise without having to do the math elsewhere.

                                      11 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 →
                                      • File and Filegroup Monitoring

                                        Hello Team,

                                        I am looking for File and Filegroup Monitoring in SQL Monitor.

                                        So in the User Interface, i can see Each File group, The Number of Files in the Filegroup and Free and Used space by Each File in the Filegroup.

                                        Thanks and Regards,
                                        Mahesh Deshpande

                                        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 →
                                        • "CLEARED" alerts button should be renamed to "CLEAR".

                                          On the alerts screen, there is an option to select alerts. If you want to clear the alerts selected you hit the button labeled "CLEARED".
                                          Having the button marked "CLEARED" is confusing because it implies that the button is a filter rather than an action. It should be labeled "CLEAR" so you know you are performing an action.

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

                                          Suggestions

                                          Feedback and Knowledge Base