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

  • 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