We are on SQL Server 2017
App set to run PROC up to 5min. So if it exceed 5mins it is going to timed out.
The PROC got timedout, when I see the history of that query in sp_whoisactive which we store history in our log table): the reads, writes are 0. There are no waits and no blockings. The status in in RUNNABLE. CPU shows 0 in sp_whoisactive. Couldn't find the reason why it ran that much time.
Any inputs ?