Suggestions

I suggest you ...

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 vote and comment on it.

If it doesn't exist, you can post your idea so others can vote on it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. deadlock xml output

    Export deadlock xml from output tab to view in external tool.

    The view presented under the output tab is difficult to read and its an xml representation.

    Alternatively just show the xml instead of the formatted text.

    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…)
      3 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • alert inbox viewmode with additional info per row. Most importantly database and user

      Add a new view setting for the alert inbox where the user can choose to add event fields that would be present for such an event in the profiler.

      Or alternatively.

      Add a view mode that shows, database, user and application for each event.

      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 →
      • Add user and application to the details tab on a deadlock alert, also to the email

        Add user and application to the details tab on a deadlock alert.
        And to the email notification.

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

          Ability to add additional comments to the servers, instances and databases. This could be then used to create an at a glance reference for the usage of each server or database.

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

            To analyse a trend over a period of say 30 days using one continuous line graph is difficult. If we could see a line for day 1, overlapped with day2, day 3 etc over the same 24 hour period then its easier to see trends and patterns e.g. processing time increases at 1pm everyday

            Regards

            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 →
            • Add simple but useful detail to alert listing in order to aid in triage

              Some of the detail that is available when viewing an individual alert (i.e., clicking on the alert from the listing in the alert "inbox") can be compactly included in the listing so that it is unnecessary to click through to quickly triage the alert inbox. On my 1080P monitor, there is a large amount of wasted whitespace in that listing.

              For example, for these alert types, here are the corresponding tiny bits of useful information that would be wonderful to see in the listing:

              "Job duration unusual" -> "Deviation from baseline" (%)
              "Blocked Process" -> "Blocking duration"
              "Job failed" ->…

              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…)
                1 comment  ·  Flag idea as inappropriate…  ·  Admin →
              • Capture cursor SQL for long running queries

                It would be great if SQL Monitor would capture the SQL statement being executed for long-running cursors. Currently it shows "FETCH CURSORNAME001"

                Cursor SQL can be found with this query when the cursor is still open:
                SELECT c.session_id,
                c.cursor_id,
                c.properties,
                c.creation_time,
                c.is_open,
                c.fetch_status,
                c.dormant_duration,
                s.login_time,
                t.text
                FROM sys.dm_exec_cursors (0) c
                JOIN sys.dm_exec_sessions s
                ON c.session_id = s.session_id
                CROSS APPLY sys.dm_exec_sql_text(c.sql_handle) t

                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 →
                • Ability to change the width of list of metrics at analysis page

                  The small width of list of metrics makes difficult to read list of metric if it has metrics with names over 20 chars. See attached screenshot.

                  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…)
                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • Option to filter(replace) sensitive SQL from alerts displayed/recorded

                    Similar regex functionality to how processes/queries can be excluded from an alert but to hide or better yet not record sensitive SQL/SQL fragments

                    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…)
                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • Choose aggregation used in the analysis graphs

                      (Posting for a user)

                      Would it be possible to request a change to the graphing data algorithm to allow for the user to select (when adding a metric to the analysis graph) whether to use AVG (mean) aggregated or MAX aggregation. Although you could allow for any of the aggregation operators to be used, see screen mock up below from the SQL Monitor Analysis tab where you add the metrics to the graph.

                      I think it would significantly enhance the analysis of peak (local or global maximums) and it would prevent peak values being artificially dragged down to a local…

                      14 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 →
                      • need collected values for metrics, not calculated values

                        I would like to extract the collected values over a bigger time period and not the calculated values like you get when you expand your timeframe while looking at the analysis metrics. I tried to do this for batch req/sec for 24hrs and export it to an excel file but, again, I get the calculated values and not the collected ones like that I need.
                        Here's a topic I found that reflects what I want

                        http://documentation.red-gate.com/pages/viewpage.action?pageId=20742985

                        Thanks!

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

                          I'd like a KPIs area. For example:

                          Number of Occurrences above 60% CPU: 193
                          Average Duration of an Occurrence over 60% CPU: 68 Seconds
                          Number of Occurrences above 60% CPU which lasted longer than 3 minutes: 10
                          Total time spent above 60% CPU: 221 Minutes
                          Longest occurrence above 60% CPU: 30 Minutes

                          Same for page splits, PLE, et cetera

                          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 →
                          • Allow access to all network and disk drives for Active/Passive or Active/Active Clusters all the time not just when active.

                            It's difficult to see what went wrong on a cluster when you only see connection or disk drive info for the currently active node in a SQL Cluster. When a failover happens, we lose ability to see the passive node (or on an active/active cluster whatever node is deemed to be passive) and any data for network or SAN Disks is not viewable. This data would be helpful in determining what was going on just prior to the failover.

                            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 →
                            • Add day name(sat, sun, mo etc) of date to analysis screen

                              Add the day name of date to analysis screen.

                              Currently only the date and time is displayed on the graph lines dots.

                              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 →
                              • Analysis, save selection of the servers and counters

                                Ability to save selection of the servers and counters.

                                I.e. for server SQL1, SQL2, SQL2, counters PLE and batches/second.

                                I.e. for server SQL1, SQL2, SQL2, IO, read latency, write latency.

                                Currently the selection of servers and counters/metrics has to be repeated every 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 →
                                • Sort filter for manage server screen.

                                  We have many development and test servers we want in our server list but not fully monitored. They were added to Monitoring after the production boxes, so they are on top of the list.

                                  9 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 →
                                  • Multiple custom Alerts for a single custom Metric

                                    We have a scenario where we would like to create 2 different alerts for the same metric. The scenario is we have created a metric to capture the backup size growth percentage from the day prior. We have need for 2 different alerts. 1) Alert when the percentage is over X percent in a single day 2) Alert when the percentage is over Y percent for n days. The way we have to do this now is create the same metric twice and obviously that causes excessive hits to the databases.

                                    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 →
                                    • Per Server Authentication

                                      While useful to split apart the administrative and user accounts, there doesn't seem to be a provision to allow a single server (or group of servers) to be checked from a specific account. It would be useful to have 'subordinate read only' accounts that could only read a subset of the full array of servers, so departmental administrators could see their own system, without being able to see another department's system behaviour.

                                      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 →
                                      • Dynamic alert thresholds

                                        I'm already modifying the threshold settings, however, because of different workloads at different times, it would nice to have control over the time of day that a threshold applies.

                                        For instance during the day serverA might be doing transaction log backups in 30 seconds, and at night when we run heavy ETL workloads serverA might take 5 minutes for the logs to finish.

                                        This control of the threshold values according to the time of day would avoid unnecessary alerts.

                                        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…)
                                          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                        • On the analysis page, the colors of the labels are so pale they are difficult to read using IE 11. I need a way to choose a different color.

                                          On the analysis page, the colors of the labels are so pale they are difficult to read using IE 11. I need a way to choose a different color with more contrast.

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

                                          Suggestions

                                          Feedback and Knowledge Base