Profile Parameters for SAP Buffers

[Former Member]

Dear Friends,

In ST02, swaps are generated more than standard recommendation. I am new to tuning, so please help me to resolve the same.

We are using SAP 4.7, Oracle 9.2.0.5.0.

Our Current Profile parameters are as mentioned below:

Table definition buffer

rsdb/ntab/entrycount 52902

Field description buffer

rsdb/ntab/ftabsize 48000

rsdb/ntab/entrycount 52902

Short nametab (NTAB)

rsdb/ntab/sntabsize 3000

rsdb/ntab/entrycount 52902

Initial record buffer

rsdb/ntab/irbdsize 15880

rsdb/ntab/entrycount 52902

Program buffer

abap/buffersize 600000

abap/pxa shared

CUA buffer

rsdb/cua/buffersize 8000

Screen buffer

zcsa/presentation_buffer_area 30000000

sap/bufdir_entries 10000

Calendar buffer

zcsa/calendar_area 500000

zcsa/calendar_ids 200

OTR buffer

rsdb/otr/buffersize_kb 4096

rsdb/otr/max_objects 2000

rsdb/otr/mutex_n 0

Generic key table buffer

zcsa/table_buffer_area 70000000

zcsa/db_max_buftab 30000

Single record table buffer

rtbb/buffer_length 30000

rtbb/max_tables 500

Export/import buffer

rsdb/obj/buffersize 30000

rsdb/obj/max_objects 30000

rsdb/obj/large_object_size 8192

rsdb/obj/mutex_n 0

Exp/Imp SHM buffer

rsdb/esm/buffersize_kb 4096

rsdb/esm/max_objects 2000

rsdb/esm/large_object_size 8192

rsdb/esm/mutex_n 0

Thanks & Regards,

Ranjith

[Former Member]

Tuning is very hard. And I have almost always seen red in ST02 for any company that I have worked for. there are many places to look for tuning information. I would start with a few like this:

http://www.sap-img.com/basis/tuning-summary-in-transaction-st02.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/c4/3a6ecc505211d189550000e829fbbd/content.htm

maybe a class like BC350 Workload analysis

SAP Notes has many thing available as well: 146528; 425207;37537; ...

The list can go on and on forever.

I hope that gives you a good place to start and good luck with your performance tuning.

Regards,

Paul

[markus_doehr2]

Nobody will be able to give you any numbers here.

Buffers are HIGHLY system dependent, tuning them is iterative. You will need to find out yourself the correct values because nobody knows e. g.

- how many users are using the system

- how many different "modules" are implemented

- how many transport are running into the system daily

- how many languages you have installed

etc.

Go to ST02 and increase the parameters you see in red, restart the system and wait for some days and check again. Increase them more if you see, that they are still swapping too much.

Another possibility is to book an Early Watch service, they will have a look on the system and give you recommendations.

--

Markus