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. logins and user level reports

    we normally needed logins and database user reports for security audits and to take care the roles and permission user and login as though it can be done by cutom metrics but would like to see that details after expanding the databases.

    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 →
    • to have capabilities for configuration settings

      want to have all configuration settings displayed and should have a initial findings on server report which can be tuned based on the reports we get.
      it should be available for licensed once you register the server on it. like autogrowth would be suitable, what memory should be set, server and database level properties should be included in reports which can be alarmed and has recommended values.

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

                                          Suggestions

                                          Feedback and Knowledge Base