Performance issue on production environment

[Former Member]

Hi experts,

we have an http to file scenario. The mapping includes one call RFC for lookup.

For one same test message, on quality environment, it takes about 20 seconds to achieve transformation and 15 minutes on production...thus on production, we have many messages 'recorded for outbound processing' in sxmb_moni and SMQ2 empties slowly since each message takes at least 15 minutes (we have around a hundred messages per night).

Do you have any idea where it might come from ?

Also, do you know if I can find any detailed trace (equivalent to SQL trace for example) of what happens when the message is executing ?

Plus, do you have any idea what parameter we may have to look at ?

Any help would be greatly appreciated!!!!

Kind regards,

Jamal

[Former Member]

Hi,

actually there are some interessant inputs in 'SAP NetWeaver Process Integration - Performance Check.pdf'

Long processing times for
u201CPLSRV_MAPPING_REQUESTu201D
The mapping request for a message involves more than one runtime. The starting point is the
Integration Engine that will send the request via RFC destination
AI_RUNTIME_JCOSERVER to the gateway. There it will be picked up by a registered server
program. The registered server program belongs to the J2EE Engine. The request will be
forwarded to the J2EE Engine by a JCo call and then be carried out by the JAVA runtime.
When the mapping has been carried out, the result is sent back to the ABAP pipeline via JCo.
Thus, there are several places to check when trying to trace down why the mapping step took
so long.
o Not enough resources (registered server programs) available. That could either be
the case if too many mapping requests are issued at the same time or if the J2EE
Engine is down and did not register any server programs.

Plus we applied note sapnote_0001361495.pdf that resolved the issue on SPI_* job running for a longtime.

Thnaks all for your help

[former_member4985]

Hi,

For bad performance in SMQ2 you can use tcode st06 and check the number of CPUs.

After, go to sm50 and check the number of "Dialog Process" you have.

Genereally it's recommended that you use 6*(number of CPUs)+10 Dialog Process.

Also, check if the parameter MaxThreadCount is set to 350.

Regards,

Caio

[Former Member]

Hi experts,

thanks for feedback.

I have checked RFC trace, but i'm having some troubles analyzing them, there are just some logs that are sometimes not explicit. I have a maximum connections of RFC configured to '5'. Could you please tell me how to analyze RFC trace properly ?

Also, could you please tell me where to check the parameter MaxThreadCount ?

Thanks again for your help,

Regards,

Jamal

[former_member181962]

Hi,

You can check the SM59 transaction in your SAP system where your RFC is residing and chose from Menu: RFC->Display Trace.

And what is the value for Maximum Connections in your RFC adapter?

Try increasing it to some value and see if it helps.

Regards,

Ravi Kanth Talagana

Edited by: Ravi Kanth Talagana on May 12, 2010 5:13 PM