Hi I'm doing a .net ExecuteNonQueryAsync in my code and I get a timeout from the database on the exception.
Is there a way to detect what caused the exception? Meaning what is blocking the call?
I can't just put a monitor as the call is possibly blocked from early backup update insert jobs that are running for 3-4 hours so it's a shot in the dark if I try to search manually.
Also SQL logs don't reveal anything and I can't stay 4hours early in the monitoring if the error will happen as it happens at random morning hours and not every day.

Thanks.