Assistance Tuning Buffers
Hi Guys,
I would appreciate your assistance/recommendations with Buffer Tuning
Im experiencing high swapping on Several Buffer as shown Below
Which considerations would you take for adjusting these buffers to optimal Values?
Do you estimate the parameters values by incrementing by 10-20% ? Or is there a better way to determine the best values.
Thanks a lot for your help.
Nametab -->Table Definition
Efficiency HITRATIO % 97
HITS 119.405.209
REQUESTS 123.408.979
DB access quality % 97
DB access 4.006.836
DB access saved 119.399.849
Reorgs 0
Size Allocated KB 9.800
Available KB 8.219
Used KB 8.219
Free KB 0
Free KB 0
Directory entries Available 28.826
Used 28.826
Free 0
Swaps Objects swapped 1.032.168
Frames swapped 0
Resets Total 0
Table definition buffer TTAB
rsdb/ntab/entrycount 28826 Max. number of table definitions buffered
Nametab-->Field Definition
Efficiency HITRATIO % 100
HITS 80.761.920
REQUESTS 81.137.309
DB access quality % 100
DB access 363.063
DB access saved 80.761.378
Reorgs 0
Size Allocated KB 45.515
Available KB 43.263
Used KB 40.109
Free KB 3.154
Directory entries Available 28.826
Used 7.176
Free 21.650
Swaps Objects swapped 355.332
Frames swapped 0
Resets Total 0
rsdb/ntab/ftabsize 43263 kB Size of field description buffer
Program
Efficiency HITRATIO % 100
HITS 385.544.192
REQUESTS 385.922.653
DB access quality % 100
DB access 653.940
DB access saved 565.109.488
Reorgs 0
Size Allocated KB 400.000
Available KB 370.780
Used KB 369.428
Free KB 1.352
Gaps KB 1.303
Directory entries Available 100.000
Used 10.385
Free 89.615
Swaps Objects swapped 206.098
Frames swapped 0
Resets Total 0
Program buffer PXA
abap/buffersize 400000 kB Size of program buffer
abap/pxa shared Program buffer mode
Export/Import
Efficiency HITRATIO % 81
HITS 13.737.920
REQUESTS 16.906.841
DB access quality % 100
DB access 0
DB access saved 0
Reorgs 0
Size Allocated KB 4.096
Available KB 3.375
Used KB 2.757
Free KB 253
Directory entries Available 2.000
Used 1.031
Free 969
Swaps Objects swapped 32.476
Frames swapped 428.617*
Resets Total 0
Export/import buffer EIBUF
rsdb/obj/buffersize 4096 kB Size of export/import buffer
rsdb/obj/max_objects 2000 Max. number of objects in the buffer
rsdb/obj/large_object_size 8192 Bytes Estimation for the size of the largest object
rsdb/obj/mutex_n 0 Number of mutexes in Export/Import buffer