I'm currently setting up various servers which will consist of the following :
Publisher (8 CPU 32GB RAM) (My main DB is mirrored)
Distributor (8 CPU 20GB RAM) (Clustered)
6 VM Subscribers (4 CPU 20GB RAM) for reads and queries etc...
It's going to be a push subscription (transactional) running continuously. Initially there will be 20 publications with up to 500 tables being replicated.
My questions is about the -MaxBCPThreads setting. The default is 1, but is there a rule of thumb for what I should set this to ? I've found various articles saying that there is no benefit having more threads than articles, which makes sense, but no guidelines to what would be sensible.
I want to improve the speed of our systems where possible (don't we all ?) so is this worthwhile looking at ? Do I need to provide any more info to get a good idea of what to use to calculate a good value ?
Thanks
Ryan