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-period-has-expired/ 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


_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to