1 Reply Latest reply on Mar 29, 2016 4:01 PM by mandevil

    Alert Levels?

    marmentrout

      Trying to add an alert for Total SQL Wait Time for a Single SQL.  My average, for the query in question, is 5ms.   Per the documentation, I can set an alert to fire at 10ms, but the Alert Levels wants whole numbers.  .05 or .1 does not work.  What am I missing?  Thanks in advance for any and all constructive feedback?

        • Re: Alert Levels?
          mandevil

          By default, that alert will look back at the last 10 minutes for the SQL in question. If the avg wait time per execution is greater than X seconds (as defined in thresholds), it will alert you.

          You can't go less than 10 minutes as we only grab stats every 10 minutes (so we won't know execution counts to any more granularity than 10 minute intervals).

           

          If the avg is 5ms for your query, I don't know of a way to make the alerting sensitive enough to trigger as the values for thresholds have to be integers.

          1 of 1 people found this helpful