sql server replication: transaction log performance -- sql server replication

transaction log performance

Roy Goldhammer
7/31/2007 12:00:00 AM

sql server replication:

Hello there

From some investigations i've made it seems that transaction log for
replication slowing performance.

But on simple recovery model the transaction log used for transactional
replication slowing performance less then recovery model full.

I'm wondering whay.

Does it because transaction log using bulk copy which is faster then full
recovery model?

Re: transaction log performance

Hilary Cotter
7/31/2007 12:00:00 AM

I have not seen this. I see better performance when applying the snapshot
when the subscriber database is in the bulk logged recovery model.

--
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]