Long-Rynning Query False alerts
The symptoms/behavior seem to be similar to those observed int this thread - https://forums.red-gate.com/viewtopic.php?t=11322#p43645:
Postby jschoen » Wed Nov 03, 2010 9:56 am
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!