Activity overview
Latest activity by jschoen
Hi Ben,
thanks for the quick reply ! It seems that the detemination of this alert has changed in the new SQL Monitor 2, because when I use it now on our environment I get no 'false' alerts anymore [image]
Thank you again !
Jeroen / comments
Hi Ben,
thanks for the quick reply ! It seems that the detemination of this alert has changed in the new SQL Monitor 2, because when I use it now on our environment I get no 'false' alerts anymore ...
Long-running query calculation definition
Raised when:
Query has been running for longer than a specified duration.
I wonder, how is this time being calculated by SQL Monitor 2 ?
Is this done by: Login Time - Last Batch (Time) = Query Run ...
When I activated SQL Response to our server i got loads of long running query alerts. After experimenting I found out that during a single logon onto the sql server, I did a 30 sec query, and within a minute again a 37 query, I got an alert for 1.07 long running query.
So the monitor actually does a calculation between the 'Login time' and 'Last Batch' time. Which in our case isn't representive as the query running time, because the software often doesn't close it's connection with the database. This results in false alerts. Don't think these alerts are usefull for our environment ?
Thanks a lot!
Jeroen / comments
When I activated SQL Response to our server i got loads of long running query alerts. After experimenting I found out that during a single logon onto the sql server, I did a 30 sec query, and withi...