Erik Darling notes a problem with time-based filters on operations:
There are six waitfor commands that each pause for 1 second. In between them are queries that finish in milliseconds.
If I watch the event output, eventually, I’ll see this:
Okay, so the stored procedure took more than 5 seconds, but… no individual query took more than 5 seconds.
This happens a lot and I’m not sure there’s a good answer for it.