I've had a quick search and haven't found an answer so apols. if there's one out there...
I have a query regarding the Long Running Query alert, in particular the 'Was running for:' value.
I have left the 'Query running for longer than' at the default 10s so I would expect the alert to to be raised shortly after the 10s threshold has been reached for any given query.
Instead, for all instances of this alert on the server I'm monitoring ithe 'Was running for' is always circa 45s
Why isn't the alert triggered at, say, 11 seconds? I've increased the 'Query running for longer than' to 30s and, as I would expect, am seeing the same results.
Is the alert only triggered once the query has finished executing or is there something else that determines it?
Thanks in advance