we are still relatively new to SQLMon so I'm wondering if I may be missing something about those reported query duration times.
when I have configured a low alert to be raised at 10 seconds query duration, SQLMon does create that alert and sends out the respective email with a query duration time in it. this reported time however has nothing to do with the actual query duration itself. is there a way to see the actual query duration in the alert?
as an example, I ran a query in SSMS which ran for 60+ seconds. the low alert time for LRQ is set to 10 seconds. SQLMon raises the alert as expected and reports:
Query duration: 14.98 sec
the medium alert was configured to be raised at 120 seconds, so as this threshold was not reached, no further alerts where raised.
so the question again is how can I see in SQLMon what the actual query time was?