April 1, 2002 at 10:53 am
Hi;
I'm debugging a system I set up. Here's the layout;
All Databases are SQL 2000
There are 2 transaction servers seperated by a T1.
There's a dedicated replication server thats merging the 2 transaction servers. It is set as the distributor.
Every 10 minutes merge replication is applied to all 3 databases.
The whole process takes about 6 seconds to process 500 transactions.
The problem: Periodically I get time out errors on the clients connected to the transaction databases.
My question is - Does Merge Replication lock the tables on the publisher/subscriber during replication.
I've had issues with this client's network before, but I just need to eliminate or confirm this as a cause.
Thank You.
April 1, 2002 at 3:01 pm
Could be locking and not releasing in a timely fashion. I could not find details on this but I do know that it does lock the data it is pulling on both the publisher and subscriber. If you have not tried SP1 or SP2 you may wish to do so as they list several merge replication issues fixed and could have a related couterpart.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply