Apparently this parameter will speed up the initial snapshot to a subscriber
on sql2000. Has anyone used it ? What kind of improvement did it provide and
are there any concerns in using it ?
--
Chris

Yes I have - it works great for large snapshots when the subscriber is a
multi-proc machine. I got a 40% increase in snapshot application time for a
large snapshot.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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



"Chris McGoey" <ChrisMcGoey (AT) discussions (DOT) microsoft.com> wrote