Post reply

-MaxBCPThreads setting (what rule of thumb ?)

  • January 13, 2010 at 8:59 am

    #219238

    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

    #1103117

    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