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 metrics to have their own individual data purging value

    At the moment, we can only have a single value for data purging for all custom metrics.

    I would like to be able to set a custom data purging interval for selected custom metrics as I'd like to track them over a longer period of time.

    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 →
    • Missing database name in blocking session alert

      When I receive an alert about a blocking session, it does not tell me the database. The mail starts with e.g.

      Blocking Session ID: 93
      Number of blocked descendants: 1
      Total blocking duration for all descendants: 00:03:02
      Blocking SQL fragment: CREATE PROCEDURE [dbo]...

      In the subsequent blocks (blocked sessions) it shows the corresponding database name, but only after much of scrolling, when the block cames from a long procedure (some with > 1000 lines).

      So please add the database name to the blocking session part too.

      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 →
      • Long Running Query Duration for Specific Queries

        It would be really useful is this feature came into Live!

        We have a number of queries that run on our SQL servers. We are aware these normally run for a long period of time (5-10 minutes) and do not want to exclude these from being alerted to us. Rather than changing the Long Running Query threshold for all the queries within the server we would like to be able to do it for these specific queries that take that little bit longer than others.

        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 →
        • Track sql timeouts on execution

          Track sql timeouts on execution from applications that close the connection before execution is completed

          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 →
          • Monitor a failover cluster in Azure

            I have two failover clusters in Azure using ClusterSharedVolume storage, migrated from terrestrial clusters.
            I've been using SQL Monitor to monitor all aspects of these clusters but now I've migrated to Azure, the monitor can't connect (I believe it's to do with the inability to ping the cluster load balancer in Azure).
            I'm sure, as more and more of us migrate to cloud services, that covering an Azure cluster would be most welcome.

            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 →
            • Use (Group) Managed Service Account Credentials for Server Monitoring

              Allow the use of managed service accounts (MSA and gMSA) as credentials when monitoring servers.

              Given the high-level permissions required to fully monitor servers, this would provide a higher level of security to match.

              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 →
              • check if there are any service packs or updates for my SQL Server instances

                check if there are any service packs or updates for my SQL Server instances. This could then raise an alert to prompt me to investigate these updates.

                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…)
                  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                • Trigger Self Healing Script and Auto Close

                  It would be great if SQL Monitor could invoke a SQL script upon an alert threshold being crossed and then take action within itself (ie. clear itself, notify a team, etc) based on the value returned (0/1) or default to an action if there is an issue with the script execution.

                  This type of functionality would help administrators have a first line of defense before truly getting paged on an alert such as a drive filling (perhaps you have txt files you can purge or shrink logs (though I don't necessarily condone this, but you get the idea!)

                  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…)
                    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                  • Stop being nagged about maintenance windows - because they don't fit our operation

                    The nag about "you haven't set up any maintenance windows" is something you could allow us to turn off. Period.

                    SQL Monitor's simplistic feature does not tie in with the way Rackspace performs their patching, so the feature is useless and the nag is annoying as it keeps on coming up and we keep on dismissing it.

                    Please, give us a "Turn of maintenance window reminders globally" option - it can't be that hard to do...

                    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 →
                    • Show current data sizes on purging page

                      On the data purging page would it be possible to show for each of the data categories how much space each one is currently occupying.

                      Possibly even an 'oldest date' too? As this may be pertinent if the purge thresholds haven't yet been met.

                      On some environments I want to keep as much SQL Monitor data as possible and if it's a healthy server you may have very little alert data, and so want to keep more history than you do say, machine data.

                      It would also help in cases where the Repository database is growing, and you're not sure…

                      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 →
                      • be able to schedule monitoring suspend or maintenance on instance level

                        We have a cluster with two instances. The databases on these instances are restored on different times during the day.
                        I want to be able to schedule suspend of monitoring during these different time periods so that one instance is suspended and the other is not. Or put them in maintenance mode on the instance , not on host machine level.

                        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 →
                        • New alert type for blocking in parallel execution plans

                          We frequently get alerts for a "Blocking process" where 1 process is blocking itself because it is running in parallel and the threads are blocking each other. While this might represent a scenario that can be improved this is normal activity in queries that use a parallel execution plan. This alert is identifiable by "Number of blocked descendants: Unknown" and the lack of any blocked sessions.

                          I do not think this type of blocking should be ignored. But, there is no customize the behavior of this alert. If you exclude specific queries from the "Blocking process" alert you would not…

                          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 →
                          • Allow nested groups on the Overview screen

                            I have a structure of groups where the first level is environment (Production, Test, Development, etc) but then I have component as a second level (ETL, Application, Data QA, Sandbox). On the Overview screen, only the first level of the grouping is used, and therefore I have servers under 'Production' all bundled together and ordered by name across all the secondary groups. Would be good if the overview screen could show multiple groups somehow ... I understand there might be servers under the first level and the second level, and it might be weird for some customers ... but for…

                            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…)
                              1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                            • On the Overview screen, collapse AlwaysOn clusters into a single tile

                              I have quite a few AlwaysOn groups, with 3 servers as part of the group. SQL Monitor very cleverly takes the cluster name and adds all 3 servers to the monitoring list ... HOWEVER, on the Overview screen, they show as individual servers. It would be good if I could collapse that all down into one tile that shows an overall health of the group. I realize this is a different situation from an FCI because there can be multiple 'active' nodes, but it would be good if SQL Monitor understood that I added an AG listener server list and…

                              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 →
                              • be able to choose the actions during maintenance window.

                                During a monthly patch round along the servers, a restart or some downtime is mandatory. I want to be able to select the actions SQL Monitor will perform with the alerts triggered within that maintenance window. Most of the time I'm aware of the required Windows reboot, so I do not need an email telling me that the SQL Server was not reachable for a short period. So I would like to tell SQL Monitor not to trigger any alert during the maintenance window. (preferably a one-time maintenance window, see other suggestion)

                                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 →
                                • Configurable Thresholds Based on Time

                                  The alerts would be more useful if we could apply maintenance or quiet periods to them.

                                  I understand we have the maintenance window and that is perfect for things like planned downtime, index maintenance etc.

                                  Regards,
                                  Clive

                                  However, the issue I currently face is that I suppress the processor under utilised message. Like a prolonged spike in CPU activity, a massive drop off could be a concern too. However, I have a current mean of 18.6% on one example server. I can set a threshold of 15% as an example, but this would trigger alerts through the night when typically…

                                  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 →
                                  • Blocking process alert based on number of descendants

                                    While the alert for blocking process is great, it would be nice to be able to configure the trigger for number of descendants affected as well.

                                    If a blocking process runs for 30 seconds and affects 10 people but the alert is configured for a one minute duration of the block it would obviously not let you know

                                    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 →
                                    • In the Global Overview screen, have a filter selection for Still Active Alerts

                                      Once an Alert has been cleared or ended I no longer want to see it on my Global Overview screen. When I am handling lots of servers and I see lots of RED on the alert side but they have either been cleared (checked) or ended I no longer want them showing up on the global screen unless I want them too to review. This causes lots of questions from management when they walk by and see lots of RED and the Alert was handled or no longer a concern.

                                      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 →
                                      • Pagerduty API/WebHooks and Better Notification channel

                                        We are in a high secure payments network, we do not wish to open ports used for email (smtp) however we would like integration with Pagerduty.

                                        Please create a generic web hook interface where the payload can be fully customised or direct integration via there API.

                                        I would like the option to pick what communication channel is used based on the severity of the alert

                                        Alert Rule XXXXXX
                                        H M L
                                        Email
                                        Pagerduty X
                                        Slack X

                                        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…)
                                          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                        • In the email alert for custom notifications I would like to execute an ad-hoc query that shows me the results.

                                          This will allow me to write a custom metric alert and see the results of the alert inside the email alert. Example where I monitor one log file with various items the custom alert message can give me context on what errors are written to the log inside of the email

                                          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 →
                                          ← Previous 1 3 4 5 10 11
                                          • Don't see your idea?

                                          Suggestions

                                          Feedback and Knowledge Base