March 2, 2005 at 5:13 am
Hi,
I am dealing with merge replication for 20 databases (each of size 2 GB).
Average transactions per day is 3000.
(1). I want to know, is there any limitations in the
number of publication that can be set in a subscription(now we have 20 DBs in replication).
(2). The updates are merging in batches of 100 updates. Is there any way to
increase the batch size. And is there any implication due to this?
(3). There is a delay in merging of data in a particular database (DB1), on
that day totally(in 10 DBs) more than 4,00,000 updates were done. Two
times the error message 'There is no response since last 30
minutes' was shown. After completion of replication in other databases, DB1 starts
synchronizing. What is the reason for those errors?
Thanks,
Soura
March 3, 2005 at 9:26 am
I just returned from 'Beta' SQL 2K5 Admin Training. The instructor mentioned that Replication on SQL2K was designed for hundreds (low) of subscriptions and that SQL 2K5 was designed for thousands (neither low nor high). In SQL 2K these are processed 'serially', so the more you have the longer it might take. Whereas in SQL2K5 it is supposedly done in 'parallel'. Hiowever there were no demonstrations and such.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply