My client
doesn't have anyone who manages their network for them either.
Anyway if it is a LAN I would expect the continous ping to come back under 10ms if not under 1ms at all times, without any timeouts.
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
On Wed, 2 May 2018, at 7:07 PM, Frank Cazabon wrote:
> I am having some problems when running code that synchronises data
> between 2 SQL Servers using SM Sync Framework. This code runs fine at
> about 50 other sites.
>
> I am getting time out errors reported:
>
> TCP Provider, error: 0 - The semaphore timeout period has expired
>
> Google has suggested this site
>
https://sqlserverscribbles.com/2013/02/15/tcp-provider-the-semaphore-timeout...
> as possible solutions but I wanted to make sure there is actually a
> problem before I try to fix it as I am not a network guy. My client
> doesn't have anyone who manages their network for them either.
>
> I found a suggestion to run this command:
>
> ping -t hostname > out.txt
>
> so I did that and left it running for about 4 and a half hours. In that
> period I got 38 Request timed out messages (out of 18,685 total
> messages, so 18,643 were successful, the majority in 3 or 4 ms but
> pretty regularly going up to 22 or 23ms).
>
> Is this normal, or do you think they have a problem?
>
> --
>
> Frank.
>
> Frank Cazabon
>
>
[excessive quoting removed by server]