January 13, 2010 at 8:59 am
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
January 13, 2010 at 9:01 am
I should add that the Publisher and Distributor are running SQL 2008 SP1 on Windows Server 2008 and the subscribers Server 2003 SQL 2005 SP3. Everything is 64 bit.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply