Skip to Content
avatar image
Former Member

SAP NW ABAP performance advice required

Hello experts,

I have just installed ECC6 with EHP6 on RHEL 6.3 with oracle 11.2.0.3.0 based on NW7.0 including EHP3 as a development environment.

SPs stack level 5

Kernel 720_Ext_UC_X86_64 patch level 401

RAM is 8 GB, and swap memory is 8 GB.

About 40 -50 concurrent users will use my dev system at the max.

Since my system is new, and no one is used it yet. Now I have few questions for optimal performance:

  1. No of work processes come by its own when I installed system, i.e Dia 10, BTC 3, Enq 1, spo 1 upd 1 upd2 1. My question is as per above information, how many work process I can assign now to satisfy the needs, so that users will not experience any issue in coming days?
  1. What memory related profile parameters I should keep/create in default and instance profile to make my system healthy? Please specify value as per above information mentioned.

  1. What other relevant profile parameters, I should have and in which profile? My system is just new and I have not added any parameters other than what is given during installation by its own.
  1. In ST02 I see, swaps are very high since I ran sgen, I am doubting when nobody is using the system the swaps are so high, and what will happen when users actually hit my system. Can anyone advice do I need to increase swap memory or do I neet increase or create certain parameter as in ST06 swap memory is just 4% free.

Tune summary

Buffer

HitRatio %

  1. Alloc. KB
  2. Freesp. KB

% Free Sp.

  1. Dir. Size

FreeDirEnt

% Free Dir

Swaps

DB Accs

Nametab (NTAB)

0

Table definition

94,89

6.735

20.000

  1. 1.103.102
  2. 1.651.531

Field definition

94,89

31.562

3.935

13,12

20.000

10.385

51,93

583.321

594.045

Short NTAB

99,91

3.625

2.810

93,67

5.000

4.386

87,72

0

614

Initial records

80,65

6.625

3.649

60,82

5.000

1.929

38,58

175.071

178.142

0

program

78,48

400.000

226

0,06

100.000

85.654

85,65

351.591

  1. 1.098.033

CUA

99,51

3.000

422

17,59

1.500

1.365

91,00

1.555

574

Screen

99,72

4.297

3.653

89,25

2.000

1.920

96,00

140

1.165

Calendar

100,00

488

26

5,44

200

24

12,00

0

176

OTR

4.096

3.297

100,00

2.000

2.000

100,00

0

0

Tables

0

Generic Key

97,78

29.297

4.188

14,85

5.000

272

5,44

214

245.982

Single record

88,12

10.000

1.752

17,75

500

449

89,80

78

246.300

0

Export/import

97,83

4.096

1.443

43,77

2.000

1.319

65,95

0

  1. Exp./ Imp. SHM

4.096

3.297

100,00

2.000

2.000

100,00

0

SAP Memory

  1. Curr.Use %

CurUse[KB]

MaxUse[KB]

In Mem[KB]

OnDisk[KB]

S

APCurCach

H

itRatio %

Roll area

0,05

528

20.664

262.144

786.432

IDs

99,96

Page area

0,04

368

32.512

262.144

786.432

Statement

99,00

Extended memory

3,71

155.648

634.880

  1. 4.190.208

0

0,00

Heap memory

0

204.460

0

0

0,00

Call Stati

H

itRatio %

A

BAP/4 Req

A

BAP Fails

D

BTotCalls

A

vTime[ms]

D

  1. BRowsAff.

Select single

97,44

  1. 2.890.887

338.814

64.951

0

  1. 2.552.073

Select

86,37

  1. 3.863.029

0

534.714

0

  1. 5.455.063

Insert

0,00

24.669

9.212

24.778

0

17.826

Update

0,00

71

1

125

0

70

Delete

0,00

2.246

607

2.511

0

3.432

Total

91,91

  1. 6.780.902

348.634

627.079

0

  1. 8.028.464

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 11, 2013 at 07:01 PM

    Hello Friends,

    Would you please reply of my above posts? Looking for some expert advice.

    Thanks - vicks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 13, 2013 at 11:47 AM

    Hi Vicks,

    A couple of pointers:

    Increase your program buffer to 1GB

    Double the size of the Table Definition buffer - you don't want SAP going to the DB to get schema information.

    Double the size of the Initial Record buffer.

    The rule of thumb for users is 6-8 per WP but as it's a DEV system, 1 developer debugging can tie up a wp.

    Check the notes for Swap size on Unix as you may need to increase it.

    What DB are you running and does it reside on the same server? If so, the database buffer param's will likely need increasing from the delivered ones.

    Hope this helps,

    Graham

    Add comment
    10|10000 characters needed characters exceeded