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. Display total memory for memory graphs on summary screens

    The memory graph on the summary screen does not always show the total memory on the screen. It shows what is being used, but I have no idea how much is free.

    I have attached a file showing one one of my servers that has 128GB of total memory. However, the graph only shows 75GB and it makes it look like most of the memory is consumed.

    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 →
    • Auto hide Menu and Filter bar

      When in TV/Overview mode (dashboard), It would be nice to get the full real estate on the TV/Monitor to show as many server tiles as posible, hence auto hiding the top menu and filter bar. with a dropdown button (show button) on the top right side of the server tile area. (shown in the image associated).

      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 →
      • Assign user to an event

        It would be helpful if we could assign a User to an event, just like comments, so when you login, you could switch to a view that holds assigned events that someone wants you to look at.

        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 →
        • SQL Server Agent : Check the status of Agent XPs Server Configuration Option

          Subject : SQL Server agent

          Context : At this time, SQL monitor only check the status of the windows service to monitor the SQL Server agent.
          but do not check Agent XPs Server Configuration Option.

          As a result, you could have a started agent, not able to launch any jobs and sql monitor will not raise an alert.

          Solution :

          - add a check of the column value_in_use in the sys.configurations table to ensure that Agent XPs is enabled when the agent service is started.

          SELECT * FROM sys.configurations WHERE name LIKE 'Agent XPs'

          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 →
          • Remove wait type VDI_CLIENT_OTHER from the wait graph

            SQL Monitor shows high waits for SQL Server 2016+ systems that implement availability groups configured for automatic seeding. Since a multiple system processes called VDI_CLIENT_WORKER are left running by design. This wait tends to be the top wait in an AG configuration and erroneously indicates a problem that does not really exist.

            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 →
            • Use error messages from SSIS catalogue

              When a job fails, which is run from SSIS Catalogue, then the error message is basically "look in SSIS Catalogue", which is not very useful. I suggest using the error message from the [SSISDB].[catalog].[event_messages] view instead for these cases.

              In our home made monitoring system we're checking the subsystem in sysjobsteps, then use the command from there to identify the dtsx package name and looking up the latest message from [SSISDB].[catalog].[event_messages] for that package for the error message.

              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 →
              • Baseline WaitStats

                SQL Monitor contains an aggregated baseline of wait stats, however there is no way to tell if the current wait stats are "normal" for my environment. For example, we had a problem where LCK_M_X went through the roof, and as a consequence HADR_SYNC_COMMIT plummeted because there was fewer insert/updates/deletes happening. The net difference suggested that there was no problem, but there was.

                I'd like to see something that shows what's "normal" for each wait type, and what the recorded value is.

                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 →
                • add user editable notes in estate

                  Add the ability to add some basic text notes for each instance that can be viewed in the estate view. Want to keep some basic notes such as purpose of instance, application server dependencies, etc. Currently use external document to keep track of these.

                  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 →
                  • use alternate IP addresses for named instances

                    I am modifying my named instances to use separate IP addresses. This allows me to use CNAMES for each databases, We are then able to move the databases around to another instance without the customers having to modify their connection strings.We are also able to use port 1433 for all existences. SQL monitor tries to connect to the instance using the servername\SQLINSTANCE, which no longer works remotely suite to each instance having it's own IP Address using and alternate A-RECORD name.

                    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 →
                    • Include Top N Worst Performing Stored Procedures and Functions

                      At my organization, we do a lot of tuning at the stored procedure and function level.

                      I would like a tab similar to the existing top 10 queries tab, that lists the CPU utilization, memory utilization and IO consumption of the top 10 worst performing stored procedures, and another tab that lists the top 10 worst performing functions. For each of the fields I would like to see both the totals, and the percent of total during the specified time period.

                      This will allow us to identify the stored procedures and functions to tune, and once tuned, it will allow…

                      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 →
                      • Unlicensed Databases

                        If a license is removed for a database, a banner at the top of the page shows up saying, "You have unlicensed servers. Unlicensed servers will not be monitored and will not raise alerts. Manage licenses | Manage monitored servers". And, on the "Configuration > Monitored servers" page the databases show with a red x, as Unlicensed, and a Manage licenses link.

                        It is good that licenses can be removed for individual databases, however it would be better to be able to remove the databases once they are unlicensed, so that we don't have to have the banner and the…

                        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 →
                        • Force re-check of index fragmentation alert

                          The index fragmentation alert is checked only once per week, because of the load is causes on the system. I am fine with that.
                          However, I would like to have the option to force an immediate re-check for a specific database - for instance by adding a "re-check" button to the alert window.

                          SCENARIO: The index fragmentation check runs on Saturday and triggers an alert on one database. On Monday I check the alert but I know that the weekly index defragmentation job runs on Sunday, so it is likely that the problem is already fixed. But I like to…

                          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…)
                            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                          • Click to open analysis from alert window

                            For some alerts, I like to see not only what happened before, but also what happened since. Some examples are disk space, or database file usage. The latter for example has a nice graph of the file usage up to the moment the alert triggered. But when I look at it the next day in the office, I also want to see what happened since - did the file continue to grow, has it been stable since, or was this a peak and is less space used now?
                            Currently that means going to the Analysis tab, selecting the correct server…

                            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…)
                              1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                            • Monitor SQL instances running in AWS RDS

                              Enable SQL Monitor to add AWS RDS instances as monitored servers

                              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 →
                              • Clone custom metrics for copying

                                When I have a very simular custom metric, I want create. I have to copy and paste . Can we have a clone custom metric feature?

                                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 →
                                • A column with end of extended support in Estate

                                  In addition to the column with end of mainstream support it would be nice to have a column with end of extended support in the Estate tab

                                  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 →
                                  • Allow users to specify the time period in minutes for the top 10 expensive queries

                                    I would like to specify that exact minutes on the slider for Top Queries. Currently you can only do a 15-minute change. But I would like to be able to do that down to a minute range. Sometimes we make a change and I don't want to wait 15 minutes to filter out the previous queries.

                                    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 →
                                    • Add a summary tile for deployments to a database

                                      I'd like to see a summary tile for deployments to a database by SQL Compare and SQL Change Automation.
                                      Also it would be good if alerts can be created for these events.

                                      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 →
                                      • Report from Primary server in HA Group, even after failover

                                        In a High Availability Group we have reports configured against the Primary server. When there is a failover, the reports should still be against Primary but are no longer, so need to be edited. Ideally, we should have reports that are always running against Primary, even when it switches to another server.

                                        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 →
                                        • Add 'Details' column to the Alert inbox between Object and Unread column

                                          Add 'Details' column to the Alert inbox between 'Object' and 'Unread' columns

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

                                          Suggestions

                                          Feedback and Knowledge Base