Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance issue with a PI System

Hello

I am currently doing my Master Thesis, which is about a Software Experiment comparing performance between two "architectures" in SAP.

However, I am getting some unexplained pauses in the PI system, which I don't understand. I am not sure, whether this is a problem with the settings or a problem with the PI system itself (there might be a reason for the pauses), but the pauses are skewing the results and therefore the survey.

The scenario is this:

A number of XML files is placed on one system, and we want to extrapolate data from these files and insert the data in a database on another system.

The servers are all 3 GHz servers (4 cores), with 16 GB ram. The "file system" and the "database system" are both running SAP 6.0, while the PI system is running 7.0.

Architecture 1 - Two servers:

We use an ABAP program and a XSLT transformation to extrapolate and transfer data from the system with the files to the system with database. An experiment with 10.000 files took 191,879 seconds.

Architecture 2: - Three servers:

The same servers are used as in Architecture 1, however a PI System is used to extrapolate and transfer the data from the system with the files to the system with database. I am using a File Adapter. An experiment with 10.000 files took 728,53 seconds.

This is quite a bit longer and the reason for this can be found in the timestamps used to calculate the time. Each piece of data gets a timestamp from each server, an a example can be seen below:

...

...42.4440000

...42.4440000

...45.8040000

...45.8190000

...

As you can see there is about a 3 sec pause, and this pause occurs once every 20-30 files. Can you point at any obvious reasons for this small pause?

As I am learning PI is a complex system, so I am pretty sure you need more information about how the system was set up, unless the answer is simple. I am of course, more than willing to supply more information, so that I might get a correct evaluation of the performance of the PI system, however I am not sure what kind information you want. Because of the complexity of the system, a full description of the set up and the settings would transform this post into a novel.

Best Regards and thank you in advance!

Andreas

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question