Skip to Content
author's profile photo Former Member
Former Member

bad performance on prod system

Hi all,

I have performance problems, I found this information by SAPPFFAR

Shared memory resource requirements estimated

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

Total Nr of shared segments required.....: 30

System-imposed number of shared memories.: 200

Shared memory segment size required min..: 1638400100 (1562.5 MB)

System-imposed maximum segment size......: 39191576576 (37376.0 MB)

Swap space requirements estimated

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

Shared memory....................: 4483.3 MB

..in pool 10 112.0 MB, 96% used

..in pool 40 148.1 MB, 64% used

..not in pool: 4216.3 MB

Processes........................: 794.2 MB

Extended Memory .................: 16024.0 MB

Total, minimum requirement.......: 21301.5 MB

Process local heaps, worst case..: 2861.7 MB

Total, worst case requirement....: 24163.2 MB

Errors detected..................: 0

Warnings detected................: 7

And information with ST02 :

Buffer Hitratio Allocated Free space Dir. size Free directory Swaps Database

[%] [kB] [kB] [%] Entries Entries [%] accesses

Nametab (NTAB)

Table definition 99,87 9.300 4.506 62,93 39.000 24.544 62,93 0 112.529

Field description 99,96 53.547 8.887 17,60 39.000 25.212 64,65 0 15.753

Short NTAB 99,96 4.219 2.310 77,00 9.750 6.811 69,86 0 2.939

Initial records 99,95 13.719 9.868 78,94 9.750 909 9,32 4.496 13.350

Program 99,97 600.000 1.884 0,34 150.000 134.134 89,42 28.975 150.417

CUA 99,97 10.000 2.675 31,14 5.000 3.514 70,28 0 1.526

Screen 99,96 25.392 2.692 10,85 10.000 8.666 86,66 0 2.406

Calendar 99,99 488 368 76,67 200 51 25,50 0 149

OTR 100,00 4.096 3.530 100,00 2.000 2.000 100,00 0 0

Tables

Generic key 99,96 63.477 22.188 36,71 13.000 712 5,48 265 456.589

Single record 98,62 30.000 16.481 55,50 1.000 887 88,70 327 1.409.345

Export/import 90,28 32.000 2.214 8,40 20.000 5.431 27,16 343.183 0

Exp./Imp. SHM 96,30 4.096 3.480 98,58 2.000 1.998 99,90 0 0

SAP memory Current use Max. use In memory On disk SAP cursor cache Hitratio

[%] [kB] [kB] [kB] [kB] [%]

Roll area 2,77 55.373 89.280 1.600.000 400.000 IDs 99,24

Paging area 3,37 67.373 104.568 1.600.000 400.000 Statements 97,00

Extended Memory 45,40 7.446.528 11911.168 16400.384 Heap Memory 345.019 2.930.291

Call statistics Hitratio ABAP/4 Processor Database 1971 tables buffered [%] Requests Fails Total calls AvgTime[ms] Rows affected

Select single 98,98 405894.932 151650162 992.701 0,000 254.244.770 Select 83,39 543938.440 0 3.064.443 0,000 27.494.565 Insert 50.452 9.437 52.871 0,000 150.936 Update 106.671 2.542 109.592 0,000 104.129 Delete 19.138 14.516 22.965 0,000 111.214

Total 91,19 950009.633 151676657 4.242.572 282.105.614



Any idea,

Thx

AH

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 17, 2013 at 09:05 AM

    Hi

    can you describe better what you mean with perf issue?

    sm50/1 , sm21 and st22 are not saying anything interesting?

    Let me know

    a

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 17, 2013 at 09:13 AM

    Hi Hsaini,

    Reading your sappfpar these are only warnings not errors.

    Errors detected..................: 0

    Warnings detected................: 7

    As andrea said we need more information, i.e. which OS are you using linux/windows? if linux or unix run command top command to monitor memory cpu and I/O usage.

    And to see memory available run command

    free -m

    As for more information not sure what database you are using when was the last time a database statistics run was done on your system?

    Looking at your hit rations from ST02 they are all above 90% which is good please provide us with more information. What performance are the users complaining of if any? Also checked your earlwatch alert report for any indicators perhaps?

    Kind Regards,

    Johan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 17, 2013 at 09:37 AM

    Hi,

    Os HPUX 11.11i

    Information with OS07 :

    CPU

    Utilization user % 15 Count 26

    system % 4 Load average 1 min 0,18

    idle % 50 5 min 0,18

    io wait % 31 15 min 0,17

    System calls/s 80.434 Context switches/s 18.686

    Interrupts/s 15.205

    Memory

    Physical mem avail Kb 62.829.568 Physical mem free Kb 16.751.316

    Pages in/s 0 Kb paged in/s 0

    Pages out/s 0 Kb paged out/s 0

    Swap

    Configured swap Kb 62.668.800 Maximum swap-space Kb 111.744.124

    Free in swap-space Kb 62.851.812 Actual swap-space Kb 111.744.124

    Disk with highest response time

    Name c1t0d0 Response time ms 16

    Utilization 0 Queue 0

    Avg wait time ms 1 Avg service time ms 15

    Kb transfered/s 5 Operations/s 1

    Informations with top:

    Pid Username Command CPU Util CPU Time Resident Prior. [%] [s] size [kB]

    18.702 p11adm dw.sapP11_DVEBMGS00 99,90 81:16 146.896 241 21.286 p11adm dw.sapP11_DVEBMGS00 98,54 68:50 190.064 241 1.297 p11adm dw.sapP11_DVEBMGS00 88,54 407:30 658.716 241 18.157 orap11 oracleP11 (DESCRIPT 53,88 18:52 5.460 154 18.155 p11adm dw.sapP11_DVEBMGS00 51,84 19:06 80.756 154 21.508 orap11 oracleP11 (DESCRIPT 15,14 46:06 6.484 148 1.328 orap11 oracleP11 (DESCRIPT 14,75 20:28 6.420 148 17.181 orap11 oracleP11 (DESCRIPT 9,80 35:33 7.572 148 3.302 root guard_stap /guardiu 9,02 1946:15 9.140 154 13.672 p11adm dw.sapP11_DVEBMGS00 7,37 46:13 80.340 155 10.098 p11adm dw.sapP11_DVEBMGS00 6,11 0:18 76.516 155 1.299 orap11 oracleP11 (DESCRIPT 5,92 45:44 4.372 154 22.375 orap11 oracleP11 (DESCRIPT 5,63 16:16 6.292 154 5.834 orap11 tnslsnr LISTENER -i 5,04 844:25 3.560 154 17.909 orap11 oracleP11 (DESCRIPT 4,66 42:47 6.420 148 17.875 p11adm dw.sapP11_DVEBMGS00 4,17 76:48 224.336 155 494 orap11 oracleP11 (DESCRIPT 3,88 35:45 7.508 148 2.262 root midaemon 3,49 614:43 82.668 16- 17.894 orap11 oracleP11 (DESCRIPT 3,30 61:47 7.572 148 24.147 orap11 oracleP11 (DESCRIPT 3,30 10:59 7.572 148 13.677 orap11 oracleP11 (DESCRIPT 2,91 44:46 6.548 154 17.757 p11adm dw.sapP11_DVEBMGS00 2,81 63:16 51.468 154 28.588 orap11 oracleP11 (DESCRIPT 2,71 27:57 15.700 148 22.373 p11adm dw.sapP11_DVEBMGS00 2,23 17:33 237.920 155 3.616 orap11 oracleP11 (DESCRIPT 1,74 7:32 7.508 148 61 root vxfsd 1,55 638:24 7.296 152 4.433 p11adm saposcol 1,06 261:46 6.176 178 7.398 p11adm dw.sapP11_DVEBMGS00 0,97 18:28 143.648 155 10.100 orap11 oracleP11 (DESCRIPT 0,87 0:07 5.460 154 3.614 p11adm dw.sapP11_DVEBMGS00 0,58 5:23 105.580 154 17.649 p11adm ora_lgwr_P11 0,58 40:40 18.052 156 1.893 root /usr/sbin/pwgrd 0,48 127:55 380 154 18.042 p11adm dw.sapP11_DVEBMGS00 0,48 0:18 60.972 155 2.332 root /opt/perf/bin/perfd 0,48 109:28 10.104 152 18.066 orap11 oracleP11 (DESCRIPT 0,29 0:04 4.436 154 3.297 root /sbin/krsd -i 0,29 92:24 104 138 0 root swapper 0,29 42:52 0 127 3.334 root java -da -Dtw.home= 0,19 28:26 49.196 152 3.239 root opcmona 0,19 119:19 9.552 152 17.766 p11adm gwrd -dp pf=/usr/sa 0,19 26:21 9.480 154
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 17, 2013 at 09:41 AM

    There can be many reasons for performance issue.

    You need to first figure out at which level the issue is.

    For that check at every level - SAP application (System logs, Work processes, Dumps, Buffers), Database (alert Log), OS (swap, FS, RAM, CPU)

    Network bottleneck.

    After figuring out which of these 4 area has issues you can investigate further.

    Regards

    Hussain S

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 17, 2013 at 10:23 AM

    Hi Hsaini,

    Seems to me your CPU usage for the 3 processes are very high.

    PidUsernameCommand CPU Util CPU Time Resident Prior. [%][s] size [kB]

    18.702 p11adm dw.sapP11_DVEBMGS00 99,9081:16146.89624121.286 p11adm dw.sapP11_DVEBMGS00 98,5468:50190.064241 1.297 p11adm dw.sapP11_DVEBMGS00 88,54 407:30

    Can you see which users or reports are long running are matching the times in bold?

    Please advise i.e sm50/sm66

    Regards,

    Johan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 22, 2013 at 09:43 AM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.