Skip to Content
avatar image
Former Member

SPAM process very slow in phase IMPORT_PROPER

SPAM process is very slow in importing STACK on ECC6 EHP4 system; is there any way to speed it up.

these are the steps i did:

1. Increased Background process number using parameter

2. Increased RAM to 32gb from 16gb

3. ran command to update stats on MSSQL server and restarted server again

is there anything else i can do to improve performance?

Mani

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 22, 2014 at 08:02 AM

    Hi Mani,

    If I understand correctlly, you have an ECC 6 system with EHP 4 and you are applying a support stack with SPAM.

    I guess that you did not restart the server whilst the support pack was being applied?  If you did, then the transports would have been rolled back and re-applied (if you're lucky), so would have taken longer.

    You really aren't going to be able to speed this up with more WP's and RAM as this is a transport being imported with tp.

    Regards,

    Graham

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 22, 2014 at 02:51 PM

    Hello Mani,

    You can use the parallel feature as described in the below notes.

    1309506 - SPAM/SAINT with parallel R3trans

    1127194 - R3trans import with parallel processes

    regards,

    pavan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 23, 2014 at 07:43 AM

    Hello

    If you using SQL you can set "max degree of parallelism" to 0. That will allow SQL server allocate all available CPUs to query execution.

    Also in SPAM / SAINT transaction you can set number of parallel processes.

    You can also set TP parameter "PARALLEL" in TMS settings but I do not recommended to set it very high, ideally 3-4 should be enough.

    Best regards

    Kaan

    Add comment
    10|10000 characters needed characters exceeded