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

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

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

  1. Custom metric: alert when value changed

    I want to be alerted if someone creates or deletes a database. The metric itself is easy (select count(*) from sys.databases - executed for the master DB on all servers).

    But in the alert setting I can only define that it should trigger if the new result is abover or below a set value but not for value changed (compared eigther to the previous value or the "baseline").

    So I have to create two metrics / alerts for DB drop (below) and create (above) AND have to define / modify the number of databases as alert threshold for each server…

    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 →
    • make the Overview page show metrics for SQL Instance/s, not servers

      As it says... if I am using SQL monitor, it is because I want primarily to monitor SQL instances, not servers...
      It seems to me that the first page you go to should really be about monitoring SQL and the health of instances logged - or a priority instance, and not overall server stats. Server stats are relevant, but in my experience, not the first thing I look at if a SQL instance is struggling

      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 →
      • Profiler Export

        When running trace through redgate can you add the option to export the profile so when I click on a spid I can export the trace as you can copy the whole content.

        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 →
        • Latch Wait Time Explanation

          In SQL Monitor 4.0, the explanation refers to sys.dm_db_operational_stats which does not actually exist.

          Should this be sys.dm_db_index_operational_stats?

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

            SQL Monitor allows you to run several customisable reports but there is no way currently to have a customizable dashboard which will allow you to pick the metrics you want to see on one page. This would benefit most people and if you could develop it so that you can create multiple dash boards for us on different screens even better especially if like us you have wall screens for display stats.

            7 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 →
            • Integrations with corporate tools like HP Openview

              Hi,
              SQLMonitor is a great tool offering, among other things, a practical "alerting console". From the alerting console I would like to "forward" the alert to other alerting systems.
              Scenario is: 80% of alert go straight to local developers group or local dba group. The 20% of the alerts cannot go directly to local group, instead it must go to the 24x7 global monitoring system. Since the global group is 90% non Windows, we need to talk with that system.
              A possible way is to format the alert to fit the Windows Application Log: from there, an HP Openview agent…

              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 →
              • Use Mongo as backend for data

                Sounds weird to use a non sql server product, but it adds a lot of cost to sql monitor to have to license sql web or sql standard in addition. Do you really want to use the server you are monitoring to store the data about it being monitored. Basically the base agent could just install mongo ( works on windows ) and use it for no additional costs. Or maybe get MS to not be dumb and give a free copy of SQL Server given you are monitoring a paid one likely.

                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 →
                • Description of Full scans/sec

                  In Explanation it says
                  "a lot of index scans may indicate missing indexes"

                  I guess it should be "full scans" ?

                  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 →
                  • Allow Groups to be created on Instance name rather than server name

                    For multiple instance hosts, each instance can have a separate functional purpose. However groups do not allow instance level granularity. It would be useful to have distinct instances from the same host in separate groups.

                    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 →
                    • Check both full and differential backups for the overdue alert

                      As it is, the backup overdue alert will not check if a differential backup has been run.

                      Example: We have a database with simple recovery model that is set up to make a FULL backup every week, and a differential backup every day. If the alert level is set to "more than one day" then it will be triggered even though the diff backup has been run, indicating that it is not overdue.

                      We could set (and do that) the alert level to check only for "more than 7 days", but then we will not be notified if a diff…

                      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 →
                      • Alert triggers SELECT statement

                        When sending out the alert notification on email it would be nice to have some additional data from a SELECT attached to this notification.

                        In my concrete example I have an alert on a metric calculating the percentage of used space on the log files. If above 80 it raises an alert. To this alert I would like to SELECT the active transactions exactly when the alert is detected so it is possible to see if any long running transactions are filling up the log.

                        I think it could be useful in many cases to provide the email with extra…

                        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 →
                        • Give the ability to use keyboard up and down arrow to select alerts and spacebar to check them

                          I would like the ability to use the keyboard arrow keys and spacebar to select and check alerts.

                          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 →
                          • Postgres as SQL Monitor backend database

                            SQL Monitor only supports SQL Server as backend database to store SQL Monitor specific data. As a result we are using one standard edition license and SQL Server express edition doesn't cut it. A SQL license adds to the total cost of ownership of SQL Monitor. It will be awesome if Postgres can be used. If the code is written in a database agnostic way, it won't be hard to accommodate this request.

                            15 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 →
                            • Display tasks running on the chart during analysis

                              During the analysis, it would be very useful to know what activity was taking place during spikes. An easy one would be to visualize if any SQL agent jobs were running at the time or backup/restore operations etc.

                              8 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 →
                              • Search through (closed) alerts for a string.

                                It would be great if we could search closed alerts for a string. For example I want to see all the alerts that have included a particular view in the query text.

                                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…)
                                  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                • Alert for OFFLINE databases to be configurable.

                                  We have a number of databases that are restored overnight therefore go into an 'offline' state, this is normal I would like SQL Monitor to ignore it.

                                  Can you therefore please allow the database offline alert to be configurable so that certain databases are not reported, perhaps within a known time slot.

                                  I know we can set maintenance windows but this stops all alerting.

                                  15 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 Fractional Alert Thresholds.

                                    When you use the "Calculated rate of change" functionality on a custom metric, the results come back in fractional values and you should be able to alert on these values. In my case, I want to monitor number of orders for the last 10 minutes. There are always relatively few orders at night and many during the day, but if order flow drops off drastically in a short period of time, I want to know about it.

                                    Unfortunately, I can't just alert when the rate of change drops by 25% (-.25) because alerts can only happen on integer values. 100%…

                                    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 →
                                    • Add an index to Alert.Alert on AlertType to remove index scan

                                      Here's the index. It really helped speed up the system (monitoring 20 servers)

                                      USE [RedGateMonitor]
                                      GO
                                      CREATE NONCLUSTERED INDEX [AlertType]
                                      ON [alert].[Alert] ([AlertType])
                                      INCLUDE ([AlertId])
                                      GO

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

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

                                          Suggestions

                                          Feedback and Knowledge Base