Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Toolbox sap-other Reply from CWK on Aug 12 at 9:56 AM Adrian -- ZARIXFI2 is an info-structure table and not everyone uses the SAP "information" functionality. You may be discovering one of the reasons why -- it can easily affect performance. We experimented with some of the information structure possibilities MANY years ago (so my memory is not fresh) in order to provide some desired visibility. Real-time updating of these tables can affect performance if the info-structure in question relates to transactions or processes that generate a lot of new or changed data. I seem to recall that some info-structure can be set up so they aren't updated in real-time, but can be scheduled for update using some kind of batch functionality at night (or the weekend) -- not sure, though. We eventually decided not to use any of the info-structure (you either commit to it or you go with some other visibility solution, such as a data warehouse). One thing to do with any table that seems to be misbehaving performance-wise is to have your DBA's check it out and make sure Statistics have been run on it. While there are a number of SAP-owned objects and programs that begin with 'Z' I have never seen one that begins with 'ZZ' -- in my experience ZZ-programs/objects/field definitions, etc. that begin ZZ are always custom. Good luck, Carl
| | | ---------------Original Message--------------- From: fongoodty mas baruly Sent: Thursday, August 06, 2015 2:35 AM Subject: Archiving Infostructure ZZFI_DOCUMNITK & SAP_FI_DOC_002 for Structure Table ZARIXFI2 Hi Gurus, We have noticed in ST04 Performance Table ZARIXFI2 had the highest reads of 31,972,142,607. We suspect this can cause performance bottlenecks to our system. I found a workaround in sap note 2179637. https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361
However I would like to ask you on why seems almost all tcodes are accessing the ZARIXFI2 including MIGO & MIRO? Thanks. Regards, Fongoodty | | Reply to this email to post your response. __.____._ | _.____.__ |