Comments
Sort by recent activity
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 ...
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...