Memory Usage of a PI Message

[former_member191528]

Hello All,

We are doing a POC on sending a ~ 40 MB payload file through PI which updates a table using JDBC adapter. The process is async and takes around 25 minutes. Is ther a way to check the memory consumption of the message ?

Thanks,

Kiran

[MichalKrawczyk · Accepted solution]

hi,

>>>>We are doing a POC on sending a ~ 40 MB payload file through PI which updates a table using JDBC adapter. The process is async and takes around 25 minutes. Is ther a way to check the memory consumption of the message ?

1. why do you need to determine the memory consumption ? probably the jdbc call itself is that long (far too long for 40 Mb....)

2. with ICO the memory occupied can be 40 Mb (due to one persistence step)

3. on my system we're doing 2 Gb of messages (file to JMS) in less then 5 mins ... (ICO 7.11)

so there must be something wrong at your confg

Regards,

Michal Krawczyk 

[former_member191528 · Accepted solution]

Hi Michal,

We are using AAE in PI 7.1 with Integration Configuration object PI 7.1 SP6. We are picking up a file and writing it to a table using JDBC driver. There are over 300,000 records being written in the backend. Any recommendations on a better way of doing it ?

Thanks,

Kiran

[MichalKrawczyk · Accepted solution]

Hi,

>>>We are using AAE in PI 7.1 with Integration Configuration object PI 7.1 SP6.

this is the proper config but 40 Mb in 25 mins is way to slow I'd say

can you check where the issue is ? which part of the flow is slow ?

(jdbc insert only?) maybe the DB is too far (another continent) - there are many factors which can cause long delays and it's not always possible to give a "general" remedy without seeing the system

but try finding exactly where the issue is and concentrate on this part mostly, in PI terms and ICO 40 Mbs is nothing,

Regards,

Michal Krawczyk

[former_member191528 · Accepted solution]

Thanks Michal !! We will continue our investigation. The table is actually a simple flat structure in Oracle database which is located on site. I appreciate your feedback on the issue. Since the JDBC adapter is updating one record out of 300,000 records at the time which may indicate why it is slow.

[MichalKrawczyk · Accepted solution]

hi,

use this guide to help you with investigation:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0b96675-87cf-2c10-b489-dee0ac03f...

Regards,

Michal Krawczyk

[baskar_gopalakrishnan2]

> Is ther a way to check the memory consumption of the message ?

If you are looking for the size of your payload message, then you can see it in SXMB_MONI itself.  Plus you can also go to RWB and see the performance monitoring area. There you will see the performance chart of each message vs time and memory size.