Skip to Content
avatar image
Former Member

Export speed

Hello,

we are trying to export a content server, according to SAP note 962019. First we are trying with a QA-system. There is not much load on it, DB size is about 200GB.

What makes me worry is the speed of about 2GB/h, or about 155GB since Friday. Is this expected behaviour, or should it be much faster?

DB is on local disks, DB version is 7.5.0, on Win 32bit.

loadercli is running on a remote system, version 7.6.03, on Win 64 bit.

command x_cons <SID> show active is showing one process, in status 'IO Wait (R)'

regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 24, 2008 at 12:52 PM

    Hi Jon,

    how many datavolumes are configured for the source database?

    Please activate DB Analyzer (set snapshot interval to 120 secs.) and the time measurement (x_cons <SID> time enable).

    What I/O timings do you get from DB Analyzer?

    Please do also let us know the parameters of the source db instance.

    regards,

    Lars

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Lars Breddemann

      Hello Lars,

      thanks again. So we will go the backup/restore way.

      And it's good news that an upgrade of MaxDB should be easier than e.g. Oracle. I did that a few times, and found it quite time consuming, especially because of those many SAP notes that have to be read and patches that have to be applied.

      As for research about the slowdown of export: Unfortunately our leasing contract is going to end, and we will have to return that old box this Friday. So there will be not enough time, I'm afraid.

      Luckily, on the other hand, our users will not need the new QA system immediately. It will be sufficient, if we create a new QA system in the beginning of December, and we are free to create it either as a copy of the old QA, or as a copy of the old production system.

      And Prod will have to be migrated afterwards.

      So for me the next thing to be done will be an upgrade test on the old box.

      best regards