cancel
Showing results for 
Search instead for 
Did you mean: 

Extended memory uses reaches 100% at peak load time

Former Member
0 Kudos

Dear all/alaxander,

I am facing great problem with my production server. Please see it.

===========================================

System Configuration is:

AIX 5.3 /DB2/System P5 IBM Server/ 64 GB RAM but we can increase no issue.

Total Users: 200

==========================================

Buffer HitRatio % Alloc. KB Freesp. KB % Free Sp. Dir. Size FreeDirEnt % Free Dir Swaps DB Accs

Nametab (NTAB) 0

Table definition 99.94 6,797 1,386 24.32 19,990 4,861 24.32 0 46,553

Field definition 99.93 31,564 6,294 20.98 19,990 15,466 77.37 29,163 34,178

Short NTAB 99.94 3,625 2,141 71.37 4,997 2,248 44.99 0 2,749

Initial records 90.48 36,625 34,547 95.96 4,997 1,052 21.05 19,170 23,115

0

program 99.97 600,000 2,284 0.40 150,000 135,878 90.59 38,036 162,543

CUA 99.10 3,000 848 34.51 1,500 1,437 95.80 1,651,116 44,526

Screen 99.42 4,297 64 1.56 2,000 1,777 88.85 59,714 82,984

Calendar 100.00 488 359 76.22 200 49 24.50 0 151

OTR 100.00 4,096 3,375 100.00 2,000 2,000 100.00 0

0

Tables 0

Generic Key 99.35 29,297 1,068 3.85 5,000 528 10.56 12,478 5,072,562

Single record 99.72 10,000 297 3.03 500 409 81.80 1,251 97,533

0

Export/import 74.60 4,096 260 7.70 2,000 1,069 53.45 7,708,219

Exp./ Imp. SHM 98.94 4,096 3,183 94.31 2,000 1,999 99.95 0

SAP Memory Curr.Use % CurUse[KB] MaxUse[KB] In Mem[KB] OnDisk[KB] SAPCurCach HitRatio %

Roll area 0 0 131,072 0 IDs 99.28

Page area 0 0 65,536 0 Statement 98.00

Extended memory 100.00 8,376,320 8,376,320 8,376,320 0 0.00Heap memory 1,306,383 0 1,953,790 0 0.00

Call Stati HitRatio % ABAP/4 Req ABAP Fails DBTotCalls AvTime[ms] DB Rows Aff.

Select single 84.13 142,776,102 27,362,223 6,471,470 0 115,413,879

Select 80.19 199,250,652 0 22,134,490 0 171,627,222

Insert 0.00 31,728 283 32,384 0 71,660

Update 0.00 27,312 577 31,254 0 26,734

Delete 0.00 3,527 3,042 5,547 0 38,653

Total 82.16 342,089,321 27,366,125 28,675,145 0 287,178,148

====================================================

Current parameters are:

Buffer Name Comment

Profile Parameter Value Unit Comment

Program buffer PXA

abap/buffersize 600000 kB Size of program buffer

abap/pxa shared Program buffer mode

CUA buffer CUA

rsdb/cua/buffersize 3000 kB Size of CUA buffer

The number of max. buffered CUA objects is always: size / (2 kB)

Screen buffer PRES

zcsa/presentation_buffer_area 4400128 Byte Size of screen buffer

sap/bufdir_entries 2000 Max. number of buffered screens

Generic key table buffer TABL

zcsa/table_buffer_area 30000128 Byte Size of generic key table buffer

zcsa/db_max_buftab 5000 Max. number of buffered objects

Single record table buffer TABLP

rtbb/buffer_length 10000 kB Size of single record table buffer

rtbb/max_tables 500 Max. number of buffered tables

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

OTR buffer OTR

rsdb/otr/buffersize_kb 4096 kB Size of OTR buffer

rsdb/otr/max_objects 2000 Max. number of objects in the buffer

rsdb/otr/mutex_n 0 Number of mutexes in OTR buffer

Exp/Imp SHM buffer ESM

rsdb/esm/buffersize_kb 4096 kB Size of exp/imp SHM buffer

rsdb/esm/max_objects 2000 Max. number of objects in the buffe

rsdb/esm/large_object_size 8192 Bytes Estimation for the size of the larg

rsdb/esm/mutex_n 0 Number of mutexes in Exp/Imp SHM bu

Table definition buffer TTAB

rsdb/ntab/entrycount 19990 Max. number of table definitions bu

The size of the TTAB is nearly 100 bytes * rsdb/ntab/entrycount

Field description buffer FTAB

rsdb/ntab/ftabsize 30002 kB Size of field description buffer

rsdb/ntab/entrycount 19990 Max. number / 2 of table descriptio

FTAB needs about 700 bytes per used entry

Initial record buffer IRBD

rsdb/ntab/irbdsize 36000 kB Size of initial record buffer

rsdb/ntab/entrycount 19990 Max. number / 2 of initial records

IRBD needs about 300 bytes per used entry

Short nametab (NTAB) SNTAB

rsdb/ntab/sntabsize 3000 kB Size of short nametab

rsdb/ntab/entrycount 19990 Max. number / 2 of entries buffered

SNTAB needs about 150 bytes per used entry

Calendar buffer CALE

zcsa/calendar_area 500000 Byte Size of calendar buffer

zcsa/calendar_ids 200 Max. number of directory entries

Roll, extended and heap memory EXTMztta/roll_area 3000320 Byte Roll area per workprocess (total)

ztta/roll_first 1024 Byte First amount of roll area used in a dialog WP

ztta/short_area 3200000 Byte Short area per workprocess

rdisp/ROLL_SHM 16384 8 kB Part of roll file in shared memory

rdisp/PG_SHM 8192 8 kB Part of paging file in shared memory

rdisp/PG_LOCAL 150 8 kB Paging buffer per workprocess

em/initial_size_MB 8184 MB Initial size of extended memory

em/blocksize_KB 4096 kB Size of one extended memory blockem/address_space_MB 4092 MB Address space reserved for ext. mem. (NT only)

ztta/roll_extension 2000683008 Byte Max. extended mem. per session (external mode)

abap/heap_area_dia 2000683008 Byte Max. heap memory for dialog workprocesses

abap/heap_area_nondia 2000683008 Byte Max. heap memory for non-dialog workprocesses

abap/heap_area_total 2000683008 Byte Max. usable heap memory

abap/heaplimit 40894464 Byte Workprocess restart limit of heap memory

abap/use_paging 0 Paging for flat tables used (1) or not (0)

Statistic parameters

rsdb/staton 1 Statistic turned on (1) or off (0)

rsdb/stattime 0 Times for statistic turned on (1) or off (0)

==============================

System Configuration is:

AIX 5.3 /DB2/System P5 IBM Server/ 8 GB RAM but we can increase no issue.

Therefore I request you to provide a solution as soon as possible. Thanking you.

With best regards

Dharmendra Kumar

Work Processor Details:

====================

0 DIA 1020158 On Hold PRIV Yes 13 SAPMF02K 300 FIPU

1 DIA 1052920 On Hold PRIV Yes 11 53 SAPMV45A 300 HYDGOD1

2 DIA 766148 On Hold PRIV Yes 9 392 /1SDBF12L/RV14AKZ1 300 SHYAM

3 DIA 897176 On Hold PRIV Yes 18 300 SAPLSMTR_NAVIGATION 300 KRPSAL1

4 DIA 925904 On Hold PRIV Yes 8 SAPLBARM 300 KRPTIM1

5 DIA 786442 On Hold PRIV Yes 4 387 SAPLS_IMG_TOOL_5 300 FIPU

6 DIA 1069206 Running Yes 8 109 ZSALESREGISTERNEW 300 BHRSAL3 Direct Read KOCLU

7 DIA 1061068 On Hold PRIV Yes 9 309 ZFI_REM_REPORT_1 300 KOLAO3

8 DIA 655426 On Hold PRIV Yes 8 287 RM_MEPO_GUI 300 CHNACC1

9 DIA 966674 On Hold PRIV Yes 6 RFITEMAR 300 CHNACC1

10 DIA 1007788 On Hold PRIV Yes 4 27 SAPLSMTR_NAVIGATION 300 BLRGOD1

11 DIA 913518 On Hold PRIV Yes 2 SAPMV60A 300 PNEACC1

12 DIA 667736 On Hold PRIV Yes 8 1 SAPDF05X 300 PNEACC1

13 DIA 717044 On Hold PRIV Yes 3 77 SAPMV60A 300 BLRGOD2

14 DIA 729272 On Hold PRIV Yes 5 335 RFITEMAP 300 DABINDER

15 DIA 860340 On Hold PRIV Yes 6 3 SAPMF05L 300 BLRACC1

16 DIA 876666 Running Yes 3 SAPLTHFB 300 DABINDER

17 DIA 843814 Running Yes 7 SAPLSLVC 300 TZTTIM1

18 DIA 815254 Waiting Yes 2

19 DIA 819348 On Hold PRIV Yes 9 ZMM_STOCK_STATUS 300 SHYAM

20 UPD 909462 Waiting Yes

21 UPD 946418 Waiting Yes

22 UPD 921636 Waiting Yes

23 BGD 1040622 Waiting Yes

24 BGD 495638 Waiting Yes

25 BGD 827544 Waiting Yes

26 BGD 1028330 Waiting Yes

27 SPO 979136 Waiting Yes 2

28 SPO 643270 Waiting Yes

29 SPO 848032 Waiting Yes

30 SPO 466944 Waiting Yes

31 UP2 647372 Waiting Yes

32 UP2 1044728 Waiting Yes

========================

Juan Reyes Writes:----


Hi Dharmendra,

In my opinion you should try reducing your ammount of DIA and SPO processes... I'll reduce DIA from 20 to 12 and SPO from 4 to 1 or 2...

Then see how the system behaves..

Regards

Juan

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

i think you should visit http://help.sap.com/saphelp_nw70/helpdata/en/02/96253c538111d1891b0000e8322f96/frameset.htm and configure/fine tune your memory parameters.

and Profile Parameters of Memory Management http://help.sap.com/saphelp_nw70/helpdata/en/02/96268c538111d1891b0000e8322f96/frameset.htm

cheers,

-Sunil

Answers (3)

Answers (3)

Former Member
0 Kudos

HI

You have been mentioned that your hit ratio has been reached to 100% but you did not write the problem.

What types or problem you facing once it reach to 100% ?

When problem arising ? is it arising on peak time ?

any heavy application is running which is occupying the whole resources of application server ?

Regards

Anwer Waseem

SAP BASIS

Former Member
0 Kudos

you have

AIX 5.3 /DB2/System P5 IBM Server/ 64 GB RAM but we can increase no issue.

and according to

SAP Memory Curr.Use % CurUseKB MaxUseKB In MemKB OnDiskKB SAPCurCach HitRatio %

Roll area 0 0 131,072 0 IDs 99.28

Page area 0 0 65,536 0 Statement 98.00

Extended memory 100.00 8,376,320 8,376,320 8,376,320 0 0.00Heap memory 1,306,383 0 1,953,790 0 0.00

you only allocate 8GB of physical memory to extended memory, you can increase the value of profile parameter related to the extended memory with bigger value.

i cant really remember what is the profile parameter, but you can go to the extended memory information row and press F1 read the technical information there.

tanuj_gupta
Explorer
0 Kudos

Hello Dharmendra,

Extended memory will be used at 100% at peak hours which is very possible. However reducing the work process is not a solution to such a case.

You need to identify the programs which are utilizing maximum amount of Extended memory using the ST03 and St02 transaction. Once you identify the programs utilizing high amount of memory, you need to check with the end users and ABAP developers, if this requirement of high memory can be reduced by splitting the program, if Y-Z cusotmer programs. If SAP program, you need to look out for SAP Notes for possible optimization of such programs.

Else you can also consider increasing the Extended memory on the server. One more thing, you should remember here. Extended memory utilization in ST02 will show the max utilization till the server restart. For e.g. check these values :

22.10.2007 15,38

21.10.2007 6,45

20.10.2007 100,00

19.10.2007 100,00

18.10.2007 100,00

17.10.2007 89,63

16.10.2007 77,51

15.10.2007 77,51

14.10.2007 17,80

This result means that there system restarted on 14 Oct, let say. Max utilization on 14 Oct was 17,80. However on 15 oct, it reached 77,51. 16 Oct shows again 77,51. It means that EM utilization on 16 Oct is either less or equal to 77,51 this day. Similarly 100% utilization shown on 18, 19 and 20 Oct means that on 18 Oct, t reached the max utlizaiton of 100% But on 19 or 20 Oct, value will still show last max threshhold reached since last restart. This max value will be released once the system is restarted as done on 21 Oct.

Hope this example makes the things simpler to you. Still if you see daily high utilization, as suggsted above, check for the programs utilizing high EM and take an action accordingly.

Hope this helps!

Award points if useful.

regards

Tanuj