Skip to Content
avatar image
Former Member

Homogeneous System Copy based on MSSQL

Hi Support Gurus,

I am performing a homogeneous system copy based on Microsoft SQL Server 2008.I have run System Copy using Sapinst twice and i am not getting the desired result.

The DB size is 3 TB and in both runs i have tried something different.

First Run --> I ran Sapinst without using table splitting preparation and package splitting.The run took more than 72 hrs.

Second Run --> I used Table Splitting preparation.I split 31 large tables by taking threshold of 5 GB for each chunk.The splitting ran fine and .WHR files were also generated. I then ran Database Instance Export , using package limit size as 10 GB and specified an order in which tables and packages should be unloaded.This time it took time more than the first run and the size of the Export was also larger.

My area of concern is that when i started the export, at that point it was using all the 30 R3 Load processes and the CPU utilization was also good but it left the SAPAPPL1 package for export in the end and only one R3 Load process was working on it.The export of SAPAPPL1 package almost took 3 days.

I don't understand when I had specified a package limit of 10 GB, then why the export was still so large for SAPAPPL1 package and it took 3 days.

Please suggest me on what am I missing.Is it the order or the package limit size.

Thanks & Regards

Sumit Prasad

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Oct 21, 2013 at 04:47 PM

    Hello Sumit,

    Have you tried backup/restore? This could help you.

    Remember to use a version with page compression (2008 SP2, 2008 R2 SP1 or 2012).

    Regards,

    Eduardo Rezende

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Eduardo,

      We are trying to do DB reorg and we are using System Export\Import method.We need to achieve minimized downtime for this operation.

      Please suggest further.

      Thanks & Regards

      Sumit Prasad

  • Oct 21, 2013 at 07:08 PM

    Hello Sumit,

    for MS SQL 2008 'the database specific system copy way' is much faster as the export/import way.

    Please have a look in the adequate system copy guide / area 'Database Specific System copy'.

    SAP-Note 555223 (Question 8) and note 151603 could be additional helpful.

    The backup/restore way (recommended from Eduardo) is really very useful, because you didn´t have a downtime of the source system.

    If you could have a downtime (perhaps in the case of a hardware migration) you could switch the SAN-Devices very fast from the old server to the new server without copy the data files manually.

    In my opinion, it only make sense to use export/import way if your source ms sql database is under  2008 and the target database is ms sql 2008 (or a higher version) because the export/import way is an easy way to actitvate the 'new' compression during the import.

    best regards

    Jörg

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 22, 2013 at 07:48 AM

    Hi,

    for me it looks like as if the table splitting doesn't work correctly. You should open an OSS message for this, as there were several changes in this area within the last half year.

    Regards

    Clas

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 22, 2013 at 10:09 AM

    Hello,

    try to analyze the export/import time with the Migtime Tool (note 784118).

    With this tool you are able to find the long running package(s) and you could try to split the affected package(s) more useful.

    best regards

    Jörg

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Deepak Kori

      Hi Deepak\SAP Gurus

      Table splitting and package splitting has worked fine for me.I was able to export source DB in 13hrs.

      Now when i am performing the import, it is taking 3 days to finish.

      Couldn't understand why as i have specified more number of R3Load proceses than i took for Export.

      Waiting for your suggestions

      Thanks & Regards

      Sumit Prasad

  • Oct 31, 2013 at 09:36 AM

    Hi Sumit ,

    Can you check if your DB  it still running ?

    Best Regards,

    AhMeD

    Add comment
    10|10000 characters needed characters exceeded