Red Gate SQL Monitor - Evaluation
We are evaluating redgate sql monitor, configured few alerts and set threshold for every alert. It seems that the threshold is not validated. For example, we have set the threshold for Long Running query as 30 Seconds ("when a query runs longer than" option). But the email alerts reports the queries which does not meet the threshold. We are receiving alerts which indicates the query duration as 0 Seconds, 5 seconds, 13 seconds etc., Are we missing some settings? Please clarify.
Also SQL Process fragment just shows only "SELECT" OR "INSERT" for some of the alerts, not showing the full query.