1

I have a job that syncs rows in a table between a production server and four other servers.

The problem is the job runs perfect on three servers, taking less than 2 seconds. On the fourth server, it takes over 12 seconds which causes a delay. There are no apparent indexing or statistics issues.

I talked to our systems administrator, he says the outbound packets are fine, but the problem is when the information goes back to the production server. The packet comes in 4600 bits and the network the server is using only 1600 bits and it takes time to divide the packets. He is asking if there is a way to do something in SQL Server to manage that, we told him no.

Has anyone faced this problem before? The trouble server is new and more powerful than the other three.

3
  • You need to find out if configuration is same between all servers. Also set nocount on in your query. Is amount of data pulled is same ? Have you considered transactional replication as alternative?
    – Kin Shah
    Feb 19, 2016 at 0:20
  • Yes it's identical data for the 4 servers Feb 19, 2016 at 0:21
  • We allready using transactional replication and it won't be necessary coz we are using it for some databases Feb 19, 2016 at 0:32

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.