skip to main content

SAP NetWeaver Newbie

SYSTAT IDocs Causing High IO Load

The status idocs processed by SAP PI/XI can cause high CPU wait times (because of increased I/O activity). If you notice high CPU usage with most of the CPU spent on wait, check if there are SYSTAT IDocs are being processed (you can check SMQ1/SMQ2 with slow moving queues)

Checking high wait CPU on AIX using topas

If you check the SQL statements being executed at that moment, you might notice the following statement:

SELECT * FROM IDXRCVPOR WHERE IDOCNUMBER = <some IDOC number>

You might notice the SQL statement showing up in SM66 for 5-6 seconds and the explain statement would show very high IO-Costs in it is performing a full table scan.

To address this performance problem, create an index on IDOCNUMBER column of the table IDXRCVPOR

Posts labeled performance

No comments:

Post a Comment

Email Subscription

Get every new post into your inbox by subscribing us.

Want a reason to subscribe?
1. This sitemap might convince you to subscribe.
2. We do not misuse email IDs. We respect privacy.

© 2008 - 2017 sapnwnewbie. All rights reserved.