We have intermittent client<>server sql session hanging. I noticed delta time gap of >19sec, seems like a lot. Anyway, not entirely surprising the application hangs for the client and effectively does not recover.
TCP has no notion of acceptable delta time. Once the TCP connection is established, packets are exchanged only when the endpoints have data to stream. This may be continuously or days apart. What you're looking for is not in the network.
Ok. thank you - I figured the applications determine what is their 'timeout' threshold. I was up till 3am last night - this stuff is phenomenally interesting !
The applications determine their TCP timeout threshold and it could be any number of seconds or minutes. As an example however, SQL may use 30secs so if no messages is received for 30secs the TCP session essentially times out.
Asked: May 7 '2
Seen: 330 times
Last updated: May 07 '22
