locked
Organization Import RRS feed

  • Question

  • All,
    I have some questions about performing an organization import.

    I am trying to setup a standalone development environment.

    I have a virtual machine created. It has been allocated 4 GB of memory.

    I have installed SQL Server 2008 SP1 and CRM 4 with update rollup 15.

    I restored a copy of my production database onto my development virtual machine. 

    Our SQL Backup or our production database is approximately 20 GB.

    The account that I'm using to perform the import has read/write privileges to the OU in our domain.

    When I perform the organization import I am seeing incredibly long import times. 

    The current import has been running for approximately 16 hours. It's not finished yet.




    So my questions are:
    Is this typical ?
    How large are other users CRM databases ?
    How can I efficiently refresh development crm instances ?
    Why does the CRM Import organization process take so long ?
    If my development crm instances are in the same domain as my production 
     instance can I just do a database restore and not run the CRM Import Organization process ?


    Wednesday, September 7, 2011 1:41 PM

Answers

  • Hi David,

    1)      Please add the following registry keys on the CRM sever:

    a. HKEY_Local_Machine\Software\Microsoft\MSCRM key

    b. Right click on the blank space ,New à DWORD value

    c. Enter the key named OptimizeOrgImport.

    d. Modify the value of the key to “1”

     

    Add the following registry keys to increase the timeout values as specified in the KB article http://support.microsoft.com/kb/918609 [Method 1]

     

    Regards,


    Khaja Mohiddin|||||http://www.dynamicsexchange.com/
    Thursday, September 8, 2011 1:41 PM

All replies

  • Hi David.

    I sucessfully imported a 20Gb Database org in about 1 hour.

    16 hours is really too much.

    Is the virtual machine performing properly ?

    Start task manager to hava a look to CPU/RAM/Swapping.

    A.

    Wednesday, September 7, 2011 1:50 PM
  • That is taking too long.

    What is happening in the logs?

     


    Curtis J Spanburgh
    Wednesday, September 7, 2011 3:29 PM
    Moderator
  • Andrea,

     

    Box does appear to be paging quite heavily. I will see if I can increase the memory. CPU looks Ok

     

    Out of curiosity, what kind of hardware (memory / processors) do you have on the computer where you imported a 20 gb db in an hour ?

    Wednesday, September 7, 2011 3:55 PM
  • Curtis,

    The import logs show that it's mapping the users to their AD accounts.

    Unfortunately I don't have the trace logs turned on in this VM.

    Wednesday, September 7, 2011 3:56 PM
  • Last week I imported a 4.0 database org into a Hyper-V VM in my lab.  I imported it into my CRM 2011 lab.

    I setup a SQL 2008 server with 2GB and kept the databases off the system partition.

    I setup the application server on a Win2008 virtual server with 2GB.

    CPU is Dual Core.  I'm balancing the CPU use.

     


    Curtis J Spanburgh
    Wednesday, September 7, 2011 4:42 PM
    Moderator
  • Hi David,

    1)      Please add the following registry keys on the CRM sever:

    a. HKEY_Local_Machine\Software\Microsoft\MSCRM key

    b. Right click on the blank space ,New à DWORD value

    c. Enter the key named OptimizeOrgImport.

    d. Modify the value of the key to “1”

     

    Add the following registry keys to increase the timeout values as specified in the KB article http://support.microsoft.com/kb/918609 [Method 1]

     

    Regards,


    Khaja Mohiddin|||||http://www.dynamicsexchange.com/
    Thursday, September 8, 2011 1:41 PM
  • it's a VM running on a Xeon CPU E5430 @ 2.66GHz; it has 3 GB of RAM assigned.

    On the same sarver there are others VM.

     

    Anyway I didn't mapped all the users but just 4 of them.

    I don't know if this speed up the process...

    Monday, September 12, 2011 9:49 AM