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. More options for Custom Metric Frequency

    Would it be possible to have a custom option for the Custom metric gathering, as it stands the data can be collected at intervals of 1,5,10,30,60,1440 minutes

    it would be nice to be able to select a custom value and values less than a minute, the standard metrics that are gathered appear to be gathered every 20 seconds which isn't an option here

    Thanks for your time and concideration
    Ste

    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 →
    • Allow the user to choose the aggregation level for the analysis graphs

      Firstly want to say that the aggregation works well for keeping most of the peaks / dips but there's been a few instance I've noticed where they get aggregated out,

      if you zoom in / out quickly the aggregation setting doesn't change straight away and you can see the full graph at a level or two above / below the zoom you're currently at.

      I'm requesting we get the option to control that to say yes I'm zoomed out but I would still like to see as much of the detail on this graph as possible.

      Thanks for your time…

      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 the ability to filter the alert inbox on object name

        In the Alert Inbox > Advanced filter:
        Add the possibility to filter on object name, ie search criteria.

        This will, for example, enable the ability to clear all alert for a specific object.

        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 →
        • multiple alerts for a single custom metric

          it would be nice to have multiple alerts for a single custom metrics.

          Examples:
          - Your application has its own job scheduler. You want to be informed if the duration of a specific job is greater than 1 hour. But you want to be informed too, if the duration was lesser than 1 minute (because then the job may have been failed).

          - Custom metric for specific database / server objects (as number of databases or of tables or certificates or logins or members in a specific role or ...). You want to be alerted if the number increases or…

          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…)
            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
          • Built-in-Alert for database dropped / created

            It would be nice to have a build in alert when someone (e.g. a vendor) created or dropped a database.

            Reasons:
            - you may want to delete old backup files (if dropped) or have to modify / delete some maintenances
            - you'll make a manual full backup of the new DB so that log-backups could be taken by your backup solution
            - maybe you have to add the new DB to monitoring (as DLM Dashboard), backups (and have to consinder its the disk space at the backup drive) or an Excel-Sheet with a list of your databases :-)

            Real-Live-Example:
            I…

            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 →
            • 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…)
                5 comments  ·  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.

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

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

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

                                          Suggestions

                                          Feedback and Knowledge Base