January 2, 2008 at 1:54 am
i have configured a transaction replication between sql 2k5 databases which are located in two different cities. this replication is very slow to synchronize.. and when i check the network usage, not even half of the bandwidht is being utilized.
i want to know how can i setup replication to use maximum bandwith..
secondly, sometimes i see number of undistributed commands upto 800000
is the normal to have upto this number of undistributed commands in transaction replication.
i am using default agent profile with value of 100 for CommitBatchSize
January 25, 2008 at 1:59 am
snapshot & distribution agent accept a parameter which define how many threads would be used for syncronisation, more threads more fast data transfer....use default setting with this change and see, though i have configured tran repl with servers in shanghai and usa and it actually uses all network bandwidth with default settings
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply