Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-20 : 08:19:44
|
| hengky writes "I want to ask about SQL 2000 Merge Replication process. I am using SQL 2000 SP2 on Windows 2000. I notice that when anonymous subscriber synchronize with the publisher using RAS, subscriber has to download all the changes first although I have already set DownloadGenerationPerBatch to 100 rows. So suppose there are 10000 rows to be downloaded, then subscriber first download all the 10000 changes then after it finish downloading data it begin to applied the changes per 100.My conclusion come when I notice the dial up connection activity.When the process run to "Downloading changes to subscriber", the process looks stop but from the dial up connection activity, there are large number of data received. There are about 4 MB downloaded for about 10000 rows. After the 4 MB downloaded, the process continue with processing the articles and applied changesper 100 rows.Is my conclusion true? Is there any setting in Merge Agent Profile can change this process?" |
|
|
|
|
|
Replication Process