Swapping increase

[former_member182034]

Hi All,

my DEV system is running very slow and Swap size increased.

while i run the following command for reset the buffer.

/$SYNC This resets all buffers of the application server

/$CUA This resets the CUA buffer of the application server

/$TAB This resets the TABLE buffers of the application server

/$NAM This resets the nametab buffer of the application server

i did restart the system after run above command then ST02 went to normal swap while swap is

increasing once again. I am send you ST02 status and Parameters and please have a look and

guide me.

while here window server 2003 with ECC 6.0 SR3 and oracle 10.2.

I am waiting your respons.

Regards,

jamil

[former_member182034]

almost completed.

[markus_doehr2]

> /$SYNC This resets all buffers of the application server

> /$CUA This resets the CUA buffer of the application server

> /$TAB This resets the TABLE buffers of the application server

> /$NAM This resets the nametab buffer of the application server

>

> i did restart the system after run above command then ST02 went to normal swap

It does not make sense to do that.

Those commands CLEAR the buffers but they don't free the memory. I would expect even the opposite effect, swapping will increase even more because the buffers need to be read again from database because you cleared them...

And then your restarted the system - which will initialize the buffers again....

Markus

[former_member182034]

Thanks Markus for reply.

Dear, i have made some changes in instance profile on the behalf of Senior plz have a look.

1. Update V1 work process = 3  from 1
2. Update V2 work process = 2 From 1
2. abap/buffersize = 512000   from 300000
3. PHYS_MEMSIZE = 7168    (70% of Total memory)
 DEV and QAS on same machine, so I distributed the 24GB. Give 10GB to DEV and rest for QAS.
5. zcsa/presentation_buffer_area = 6400000 from 4400000
6. rsdb/ntab/ftabsize        = 45000 from 30000 (default valuse) /increased 50% value
7. rsdb/ntab/sntabsize      = 4500 from 3000    
8. rsdb/ntab/irbdsize        = 9000  from 6000
9. zcsa/table_buffer_area = 45000000 from 30000000
10. rtbb/buffer_length       = 15000 from 10000
11. rsdb/ntab/entrycount = 30000 from 20000

now when user run a transaction the system stuck for a while and then execute it.

You can check the current status of ST02

Buffer SWAP

Nametab (NTAB) 0

Table definitio 37,023

Field definitio 21, 503

Short NTAB 0

Initial records 6,305

program 14,152

CUA 47,332

Screen 312

Calendar

OTR 0

Tables 0

Generic Key 39

Single record 4

Export/import 36,693

Exp./ Imp. SHM 0

Regards,

[markus_doehr2]

The number of workprocesses is not that relevant for swapping. ALL WPs attach to the same memory buffers.

You may need to increase them more if you still see swaps.

E. g. our abap/buffersize is 3,000,000 and even there occurs occasional swapping. If this is a Unicode system and many different programs are used then 512 MB for the program buffer may still be too less.

There is no formular to calculate this because each system is used differently. Tuning buffers is an iterative process, you may increase, check and increase more until you're satisfied with performance.

Markus

[Former Member]

Hello Jamil

Just increase the size of buffers by a big margin which are in red,this will help in improving the performance

Rohit

[former_member182034]

STO2 StatusSystem: DEVQAS_DEV_00 Tune summary

Date + Time of Snapshot: 05.06.2009 17:29:47 Startup: 03.06.2009 08:55:27

Buffer

HitRatio %

Alloc. KB

Freesp. KB

% Free Sp.

Dir. Size

FreeDirEnt

% Free Dir

Swaps

DB Accs

Nametab (NTAB)

0

Table definition

95,85

6.799

20.000

1.341.692

1.750.297

Field definition

95,83

31.563

8.427

28,09

20.000

13.682

68,41

690.429

697.825

Short NTAB

99,27

3.625

1.871

62,37

5.000

1.190

23,80

0

3.831

Initial records

73,84

6.625

4.018

66,97

5.000

303

6,06

306.360

311.206

0

program

72,69

300.000

1.132

0,39

75.000

67.969

90,63

732.729

2.224.962

CUA

97,19

3.000

328

13,34

1.500

1.383

92,20

176.277

5.549

Screen

96,54

4.297

9

0,22

2.000

1.581

79,05

2.834

9.744

Calendar

99,93

488

365

76,36

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

98,50

29.297

2.542

9,16

5.000

569

11,38

985

499.486

Single record

82,98

10.000

471

4,79

500

359

71,80

172

391.479

0

Export/import

68,57

4.096

331

9,81

2.000

1.130

56,50

202.578

Exp./ Imp. SHM

91,26

4.096

3.179

94,19

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,99

2.592

6.048

262.144

0

IDs

99,63

Page area

1,13

2.950

96.584

131.072

131.072

Statement

91,00

Extended memory

2,90

729.088

1.826.816

25.161.728

0

0,00

Heap memory

0

0

0

0

0,00

Call Stati

HitRatio %

ABAP/4 Req

ABAP Fails

DBTotCalls

AvTime[ms]

DBRowsAff.

Select single

90,05

4.696.725

836.510

351.994

0

3.860.215

Select

82,59

16.964.115

0

815.771

0

11.741.945

Insert

0,00

35.170

1.598

39.302

0

226.530

Update

0,00

15.252

7.933

18.947

0

12.524

Delete

0,00

27.722

22.117

33.445

0

108.091

Total

86,32

21.738.984

868.158

1.259.459

0

15.949.305

while profile parameter is:

System: DEVQAS_DEV_00 Profile Parameters for SAP Buffers

Date and Time: 05.06.2009 19:27:14

-

---

Buffer Name Comment

Profile Parameter Value Unit Comment

-

---

Program buffer PXA

abap/buffersize 300000 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 4400000 Byte Size of screen buffer

sap/bufdir_entries 2000 Max. number of buffered screens

-

---

|

Generic key table buffer TABL

zcsa/table_buffer_area 30000000 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 buffer

rsdb/esm/large_object_size 8192 Bytes Estimation for the size of the largest object

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

-

---

|

Table definition buffer TTAB

rsdb/ntab/entrycount 20000 Max. number of table definitions buffered

-

---

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

|

Field description buffer FTAB

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

rsdb/ntab/entrycount 20000 Max. number / 2 of table descriptions buffered

-

---

FTAB needs about 700 bytes per used entry

|

Initial record buffer IRBD

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

rsdb/ntab/entrycount 20000 Max. number / 2 of initial records buffered

-

---

IRBD needs about 300 bytes per used entry

|

Short nametab (NTAB) SNTAB

rsdb/ntab/sntabsize 3000 kB Size of short nametab

rsdb/ntab/entrycount 20000 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 EXTM

ztta/roll_area 3000000 Byte Roll area per workprocess (total)

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

ztta/short_area 3200000 Byte Short area per workprocess

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

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

rdisp/PG_LOCAL 150 8 kB Paging buffer per workprocess

em/initial_size_MB 24574 MB Initial size of extended memory

em/blocksize_KB 4096 kB Size of one extended memory block

em/address_space_MB 4096 MB Address space reserved for ext. mem. (NT only)

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

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

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

abap/heap_area_total 25767706624 Byte Max. usable heap memory

abap/heaplimit 40000000 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)

-

---

In order to change one of the above parameters...

1) Edit your system profile F:\usr\sap\DEV\SYS\profile\DEV_DVEBMGS00_DEVQAS

(You can use the buttons Profile Maintenance or @0Z@ Profile Parameter above)

2) Activate the parameter by restarting your local SAP system

plz now guide me which parameter i have to increase..

regards,

[Former Member]

Hello Jamil

It is very tough to read what you have pasted here

I would suggest you tell us the buffers which are in red in ST02 and their corresponding size of that buffer and value in red for that

Rohit

[former_member182034]

Hi Rohit,

 
System:                  DEVQAS_DEV_00             Tune summary
Date + Time of Snapshot: 05.06.2009    19:43:26    Startup:     05.06.2009 17:53:02

Nametab (NTAB)                         swap            DB Access
Table definition                            1.341.692     1.750.297
Field definition                             690.429         697.825
Initial records                               306.360        311.206

program                                      732.729         2.224.962
CUA                                           176.277         5.549
Screen                                        2.834   

Tables 
Generic Key                                 985               499.486  
// after system restart first of all this value went into red 
   after then other generating other swap 

Single record                                172               391.479
Export/import                                202.578 

now view is ok and plz guide me which parameter i have to set mean increase

FYI

I have two instance on 1 system mean DEV and QAS. In this time Users only working

on DEV server.

Regards,

majamil

Edited by: majamil on Jun 5, 2009 7:38 PM

[former_member182034]

there are adequate processess for the system while current parameters of Instance Profile are following :

Parameter Name               Parameter value
abap/fieldexit                             YES
rdisp/max_wprun_time                1800
login/no_automatic_user_sapstar   0  
login/system_client                      100
SAPSYSTEMNAME                     DEV    
SAPGLOBALHOST                      DEVQAS                          
SAPSYSTEM                              00
INSTANCE_NAME                       DVEBMGS00            
DIR_CT_RUN                               $(DIR_EXE_ROOT)\$(OS_UNICODE)\NTAMD64  
DIR_CT_RUN                               $(DIR_INSTANCE)\exe
rdisp/wp_no_dia                           10 
rdisp/wp_no_btc                           3  
icm/server_port_0                         PROT=HTTP,PORT=80$$ 
ms/server_port_0                          PROT=HTTP,PORT=81$$    
rdisp/wp_no_enq                           1
rdisp/wp_no_vb                             1
rdisp/wp_no_vb2                            1
rdisp/wp_no_spo                           1
DIR_CLIENT_ORAHOME               $(DIR_EXECUTABLE)

will i add the buffer parameter?

Regards.

[Former Member]

Yes Jamil

You need to add the profile parameters for these buffers

I would suggest you to increase the sizes of these buffers by a good amount

Refer to

http://help.sap.com/saphelp_nw04/helpdata/EN/c4/3a6f4e505211d189550000e829fbbd/content.htm

It will be of great help

Rohit

[former_member182034]

Hi Rohit,

Dear , i have sent you the current parameters of instance profile and there are not defined the following paramters:

PHYS_MEMSIZE   
rsdb/ntab/ftabsize 
rsdb/ntab/entrycount 
rsdb/ntab/irbdsize 
abap/buffersize

May I have to add above parameter in instance profile and please tell me what should be values of

above parameters? because i have sent you all information.

FYI

here only 20 users are working on DEV server and swap column also showing red.

Regards

[Former Member]

hi

dont add PHYS_MEMSIZE paramter

add the following parameters:

rsdb/ntab/ftabsize

rsdb/ntab/entrycount

rsdb/ntab/irbdsize

abap/buffersize

in the instance profile,I would recommend you to double thier values

Rohit

[former_member182034]

thanks for reply

dont add PHYS_MEMSIZE paramter

would you tell me why we don't need of this parameter because i did add this paramater in my last company but here when i try to put this paramater then i am getting The Parameter is not known while

I have read from some post about adding of this parameter... ok i m not adding this parameter.

I have checked the current value of parameters in RZ11 which are following:

rsdb/ntab/ftabsize       30000
rsdb/ntab/entrycount   20000
rsdb/ntab/irbdsize       30000
abap/buffersize           300000

Are these default values? and these parameter will be activate when we add in

instance profile. is it ok?

now i have to put the double value of above parameter in instance profile.

Regards,

[former_member182034]

Hi,

now speed is gud but still I am facing red swapping on DEV server after increased and edit the following parameters in Instance Profile.

1. update V1 work process = 3 from 1
2. Update V2 work process = 2 from 1 
2. abap/buffersize = 512000   from 300000
3. PHYS_MEMSIZE = 7168   from 24574   
4. zcsa/presentation_buffer_area = 6400000 from 4400000
5. rsdb/ntab/ftabsi =    35000 Current while  30000 Default Value
6. rsdb/ntab/entryco =   25000 Current while 20000 Default Value
7. b/ntab/irbdsize =  6500  Current while 6000 Default Value

DEV and QAS on same machine with 24GB. i did give 10GB(phys_memsize) to dev and rest for QAS

while 20 Users are working on DEV.

Regards,

majamil

[Former Member]

You may think of increasing abap/buffersize further as in DEV programs are constantly changed and need to be loaded frequently compared to QAS/DEV. BTW, where do you see more red's?