Skip to Content
author's profile photo Former Member
Former Member

PI performance issue for a single Interface

Hi experts,

In a PI 7.0 system we are experiencing very bad performance for a single interface. It is sending daily a 1MB payload message and it takes about 10 seconds to process (this is OK), but on fridays a bigger set of records is sent, about 45MB payload. It takes more than 2 days to process the message!!!

I have been doing some research and I see that the bottleneck is in the Integration Engine. I have compared it with other interfaces that sent huge messages as well, and I only see a point that I don´t understand. While other messages, of about 43MB payload (read it in SXMB_MONI, parameter <SAP:MessageSizePayload>) has a message size of 15MB in field MSG_SIZE of table SXMSPMAST, the problematic interface, with a <SAP:MessageSizePayload> parameter of 45MB, has SXMSPMAST-MSG_SIZE of 19MB.

Can somebody explain me the relationship between these two sizes and and idea on what can I do in order to reduce MSG_SIZE?

Thanks in advanced for your help

Javi

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Dec 08, 2011 at 09:44 PM

    If it is feasible, modify the design to go with smaller volume of data in each interfaces. Example if your interfaces deal with jdbc, query for smaller volume of records to reduce the size of the message. Similarly if you have file conversion then set recordsets per message like 500 records per file. Also you might want to consider using tuning parameter to allocate special queue & memory size handle per message in transaction sxmb_adm. Search forum for tuning parameters configuration in SXMB_ADM

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 08, 2011 at 09:07 PM

    For your performance problem, have you created a separate XBTL* or XBTM* queue for processing large messages?

    MessageSizePayload refers to the size of actual payload. This value is available in bytes. What is the exact value you see there?

    Regards,

    Prateek Raj Srivastava

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.