ECC6 performance problems !

[osman_sanverdi]

Hello,

i have problems with the performance of my SAP system.

I run

1 databaseserver with windows 2003, 24GB RAM

1 applikationserver with windows 2003,16 GB RAM, only dialog processes

2 applikationservers with windows 2003 ,6 GB RAM, only dialog processes

1 batchserver with batchprocesses and some dialogprocesses

all the servers are 64-bit.

Can someone help me?

[Former Member · Accepted solution]

hello,

i've another question : how do you do for dedicating an application server just to handle dialog process and no batch process?

regards

[osman_sanverdi · Accepted solution]

hello,

hm i just set the parameters in TR RZ10 instance profile of the batchserver

disp/wp_no_dia

rdisp/wp_no_btc

for the other applicationseerver i set only the parameter

disp/wp_no_dia

On my databaseserver i have only one batchprocess with class A for transports.

So i have only one server for batch and the other servers are not stressed with batch jobs.

I functioned very well.

best regards

[Former Member · Accepted solution]

thanks a lot Osman!

[Former Member]

Hey,

I think I manged to read the ST03 information,

if I'm correct, you had about 70M dialog transaction, in each application server,

the average response time is about 1 second.

The batch wp, have response time of about 2 seconds.

This looks like normal performance,

We need more information:

1. Can you send the information of st03 before the upgrade?

2. Use transaction stad,

and send us some example of bad user response times...

[former_member275057]

hello Osman,

What kind of performance problems you are experiencing? Are all the parameters confifured correctly? have you implemented zero memory management parameters on the windoes boxes?

Please provide some more information in terms of database, release and etc.

Regards,

Satyajit

[osman_sanverdi]

Hello Satyajit,

thank you for answersing. Yes i tried to use the zero management.

Performance problems in terms of e.g. that the GUI times are very long and if you start e.g. Project Info System ( TR CN47N )it takes a long time to get the applicationscreen.

And in other TR if you make some selections on the selectionsscreen it takes a long time too so backgroundjobs are running longer as they should do.

Most swaps i avoid with this settings.

I have SQL 2005 and ECC 6. The dimensions of our database is about 300 GB.

We run 64-bit Windows 2003 R2, 64-bit SQL and 64-bit ECC6.

I set following parameters on the applikationserver with 16 GB RAM:

ipc/shm_psize_40 8000000

rdisp/PG_MAXFS 65536

rsdb/ntab/entrycount 30000

rdisp/PG_SHM 65536

zcsa/db_max_buftab 10000

em/address_space_MB 8192

zcsa/table_buffer_area 80000000

rsdb/ntab/ftabsize 100000

rsdb/ntab/irbdsize 10000

rsdb/cua/buffersize 30000

zcsa/presentation_buffer_area 20000000

rtbb/buffer_length 20000

login/min_password_lng 8

rdisp/tm_max_no 500

rsdb/obj/large_object_size 32768

rsdb/obj/max_objects 20000

rsdb/obj/buffersize 40960

abap/buffersize 1200000

rdisp/max_wprun_time 1800

rdisp/gui_auto_logout 18000

rdisp/wp_no_dia 20

rdisp/wp_no_btc 0

On the applicationservers with 6 GB RAM following parameters are set:

ipc/shm_psize_40 8000000

rdisp/PG_MAXFS 65536

rsdb/obj/large_object_size 32768

rsdb/ntab/irbdsize 12000

rdisp/PG_SHM 65536

rsdb/obj/max_objects 20000

zcsa/db_max_buftab 10000

zcsa/table_buffer_area 100000000

rsdb/ntab/ftabsize 100000

rsdb/cua/buffersize 30000

zcsa/presentation_buffer_area 22000000

rtbb/buffer_length 20000

login/min_password_lng 8

rdisp/tm_max_no 500

rsdb/obj/buffersize 40960

abap/buffersize 1500000

zcsa/system_language D

rsdb/ntab/entrycount 30000

rdisp/max_wprun_time 1800

rdisp/gui_auto_logout 18000

rdisp/wp_no_dia 15

On the databasesever the following parameters are set:

rsdb/obj/buffersize 32768

rsdb/obj/max_objects 20000

rsdb/obj/large_object_size 16384

rdisp/tm_max_no 500

rtbb/buffer_length 12500

zcsa/presentation_buffer_area 15000000

rsdb/cua/buffersize 20000

rsdb/ntab/irbdsize 10000

rsdb/ntab/ftabsize 100000

zcsa/table_buffer_area 60000000

em/address_space_MB 8192

zcsa/db_max_buftab 10000

rdisp/PG_SHM 65536

rsdb/ntab/entrycount 30000

rdisp/PG_MAXFS 65536

abap/buffersize 1500000

rdisp/max_wprun_time 1800

rdisp/wp_no_dia 10

rdisp/wp_no_btc 8

disp/wp_no_enq 1

rdisp/wp_no_vb 6

rdisp/wp_no_vb2 3

rdisp/wp_no_spo 3

best regards

[former_member275057]

Hello Osman,

The R/3 parameters look to be ok..

Can you send me the response times from St03> expert analysis> wokload overview.

Regards,

Satyajit

[osman_sanverdi]

Hello,

so i think too.

DATABASESERVER

Task Type Name # Sequential Reads T Seq. Read Time Ø Seq. Read Time # Accesses T Time Ø Time # Changes T Changes Ø Changes # Calls Ø Time # Reads # DB Recs # Records # Calls T Time Ø Time

ALE 9.626 36 3,7 10.585 13 1,2 1.737 57 33,0 21.948 4,9 10.124 1.986 6.720 0 0,0 0,0

AUTOABAP 913.467 2.146 2,3 919.554 159 0,2 129.764 301 2,3 1.962.785 1,3 7.402.401 176.320 720.026 0 0,0 0,0

AUTOTH 1 0 13,0 11.791 7 0,6 5.842 6 1,0 17.634 0,7 5.880 5.842 0 0 0,0 0,0

BACKGROUND 2.137.016 2.646 1,2 1.503.485 423 0,3 125.845 588 4,7 3.766.346 1,0 3.596.697 163.137 937.008 0 0,0 0,0

BUFFER SYNC 7.656 23 3,0 1.368 5 3,6 496 1 1,4 9.520 3,0 76.335 496 0 0 0,0 0,0

DDLOG CLEANUP 0 0 0,0 2.736 9 3,1 1.149 6 5,4 3.885 3,8 1.368 1.147 0 0 0,0 0,0

DEL. THCALL 1 1 617,0 12.956 9 0,7 6.477 6 1,0 19.434 0,8 6.479 6.477 0 0 0,0 0,0

DIALOG 1.434 5 3,5 2.737 11 4,1 102 0 1,9 4.273 3,8 1.339 95 1.053 0 0,0 0,0

HTTP 492 15 31,2 933 17 17,8 0 0 0,0 1.425 22,4 751 0 66 0 0,0 0,0

RFC 8.780.370 50.312 5,7 9.351.402 3.159 0,3 1.436.630 2.351 1,6 19.568.402 2,9 7.159.356 1.477.243 5.424.222 0 0,0 0,0

RPCTH 21.515 114 5,3 46.798 98 2,1 430 14 32,6 68.743 3,3 40.900 17 336 0 0,0 0,0

SPOOL 404.213 148 0,4 3.029.127 1.513 0,5 763.431 797 1,0 4.196.771 0,6 1.051.634 763.431 114.621 0 0,0 0,0

UPDATE 11.315.351 23.966 2,1 10.714.157 8.880 0,8 4.627.200 33.160 7,2 26.656.708 2,5 8.228.676 7.226.326 7.061.694 0 0,0 0,0

UPDATE2 4.790.901 5.804 1,2 3.005.554 436 0,1 2.650.374 9.313 3,5 10.446.829 1,5 3.952.152 2.781.632 2.292.751 0 0,0 0,0

APPLICATIONSERVER WITH 16 GB RAM

Task Type Name # Sequential Reads T Seq. Read Time Ø Seq. Read Time # Accesses T Time Ø Time # Changes T Changes Ø Changes # Calls Ø Time # Reads # DB Recs # Records # Calls T Time Ø Time

AUTOABAP 6.913.601 830 0,1 1.730.529 110 0,1 93.340 197 2,1 8.737.470 0,1 2.461.075 129.036 1.402.418 0 0,0 0,0

AUTOTH 45 0 10,8 8.133 11 1,4 3.969 8 2,0 12.147 1,6 4.053 3.969 31 0 0,0 0,0

BACKGROUND 1.185.653 4.062 3,4 1.486.374 1.177 0,8 218.391 556 2,5 2.890.418 2,0 1.475.656 242.174 513.450 0 0,0 0,0

BUFFER SYNC 8.603 23 2,6 1.534 2 1,2 701 1 1,4 10.838 2,3 76.627 701 0 0 0,0 0,0

DDLOG CLEANUP 0 0 0,0 1.130 4 3,7 301 11 36,4 1.431 10,6 564 298 0 0 0,0 0,0

DEL. THCALL 0 0 0,0 2.568 4 1,7 1.284 3 2,0 3.852 1,8 1.284 1.284 0 0 0,0 0,0

DIALOG 80.568.565 169.285 2,1 129.074.987 26.798 0,2 1.039.381 3.174 3,1 210.682.933 0,9 128.218.839 1.165.174 81.081.514 0 0,0 0,0

HTTP 339 4 12,6 667 1 2,0 6 0 3,0 1.012 5,6 535 0 27 0 0,0 0,0

OTHER 4.908 843 171,9 108 0 0,3 7 0 0,9 5.023 167,9 233.664 7 62 0 0,0 0,0

RFC 48.920.049 26.439 0,5 59.094.506 8.498 0,1 327.937 1.315 4,0 108.342.492 0,3 19.143.687 1.971.387 43.235.210 0 0,0 0,0

RPCTH 89.016 509 5,7 189.483 554 2,9 2.872 131 45,8 281.371 4,2 172.871 905 12.321 0 0,0 0,0

APPLICATIONSERVER WITH 6GB RAM

Task Type Name # Sequential Reads T Seq. Read Time Ø Seq. Read Time # Accesses T Time Ø Time # Changes T Changes Ø Changes # Calls Ø Time # Reads # DB Recs # Records # Calls T Time Ø Time

AUTOABAP 567.418 334 0,6 570.380 82 0,1 59.314 149 2,5 1.197.112 0,5 1.749.986 80.082 457.344 0 0,0 0,0

AUTOTH 43 0 4,7 3.753 5 1,3 1.778 4 2,0 5.574 1,6 2.057 1.778 27 0 0,0 0,0

BACKGROUND 10.300.944 9.275 0,9 3.660.923 720 0,2 228.498 449 2,0 14.190.365 0,7 1.607.081 254.460 557.256 0 0,0 0,0

BUFFER SYNC 8.677 26 3,0 866 1 1,3 279 1 1,9 9.822 2,8 76.687 279 0 0 0,0 0,0

DDLOG CLEANUP 0 0 0,0 1.320 3 2,3 367 11 30,1 1.687 8,4 660 363 0 0 0,0 0,0

DEL. THCALL 2 0 13,5 1.566 2 1,4 781 1 1,7 2.349 1,5 785 781 0 0 0,0 0,0

DIALOG 55.428.562 114.893 2,1 89.701.021 16.891 0,2 659.230 2.110 3,2 145.788.813 0,9 72.869.899 700.357 58.328.594 0 0,0 0,0

HTTP 833 6 7,7 1.633 28 17,4 0 0 0,0 2.466 14,1 1.302 0 114 0 0,0 0,0

OTHER 5.145 450 87,4 242 1 3,8 0 0 0,0 5.387 83,7 233.791 0 162 0 0,0 0,0

RFC 29.817.482 12.297 0,4 41.189.072 5.491 0,1 219.246 711 3,2 71.225.800 0,3 10.513.582 249.343 30.967.672 0 0,0 0,0

RPCTH 50.167 278 5,5 110.663 358 3,2 1.627 74 45,6 162.457 4,4 97.642 414 8.107 0 0,0 0,0

APPLICATIONSERVER 6 GB RAM

Task Type Name # Sequential Reads T Seq. Read Time Ø Seq. Read Time # Accesses T Time Ø Time # Changes T Changes Ø Changes # Calls Ø Time # Reads # DB Recs # Records # Calls

AUTOABAP 572.249 322 0,6 573.669 72 0,1 59.500 103 1,7 1.205.418 0,4 1.757.971 80.648 456.281 0

AUTOTH 86 0 1,7 13.196 8 0,6 6.478 6 0,9 19.760 0,7 6.905 6.478 42 0

BACKGROUND 35.937.293 26.832 0,7 20.434.749 3.597 0,2 1.434.140 1.462 1,0 57.806.182 0,6 20.895.385 1.469.851 6.372.096 0

BUFFER SYNC 8.665 27 3,1 1.290 3 2,1 515 1 1,3 10.470 2,9 76.106 515 0 0

DDLOG CLEANUP 0 0 0,0 1.172 3 2,4 309 36 117,3 1.481 26,4 586 303 0 0

DEL. THCALL 2 0 14,5 4.744 3 0,6 2.370 2 1,0 7.116 0,8 2.374 2.370 0 0

DIALOG 78.333.401 110.508 1,4 97.386.272 16.753 0,2 1.162.543 2.917 2,5 176.882.216 0,7 103.267.350 1.524.356 58.681.570 0

HTTP 968 8 8,0 1.975 49 24,6 0 0 0,0 2.943 19,1 1.622 0 127 0

OTHER 25.400 2.263 89,1 6.915 1 0,1 0 0 0,0 32.315 70,0 809.350 0 4.862 0

RFC 24.592.431 13.152 0,5 33.162.607 5.103 0,2 199.444 828 4,2 57.954.482 0,3 10.507.492 1.016.907 24.230.314 0

RPCTH 61.668 323 5,2 131.774 303 2,3 2.602 107 41,1 196.044 3,7 117.492 1.098 8.157 0

On this servers i haven't got batchprocesses. For batchprocesses i have another server with only batchprocessing.

best regards and thanks

[former_member275057]

Hello Osman,

Thanks for providing the information. However its very difficult to understand it!

Did you hreceive any SAP EarlyWatch service for this system? This is a part of AMC and free service. Or Open a customer message in component SV-BO so that once of the SAP can have a look into system in much details and help you to negete the performance issues.

Hope this helps,

Regards,

Satyajit

[osman_sanverdi]

hello,

yes i have a solution manager system where i monitore my systems and earlywatch.

I think i will take the service fromn SAP.

best regards