and my database got around 8000 tables..and the performance is very slow..
May I know what is the best way to replicate the database?
Thanks for your valuable reply..have a nice day!
My Server:
Win 2000 Advanced Server, SQL Server 2000 SP3a(8.00.765),
4 x 2.5Ghz processor, Memory 5GB.
Regards,
Jeremy Soon, Junior Programmer
the subscriber's hardware is the limiting factor here.
Transactional replication offers the best performance. set up the
pollinginterval on the log reader agent and distribution agent to 1. Set
OutPutVerboseLevel and HistoryVerboseLevel to 0. Schedule your agents to run
continuously and if possible migrate to pull.
Break your publications down into groups that are updated together, ie
parents and their children. So if you have 10 parent tables, and each parent
table has 2 children, break it down into 10 pubs, each pub containing the
respective parent and its children. This way you will get parallel streams
going to your subscriber instead of a single stream.
Then use the independent agent setting and set it to true.
Study your transaction patterns on your publisher. If you have batch
operations you might want to execute these with a proc and replicate the
execution of the proc.
"Jeremy Soon" <jeremy_soon79@.yahoo.com> wrote in message
news:B6FDED57-BC44-40F4-A5C2-006A70265E61@.microsoft.com...
> I'm doing database replication between 2 servers (IBM 250 & IBM 365)
> and my database got around 8000 tables..and the performance is very slow..
> May I know what is the best way to replicate the database?
> Thanks for your valuable reply..have a nice day!
> My Server:
> Win 2000 Advanced Server, SQL Server 2000 SP3a(8.00.765),
> 4 x 2.5Ghz processor, Memory 5GB.
> Regards,
> Jeremy Soon, Junior Programmer
No comments:
Post a Comment