Eirikur Eiriksson (10/22/2016)
GilaMonster (10/22/2016)
Set the app's timeout to 40 seconds (how depends how the app connects to SQL). What you ask is exactly what an application timeout is.This approach could possibly leave the SPID dangling in an async_network_io wait.
Ref?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability