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.

Improve this question
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
    – Alexis Mineros
    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
    – Alexis Mineros
    Feb 19, 2016 at 0:32

0

Reset to default

Your Answer

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

Browse other questions tagged or ask your own question.