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 800000is 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
Look at the basics of troublshooting slow performance http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx that is applicable to 2005 too. See this http://jagbarcelo.blogspot.com/2006/07/distribution-agents-network-efficiency.html too.