How to do SAP Buffer Tuning

[Former Member]

Hi Gurus!

We having performance problem on some tcode lately (we are using sap R/3 4.7 on Windows - 2003 Server & our database is Oracle - 9i )

Can anybody give me an advice or link to sap notes or the other article or guide how to perform sap buffer tuning, and optimizing instance parameter ?

Thank you in advance.

Regards,

Shishir

[Former Member]

Thanks

[Former Member]

Hi,

Refer below link.<a href="http://help.sap.com/saphelp_erp2005vp/helpdata/en/99/841af13b66f04a9d1a9042fcd0ea0d/frameset.htm">http://help.sap.com/saphelp_erp2005vp/helpdata/en/99/841af13b66f04a9d1a9042fcd0ea0d/frameset.htm</a>

Regards,

Suraj

[markus_doehr2]

Check

http://service.sap.com/performance

--> Media Library

What you can do additionally is to search for the program and/or table name in the OSS you´re encountering problems.

What specific transactions do you have problems?

--

Markus

[former_member239282]

Task 1 :

Check for tables which are not buffered, but should be.

For example, check the customer’s:

Customising tables, (table names beginning with Y or Z)

Condition tables (for example, table A<nnn>, where nnn 500 to 999

Task 2 :

Check for tables which are buffered, but should not be.

For example, check large and frequently changed Customising

tables, such as:

Table TCURR (exchange rates)

Tables A005 (prices), A017 (customer/material), and A018 (vendor/material)

In the Online Service System (OSS), see also, for example, R/3 Notes 23877, 91335, and 34910