Ask Your Question

Acceptable delta times for tcp communications ..?

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

ajaznawaz gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

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

Jaap gravatar image

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 more


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 gravatar imageajaznawaz ( 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 gravatar imageajaznawaz ( 2022-05-07 13:57:29 +0000 )edit

Your Answer

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

Add Answer

Question Tools

1 follower


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

Seen: 48 times

Last updated: May 07