I would like to replicate a large database to a reporting server on the same
network. I have very good bandwidth between the two servers
The DB in questio is ~200GB and has a transaction rate of ~3000 per minute.
There are 10 tables that are > 10 GB's.
Does anyone have any advice for me? or a document to review?
Thanks in advance!
Mark,
there are no articles specific to large volume replication that I am aware
of. There is an article on performance tuning and optimization
(http://www.microsoft.com/technet/pro.../tranrepl.mspx)
that should be of some help in your situation. Pull subscribers and a
separate distributor would probably be the first step. Teckie issues like
Raid 0+1, #procs, RAM and high bandwidth are not specific to replication,
but in your case the setup will probably prove crucial. These are also
partially covered in the article.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment