SPAM process very slow in phase IMPORT_PROPER

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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