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. Supress alerts based on time of day

    We know that certain big batch jobs will be running that will take up extra resources at certain times of the day, what we would like to do is suppress these alerts so that we can keep our "tighter" thresholds during the day for when the system is open to the users.

    136 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…)
      10 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Allow emails to be sent based upon alert priority.

      i.e. only send an email for alerts with a Medium or High priority.

      131 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…)
        9 comments  ·  Flag idea as inappropriate…  ·  Admin →

        Hi all,

        We have looked into this recently, and have run into quite a few design and engineering challenges that you would not expect from such a seemingly straightforward feature. We are hoping to do this in the future, but I’m afraid I can’t really give you an ETA.

        Clearly this is a popular request, and we are very keen to get it right. Please bear with us as we figure this one out. Your votes and comments continue to be much appreciated!

      • add LDAP/NTLM authentication so that Windows domain users can log in as themselves

        That's it, really - configure read-only/read-write access via Active Directory group memberships or user lists built into SQL Monitor, and allow individual users to log in using their own AD credentials.

        124 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…)
          9 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • Ability to store a baseline

          After attending SQL in the city and listening to Grant Fritchey talk about the need to create baselines (and demo sql monitor) a feature I would like is the ability to create a baseline over 24 hours and have it stored. This could be then added to the analysis page as a Versus. ie last hour vs baseline, last day vs baseline.

          113 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…)
            9 comments  ·  Flag idea as inappropriate…  ·  Admin →

            (Closing)

            With SQL Monitor v.3.5 introducing a powerful baselining feature, we consider this suggestion as completed. If you feel that our new feature doesn’t quite solve the problem for you, please let us know.

            http://www.red-gate.com/products/dba/sql-monitor/baselining


            We are happy to announce that SQL Monitor v3.5 has been released.

            SQL Monitor now supports automatically creating a baseline against which you can compare previous metric activity. You can set the baseline to include metric data collected during single or multiple previous time ranges, and choose between two different views of the Analysis graph:
            • Lines view: each time range included in the baseline is represented by a separate line. This helps you to spot behavioural trends.
            • Regions view: shaded regions help you to quickly identify the areas where metric activity occurred most frequently, and shows whether your latest data pattern falls outside the normal limits for your server.

            We are looking forward…

          • Always mention the particular data object (stored procedure) causing the alert

            Right now we get a lot of "long running querys" without the alert screen or the email mentioning what data object is causing this. When checking details the data is there (in the form of a "create procedure"), so it can't be too hard to extract this information!

            This is important for two reasons:

            1 (Most important) You want to have customized alert options for certain data objects! For example, we don't want alerts when a backup, index rebuild or a long running SP is running. We need a longer timeout for these alerts.

            This can now be acciomplished with…

            111 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 →
            • Display DB growth rate, including DB File-layout

              DB sizing is any DBA's worst nightmare, mostly because very few of us were involved when the DB was designed. Thus, DB data- and log-file layouts, project growth and maximum sizing, all becomes very important properties and settings, which the DBA needs to be aware of. Also, tracking growth rate to plan for future planning regarding underlying disk space is as important to any DBA.

              This would be very useful to incorporate it into SQL Monitor, having the option to navigate to SQL Server Instance-level, from the Global Overview option and then display the underlying properties for each database in…

              100 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…)
                4 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • Enhance the "job failed" alert with info from failed job step(s)

                Right now we only see the info from the job itself, while the relevant stuff is usually in the steps.

                82 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…)
                  7 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • Virtualization-aware monitoring

                  Monitoring performance of virtualized SQL servers is a bit more tricky. I'd love to see monitoring capabilities of SQL Monitor to be "VM aware" (VMware, Hyper-V)... that is, to differentiate and link the database, virtual server, physical server, and storage layers.

                  79 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 →
                  • Disable deadlock alert emails at the database level

                    We have a couple of databases from 3rd party apps that regularly deadlock themselves, typically trying to update tables that are undergoing housekeeping operations. I can't fix it so I don't really want to keep hearing about it. But I'd like the deadlocks to be recorded so I can still investigate if I get reports of serious issues.

                    72 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…)
                      8 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • Few suggestions:

                      • Display the Job Name (character string) instead of hexadecimal value (SQLAgent - TSQL JobStep (Job 0x442BC6B49DA6FC41A98697F8C2F68956 : Step 1)
                      • In alerts configuration: Be able to exclude Long-Running query alerts (or any type of alert) for a specific time frame. For example: between 11:00PM and 5:00AM
                      • When selecting an alert details view, create a link to be able to come back to previous alerts summary screen instead of selecting Overviews link and then again narrowing down to alerts summary by server let’s say…

                      69 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 the scheduling of analysis reports and send via email

                        The analysis reports should be able to run on a schedule and send the via email. For instance it would be great if I could schedule the data/log size report to run every monday and send me the results via email. the ability to export these report to excel is already there, so just needs to be able to run on a schedule and send as an email attachment.

                        64 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…)
                          4 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • Increase user granularity and allow creating more than the 3 built in user accounts.

                          Increase user granularity and allow creating more than the 3 built in user accounts. For example, we have an offshore development team that would like access to their SQL instance, but can’t have access to any other instances. What I would like to do is to be able to create an account, assign permissions to that account against databases or instances, limiting the access they have to production systems. If we could get it to use AD integration rather than forms authentication as well as being able to set permissions granularly then that would be ideal.

                          60 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…)
                            4 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • Create a central web interface that can access multiple Base monitors

                            Given the sizes of some SQL environments we found that it is necessary to have multiple base monitor servers. However currently it is cumbersome to have to navigate to multiple URL's or switch the base monitor that's tied to a web server. Having a central console that is easily and always connected to multiple base monitors would alleviate this problem. Also this could allow you to monitor from various networks and domains.

                            60 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…)
                              6 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • When viewing alerts it would be great to have more detail about the alert as a tool-tip.

                              If I have more than one alert of the same type then it would be helpful to get more detail on the front screen.

                              55 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…)
                                5 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • Identify head blocker in a blocking chain

                                It would be quite useful and timesaving if one could identify the head blocker for a blocked process (as done in SSMS's Activity Monitor, Processes tab). Otherwise when get a lot of blocked process alerts, you have to manually figure out the head blocker by analysing all the alerts.

                                50 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…)
                                  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                • Suppress Repeating Alerts

                                  Over the weekend I had several jobs that run every 5 minutes fail each time they ran. On Monday morning I discovered I had an alert for each failure.

                                  It would be nice to have a single alert for each job that includes the number of failures instead of thousands of individual alerts.

                                  48 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…)
                                    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Licensing Clusters

                                    Since only one SQL server is active in an Active\Passive cluster, you should not require multiple Monitor licenses.

                                    45 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…)
                                      4 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Support for regular expressions

                                      Most of the alarms need more granular support for excluding/including different things. Using regular expression is a good idea and should be extended further. For example you defenitly need to be able to filter out things from the alarm on the sql server errorlog. Without it's useless.

                                      44 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…)
                                        2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Machine Unreachable Alerts - Repeated alerts would be useful

                                        On the “Machine Unreachable” alerts, is it possible to create an additional alert (e.g. after 10 minutes) to advise that a machine is still unreachable?
                                        This would be useful for overnight automated reboots when applying Windows updates, and the current unreachable alerts are extremely useful for that, but it would be re-assuring to know that we would continue to receive further alerts if a server had failed to come back up again (and if we also failed to see the absence of a “Machine Unreachable – Ended” alert)

                                        44 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 users to monitor servers in different domains and networks

                                          We have multiple servers in different domains. At present there is no trust between the domains and we have a seperate login for each domain. Each domain also has its own IP address range and there may be 2 or more firewalls between the servers. Is an optional agent based approach feasable where all the work happens locally & say XML is punted back & forth over a particular port?

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

                                          Suggestions

                                          Feedback and Knowledge Base