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. Detect Unsupported SQL Server Versions When Upgrading Versions

    I was running v4 with a MSSQL 2005 database and decided to upgrade to v6. The installer finished successfully, however when it took me to the Web App page, there was a warning that the database upgrade did not complete successfully. The reported error was "Cannot assign a default value to a local variable". I knew right away it was a problem with my old SQL Server version. I checked the forums and indeed, 2005 is no longer supported with version 6. I understand that, and have no problem with it. However, ya'll would have saved me the headache of…

    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 →
    • Be able to see in the overviews panel how much RAM my monitored instances are consuming just like I can see CPU and Disk IO for example.

      I want to monitor how much RAM my instances are consuming while I'm in the overviews panel and even though I can go to a specific panel for checking this specific counter it'd be useful to havr it in the single overviews panel and not moving back and forth.

      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 →
      • Have a standard metric for Data space used

        There is currently an out of the box metric or Log Space Used, but there isn't an equivalent Data Space Used.

        I get that it's a bit trickier if you have multiple data files, (even just adding them up as one metric). We have databases that we want to pro-actively allocate space for but it's hard to do without a metric to tell us when it's getting full.

        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 →
        • I wish the blocking Process report included the resource the Blocked processes are waiting on.

          My Dev write 500+ line procedures and functions so the SQL "Fragment" is seldom very helpful.
          It would be much more helpful to identify the resources the processes are blocked on. Even just the wait_resource and wait_type columns from sys.dm_exec_requests would help.

          I know some of the resource types are tough to parse in T-SQL.

          16 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 →
          • Filter Longest Running Queries Tile by Database

            The Longest Running Queries Tile on the Reports screen would be more useful if we could target only one database.

            15 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 →
            • Improved view of User Sessions

              Visibility into user sessions could be improved. The current list on the instance overview, "SQL User Processes (Top 10)", is a start but needs the following to make it useful:

              1) Don't limit the number of sessions shown; rather add paging controls like on the error log view, so that it would be possible to see any session for any selected time period
              2) Add a columns for:
              - Login (i.e. login name)
              - Blocked by session Id (maybe even an icon if a session is blocking/blocked?)
              3) Make it possible to sort by any column
              4) Add ability to…

              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 →
              • Feasibility of selecting databases across the sql instances to create custom metrics

                Imagine we are planning to create a new custom metric which we wish to use across several instances but one specific set of databases. its currently impossible and will be one to have.

                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 →
                • Have all cookies from the application marked as secure and HttpOnly

                  In a internal review of web-applications our riscmanament suggests that all webapplications cookies must be marked being secure and HttpOnly.

                  Could that be possible?

                  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 →
                  • global dashboard should handle multi-level groupings

                    Currently the global dashboard presents the SQL instance tiles according to their top-level group. So if I have 3 servers grouped such as:

                    > App1
                    >> Prod
                    >>> Svr1
                    >> Dev
                    >>> Svr2
                    > App2
                    >> Prod
                    >>> Svr3

                    it will present these under 2 groups: App1 and App2. This is fine if you're viewing all servers.

                    However when I filter the view to only show servers in the App1 group, I'd like the tiles to be grouped using the next level of grouping if there is one (in this case "Prod" and "Dev")

                    16 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 →
                    • Please make a mobile app for iphone / ipad like SQL Sentry do!

                      Please make a mobile app for iphone / ipad like SQL Sentry do!

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

                        16 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 →

                          We’re currently working on adding the ability to send notifications to different recipients per level of alert, along with other notification changes. We’d really appreciate some early feedback to make sure we’re on the right track.

                          If you’re willing to take a look at our designs and give a bit more detail on your specific requirements, please reply to sqlmonitorfeedback@red-gate.com with ‘Notifications’ as the subject and I’ll send further details.

                          Thanks
                          Adam, SQL Monitor Development Team

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

                            14 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 →
                            • 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
                                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
                                  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…

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

                                    31 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      3 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
                                        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.

                                        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…)
                                          1 comment  ·  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

                                          121 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            5 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          • Don't see your idea?

                                          Suggestions

                                          Feedback and Knowledge Base