on 07-09-2007 5:06 AM
Dear Expert,
We have a scenario which has lots of messages coming into XI in parallel, so accordingly we enlarge work process number and receiver queue number. Then we found the bottleneck happens when SAP XI want to insert/update/select information into DB table like XI_AF_MSG/XI_AF_MSG_AUDIT, most of the work processes are waiting/pending on the insert/update/select action. Is there any tuning we can do to improve the performance? Any idea or suggestion is appreciated.
What's more, we have already enlarge the DB(Oracle)'s process/session number, and the JDBC Connector's connection number.
Thanks and Regards,
Nick
U should fine tune ur JDBC application with this
Use option "Disconnect from Database After Each Message Processing" wherever applicable to ur scenario
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<i>Then we found the bottleneck happens when SAP XI want to insert/update/select information into DB table like XI_AF_MSG/XI_AF_MSG_AUDIT</i>
How r u achieving this without JDBC?
For handling large messages, the tuning guide would help u
http://help.sap.com/bp_bpmv130/Documentation/Operation/TuningGuide.pdf
Regards,
Prateek
BTW, when the waiting/pending happens, the CPU usage is around 99%.
PS: we have set the work process number as CPU#*4.
Thanks and Regards,
Nick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.