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. Exclude queries with a SQL process name matching the following regular expressions

    Why not give a couple of Regex examples on the override laert settings page for the "Exclude queries with a SQL process name matching the following regular expressions:

    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 →
    • Clear & Next

      When viewing alerts it would be good if there was a [Clear & Next] button. At the moment you have to clear alert then click on older or newer.

      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 an analysis metric for Total bytes sent/received over the network interfaces

        There is an analysis metric that currently exists for Network Utilization, which I believe is calculated based on the total bytes sent/received over the network interfaces divided by the bandwidth of the network interface. It would be great to add the raw delta bytes/megabytes sent/received/total as a metric on the analysis and overview pages of Sql monitor.

        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 →
        • Summary alert page ordered by active alert type with drill down to detail

          In the previous red gate alert program it had a summary by each alert giving a quantity for the selected monitor period and one could then drill down to the detail for that specific alert in chronological order starting with the most recent - found this most useful - also gave a simple measure of occurrences over time which one could use to track the effectiveness of efficiency projects

          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 →
          • increase or decrease the fill factor

            Dear team.

            I see some explanation on the sql Monitor live Demo tool which seems incorrect:

            Check also: The fill factor percentage of the tables in your indexes. If enough space for index expansion is available on data pages, the potential for page splits is reduced. The default fill factor value setting is 0 (100%), which means that pages are filled to capacity. If you increase the fill factor, additional free space is left in the indexes after they are rebuilt or reorganized, helping to prevent excessive page splitting

            increase should be decrease: the higher the fill factor the less…

            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 →
            • Allow for aliasing of server names

              I have entered some servernames as IP's and some as names. I don't seem to be able to edit these without removing and re-adding them.

              It would be useful to be able to Alias servers so other users know what they are at a glance rather than having to dial in or ask.

              E.g. I could have a server with an IP of 100.100.100.100 but alias it as 'ReportServer1' so that it is clear what the server is for anyone else using the application to monitor.

              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 →
              • SQL Server agent job alert

                Say somehow the sql server monitor wasn't enabled and some job failed on one of the monitored servers that time; when the SQL Server monitor comes back online I would appreciate, it showing this error, in the same manner, the monitor tool shows the overdue alerts for Integrity check, backups etc

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

                  Create a client agent (we monitor from our domain, across VPNs to customer sites/datacenters - opening RPC/WMI/et al does not go down well, nor does fixing RPC to individual port ranges.

                  It can be done, but large customers / hosting providers pretty much make life a lot harder than it needs to be, distracting majorly from the main monitoring / support / diagnosis tasks - an agent with single or few port requirements would make life so much easier - assuming LAN-like line of site doesn't work well for us. Deploy agent with a service account addresses one of the…

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

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

                                          Suggestions

                                          Feedback and Knowledge Base