Suggestions

NEWS: SQL Monitor v3.0 released! (22nd March 2012)
We are delighted to announce the release of SQL Monitor v3.0. This version includes custom metrics and alerts, user roles (including read-only access) and Denali (SQL 2012) support. To download or read more about SQL Monitor 3.0 visit http://www.red-gate.com/sqlmonitor.

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…)
Reset

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.

  • Hot ideas
  • Top ideas
  • New ideas
    1. Allow sending email in plain text format. This will allow integration with ticketing systems and directly sending to text devices.

      Allow sending email in plain text format. This will allow integration with ticketing systems and directly sending to text devices (such as cell phones).

      3 votes
      Vote 0 votes Vote Vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service

        You'll receive a confirmation email with a link to create a password (optional).

        Signed in as (Sign out)
        You have left! (?) (thinking…)
      • Allow drilldrown capability for different resource areas

        It would be nice to be able to see which sql statements or db users were generating the most CPU usage, RAM usage, and Disk IO. This would help us quickly identify bottlenecks on the system.

        CLR statistics would be nice to have too since we have found that it can account for locking issues in certain circumstances.

        4 votes
        Vote 0 votes Vote Vote
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service

          You'll receive a confirmation email with a link to create a password (optional).

          Signed in as (Sign out)
          You have left! (?) (thinking…)
        • 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)

          9 votes
          Vote 0 votes Vote Vote
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service

            You'll receive a confirmation email with a link to create a password (optional).

            Signed in as (Sign out)
            You have left! (?) (thinking…)
          • why It splits the server and port

            when I try to add the sql instance to monitor , I have to use port and when I do so it splits into two servers. also host and instance is bit confusing , why it goes as local for anyserver you addd to monitor

            1 vote
            Vote 0 votes Vote Vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service

              You'll receive a confirmation email with a link to create a password (optional).

              Signed in as (Sign out)
              You have left! (?) (thinking…)
            • Ignore Log Backup Overdue for database in recovery

              Databases that are the mirror half of databases using SQL mirroring will be in recovery ALL the time, and you can't back them up, so you have to ingore them.

              1 vote
              Vote 0 votes Vote Vote
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service

                You'll receive a confirmation email with a link to create a password (optional).

                Signed in as (Sign out)
                You have left! (?) (thinking…)
              • maintenance windows

                To track 'up-time' (probably using a custom metric) which can be used at 3, 6 and 12 month intervals to show the servers uptime accurately. But it would be useful to ensure that data from with the Maintenance Window is not included. Therefore it would be very useful to have the option to either suspend data collection for some or all custom metrics during the Maintenance Window, or even suspend all data collection during the window.

                3 votes
                Vote 0 votes Vote Vote
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service

                  You'll receive a confirmation email with a link to create a password (optional).

                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                • 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.

                  5 votes
                  Vote 0 votes Vote Vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service

                    You'll receive a confirmation email with a link to create a password (optional).

                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                  • When using "Back" browser function PLEASE put me back at the same place in the LONG list!

                    Although http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/2022999-add-previous-next-navigation-to-alert-details talks about previous/next, buried in it is the problem of wading through PAGES, AGAIN of stuff I've hunted through.

                    I'd like to add this separate request to deal with the simple issue of "put me back at the same place in the list as I was when I clicked an Alert to view".

                    I should not be forced to clear younger Alerts just so the Alert I'm on appears on page 1, either (not an elegant workaround).

                    Thanks.

                    4 votes
                    Vote 0 votes Vote Vote
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service

                      You'll receive a confirmation email with a link to create a password (optional).

                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                    • Install Base Monitor on a cluster

                      Using hosted servers, we have a SQL cluster that is our Production machine. The inability to install the Base Monitor on that cluster requires us to purchase an additional SQL Server and license it at in excess of $8K for the SQL Std license plus ongoing monthly charges.

                      This makes an inexpensive, quality product much more expensive...

                      We have Web Servers to handle IIS7 but the Base Monitor is the issue.

                      3 votes
                      Vote 0 votes Vote Vote
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service

                        You'll receive a confirmation email with a link to create a password (optional).

                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                      • Add % CPU Usage column for the "User SQL processes (top 10 by CPU usage)" section.

                        On the Overview page for the SQL Server instance there is a section: User SQL processes (top 10 by CPU usage) that show current SPIDs that are utilizing CPU resources. This section should show the actual % of CPU usage for that SPID.

                        1 vote
                        Vote 0 votes Vote Vote
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service

                          You'll receive a confirmation email with a link to create a password (optional).

                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                        • Base Set Of Normalized Views For Custom Reporting

                          Currently there is no proper DDF or similar tool in SQL Monitor 2.x or 3.x that users can employ to meet custom reporting needs. There are a handful of queries floating around as well as some SSRS Reports but in general there is no set of general purpose tools for custom reporting, not even a partially completed Data dictionary.

                          I have proposed (in a separate thread in the older SQL Monitor 2.3 forum) that Red-gate consider putting together a set of base views that like their table counterparts can be combined together to produce rich data sets for the purposes… more

                          2 votes
                          Vote 0 votes Vote Vote
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service

                            You'll receive a confirmation email with a link to create a password (optional).

                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                          • Have ability to sort list of machines on the Analysis page and anywhere databases/machines are listed on SQL Instance overview

                            Have ability to sort list of machines on the Analysis page and anywhere databases/machines are listed

                            2 votes
                            Vote 0 votes Vote Vote
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service

                              You'll receive a confirmation email with a link to create a password (optional).

                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                            • Extending Alert exclusion

                              It would be really useful to put an alert exclusion for Long running queries by Host and/or username.
                              At the moment only process name is available.

                              1 vote
                              Vote 0 votes Vote Vote
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service

                                You'll receive a confirmation email with a link to create a password (optional).

                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                              • specify a time in which jobs should be finished by

                                It would be helpful if for jobs you can specify a time in which they should be finished by and if they overun that time then an email alert is sent out to notify you.

                                1 vote
                                Vote 0 votes Vote Vote
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service

                                  You'll receive a confirmation email with a link to create a password (optional).

                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                • Have audible alerts on SQL Monitor

                                  It would be very helpful to have a configuration setting to make alerts audible (something like a beep or alarm ring). In the office we have a screen that displays the SQL Monitor where the alerts are only noticed when people look at the screen, which is not very often.

                                  An audible alert of 'red' alerts would prompt us to action them straight the way.

                                  3 votes
                                  Vote 0 votes Vote Vote
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service

                                    You'll receive a confirmation email with a link to create a password (optional).

                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                  • Add more information to alert email

                                    It would be nice to have more information sent into the alert email, instead of having to login into the monitor to check details. I am not sure if there is a way to do this already. If there isn't - this would be nice to have.

                                    For e.g: This doesn't divulge which query. If the query was mentioned, it would help.

                                    ID: 59

                                    SQL Server: (local)
                                    Machine: (Machine Name)
                                    Alert type: Long-running query
                                    Level: None
                                    Time raised: 8 Mar 2012 12:44 PM (UTC-05)
                                    Time ended: 8 Mar 2012 12:50 PM (UTC-05)
                                    View full alert detail

                                    8 votes
                                    Vote 0 votes Vote Vote
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service

                                      You'll receive a confirmation email with a link to create a password (optional).

                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                    • add hook to pushover.net for custom notification

                                      Pushover.net allows for real time notification on an android or iOS device. Can you look at adding this API into your application?

                                      3 votes
                                      Vote 0 votes Vote Vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service

                                        You'll receive a confirmation email with a link to create a password (optional).

                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                      • Navigation Inconsistent

                                        This is minor, but but it seems the links in the header on the alert detail page should link to the alerts page for that instance, not the overview.

                                        1 vote
                                        Vote 0 votes Vote Vote
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service

                                          You'll receive a confirmation email with a link to create a password (optional).

                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                        • Allow users to be given access to specifc servers only.

                                          Multiple users is good, but if users could be restricted as to which servers they can monitor. Currently, the users are able to see all servers, which on a muti-site solution can be overwhelming.

                                          1 vote
                                          Vote 0 votes Vote Vote
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service

                                            You'll receive a confirmation email with a link to create a password (optional).

                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                          • Add additional perfmon counters

                                            It would be useful to have configurable perfmon counters available in "Analysis" above and beyond the out-of-the-box counters.

                                            6 votes
                                            Vote 0 votes Vote Vote
                                            Vote
                                            Sign in
                                            Check!
                                            (thinking…)
                                            Reset
                                            or sign in with
                                            • facebook
                                            • google
                                              Password icon
                                              I agree to the terms of service

                                              You'll receive a confirmation email with a link to create a password (optional).

                                              Signed in as (Sign out)
                                              You have left! (?) (thinking…)
                                            ← Previous 1 3 4 5 6
                                          • Don’t see your idea?
                                          • Post a new idea…
                                          • Suggestions

                                            Knowledge Base and Helpdesk