sql server replication: Large delete stmt - 2nd question -- sql server replication

Large delete stmt - 2nd question

Chris
9/19/2005 4:03:03 PM

sql server replication:

Publisher has delete stmt executed against transactionally replicated table.
270K rows deleted in 1 stmt.

1 Subscriber connected with T1

How best to replicate all the 270K simpleton delete calls to
sp_MSdel_tablename at subscriber through distr agent? What parameter
adjustments to make?

Changed -CommitBatchSize to 1000, doesn't seem to increase speed much...

Thanks,

Re: Large delete stmt - 2nd question

Hilary Cotter
9/19/2005 8:49:46 PM

Set HistoryVerboseLevel to 0, CommitBatchSize to 1000 and
CommitBatchThreshold 10000

--
Hilary Cotter
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]