First time here? Check out the FAQ!
THIS IS A TEST INSTANCE. Feel free to ask and answer questions, but take care to avoid triggering too many notifications.
Ask Your Question
0

Acceptable delta times for tcp communications ..?

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.

ajaznawaz's avatar
1
ajaznawaz
asked 2022-05-07 00:56:26 +0000
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

0

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.

Jaap's avatar
13.7k
Jaap
answered 2022-05-07 07:22:39 +0000
edit flag offensive 0 remove flag delete link
more

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's avatar ajaznawaz (2022-05-07 13:55:25 +0000) edit
more
  • delete

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's avatar ajaznawaz (2022-05-07 13:57:29 +0000) edit
more
  • delete
add a comment see more comments

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss.

Add Answer