all groups > sql server replication > october 2005 >
You're in the

sql server replication

group:

Pull Replication Idle Time


Pull Replication Idle Time Tulio
10/7/2005 2:23:03 AM
sql server replication:
Hello,

i set up an pull replication. The first client i setup replication over
LAN and the second client i setup replication over RAS.

Server:
Windows Server 2003
SQL Server 2000

Client PCs:
Windows XP

Pull Replication over MS Syncmanager on demand


Now my problem:

At the first client (setup by LAN) the replication works fine over LAN.

When the client goes outside the office and start the replication over
RAS: It tooks a long time (up to 60 min) to start the replication
process. Sometimes the replication not even starts.
In the syncmanager it looks like the replication hangs.

When the client comes back in the office. The replication works fine?

At the second client (replication setup by RAS) the replication works
fine over RAS.
When the client comes back into the office and start the replication
over LAN: It takes a long time (up to 60 min) to start the replication
process. Sometimes the replication not even starts.
In the syncmanager it looks like the replication hangs.

When the client replicate over RAS. The replication works fine?

The name resolution in my network works good! Is there an cache in the
SQL Server or somebody knows an solution?

Best regards
Tulio Mossoro
Re: Pull Replication Idle Time Hilary Cotter
10/8/2005 9:14:54 PM
looks like a bandwidth problem. Run profiler and see where it is getting
stuck. Also copy a 1 mg file across the RAS link and compare how long this
takes with when you copy it locally.

You can also get an idea of relative bandwidth via ras and compare it with
relative bandwidth via LAN by doing speed tests at
http://www.bandwidth.com/tools/speedTest

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

Re: Pull Replication Idle Time Tulio Mossorous
10/9/2005 2:08:32 AM

Hello Hilary,

thanks for your fast answer but this can not be an bandwith problem.

On a few clients it is slow over RAS, on other clients it is slow over
LAN, on other clients it work perfect.

When i set up the replication via RAS then it is slow over LAN. Over RAS
it works perfect.

When i set up replication over LAN it is slow over RAS. Over LAN it
works perfect.

And the best at the end: The first two or three times it works perfect
in any direction. After this the replication gets slow up to not
working.

Is there any SQL Cache that holds the IP?


Thanks a lot in advance
Tulio Mossorous

AddThis Social Bookmark Button