Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
crm 2011 to crm 2013 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    We are doing an upgrade from CRM 2011 to CRM 2013  and the approach we have choosen was  running an import organization using the deferred table merge.<o:p></o:p>

    Does any one has information on  regkey 'NumThreadsForParallelMerge'  which is used to increase the no of parallel threads in merging the tables.<o:p></o:p>

    The question here is  how this will help? <o:p></o:p>

    will it take each table and run on multiple threads and compelte the initial table and move to the next?
    or run each table on different parallel threads ?

    <o:p>Regards,</o:p>

    <o:p>Anwesha</o:p>

    <o:p></o:p>

    Sunday, January 31, 2016 11:21 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    I've not seen any documentation on NumThreadsForParallelMerge, but I expect any table will only be merged on one thread (there's no point otherwise, as they'd be SQL locking issues), so this setting will be the maximum concurrent tables that can be merged.

    The optimal value will depend on your hardware configuration. Broadly, the more processor cores (SQL and CRM servers), the higher this can go, but the disk and memory (SQL Server) will also have an impact. Multiple threads can usefully run on the same core if some threads are waiting for I/O operations. If you have a lot of processor cores (maybe 8 or more per server), and tables larger than the memory available to SQL Server, then you could try increasing this setting.

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Sunday, January 31, 2016 8:17 PM
    Moderator