Acceptable delta times for tcp communications ..?

asked 2022-05-07 00:56:26 +0000

ajaznawaz
1 ●13 ●4

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.

answered 2022-05-07 07:22:39 +0000

Jaap

13730 ●684 ●115

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.

edit flag offensive delete link

Comments

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 !

ajaznawaz ( 2022-05-07 13:55:25 +0000 )edit

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.

ajaznawaz ( 2022-05-07 13:57:29 +0000 )edit

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Acceptable delta times for tcp communications ..?

1 Answer

Comments

Your Answer

Question Tools

Stats

Related questions

Acceptable delta times for tcp communications ..? edit

1 Answer

Comments

Your Answer

Question Tools

Stats

Related questions

Acceptable delta times for tcp communications ..?