After extensive testing I have found that bcp's run almost twice as fast on my dedicated Distributor than on either the Publisher or Subscriber. I was wondering if there is a way to make the bcp's spawned by creating a Snapshot run on the distributor and not the Publisher.
Any comments?
I am not sure what you are really after but the snapshot agent (hence all the bcp threads, we don't launch separate bcp.exe processes) is supposed to run on the distributor so I am probably just getting it all wrong 
- Raymond
No comments:
Post a Comment