SAP Help Site


RE: [sap-basis] Performance issue problem in ECC 6.0

Posted by D. Caddick
on 08/10/2008 10:55:00 PM


Hi,

You have not informed us on the OS and Database.

You should try to aim the Buffer HitRatio at 96% or above.
How much Swap space is configured?
How many CPUs and how are they being used?

Have you configured EarlyWatch Alert reports and do they report problems?

Regards

From: rohitk_2007 via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 10 August 2008 05:15
To: D. Caddick
Subject: [sap-basis] Performance issue problem in ECC 6.0

I am just starting to work on Ecc 6.0 in my new company ,we are daily facing
lot off performance issues. I am not sure these paramtters settings are
correct.
please check the screenshots to wheather these paramtetes really affecting
the performance .
We have 75 user licenses almost all are working concurrently .
RAM is 4 GB .
—————————————————————————-
—————————————-
|Buffer |HitRatio %|Alloc. KB|Freesp. KB|% Free Sp.|Dir. Size|FreeDirEnt|%
Free Dir| Swaps| DB Accs|
—————————————————————————-
——————————————
|Nametab (NTAB) | | | | | | | | 0 | |
| Table definition| 99,63 | 7.912 | 746 | 10,47 | 25.000 | 2.618 | 10,47 | 0
| 105.135 |
| Field definition| 98,98 | 61.074 | 2.579 | 4,30 | 25.000 | 16.365 | 65,46
| 212.604 | 221.798 |
| Short NTAB | 99,81 | 3.415 | 2.719 | 90,63 | 6.250 | 5.419 | 86,70 | 0 |
831 |
| Initial records | 74,23 | 6.415 | 4.528 | 75,47 | 6.250 | 211 | 3,38 |
911.408 | 917.447 |
| | | | | | | | | 0 | |
|program | 91,48 | 300.000 | 737 | 0,25 | 75.000 | 67.949 | 90,60 |5.378.857
|16.168.413 |
|CUA | 99,27 | 10.000 | 612 | 7,32 | 5.000 | 4.515 | 90,30 | 193.254 | 7.699
|
|Screen | 99,44 | 19.531 | 4.980 | 25,77 | 2.000 | 1.420 | 71,00 | 7 |
21.451 |
|Calendar | 100,00 | 488 | 366 | 76,57 | 200 | 50 | 25,00 | 0 | 150 |
|OTR | 100,00 | 4.096 | 3.439 | 100,00 | 2.000 | 2.000 | 100,00 | 0 | |
| | | | | | | | | 0 | |
|Tables | | | | | | | | 0 | |
| Generic Key | 99,90 | 97.656 | 23.684 | 24,60 | 5.000 | 376 | 7,52 | 521 |
266.335 |
| Single record | 97,64 | 12.000 | 60 | 0,51 | 1.000 | 946 | 94,60 | 3.201 |
456.493 |
| | | | | | | | | 0 | |
|Export/import | 91,39 | 40.000 | 7.909 | 22,43 | 20.000 | 11.182 | 55,91 |
531.051 | |
|Exp./ Imp. SHM | 91,99 | 4.096 | 3.248 | 94,45 | 2.000 | 1.999 | 99,95 | 0
| |
—————————————————————————-
——————————————
—————————————————————————-
——————
|SAP Memory |Curr.Use %|CurUse[KB]|MaxUse[KB]|In
Mem[KB]|OnDisk[KB]|SAPCurCach|HitRatio %|
—————————————————————————-
——————
|Roll area | 18,55 | 11.209 | 17.144 | 60.416 | 0 | IDs | 100,00 |
|Page area | 10,75 | 28.169 | 94.856 | 32.768 | 229.376 | Statement| 100,00
|
|Extended memory| 48,93 | 769.024 |1.409.024 |1.571.840 | 0 | | 0,00 |
|Heap memory | | 0 | 0 | 32.297 | 0 | | 0,00 |
—————————————————————————-
——————
—————————————————————————-
———–
|Call Stati |HitRatio %| ABAP/4 Req| ABAP Fails| DBTotCalls|AvTime[ms]|
DBRowsAff.|
—————————————————————————-
———–
| Select single| 97,39 | 72.893.592 | 9.998.185 | 457.835 | 0 |62.895.407 |
| Select | 92,05 | 77.831.044 | 0 |14.067.711 | 0 |12.988.067 |
| Insert | 0,00 | 30.374 | 12.215 | 61.141 | 0 | 422.237 |
| Update | 0,00 | 29.443 | 6.546 | 55.362 | 0 | 27.764 |
| Delete | 0,00 | 7.599 | 2.706 | 15.140 | 0 | 7.948 |
| Total | 94,72 |150.792.052 |10.019.652 |14.657.189 | 0 |76.341.423 |
————————————————————————–
CURRENT PARAMETERS
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 10000 kB Size of CUA buffer |
—————————————————————————-
——————-
The number of max. buffered CUA objects is always: size / (2 kB)
|
|Screen buffer PRES |
|zcsa/presentation_buffer_area 20000000 Byte Size of screen buffer |
|sap/bufdir_entries 2000 Max. number of buffered screens |
—————————————————————————-
——————|
|Generic key table buffer TABL |
|zcsa/table_buffer_area 100000000 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 12000 kB Size of single record table buffer |
|rtbb/max_tables 1000 Max. number of buffered tables |
—————————————————————————-
——————|
|Export/import buffer EIBUF |
|rsdb/obj/buffersize 40000 kB Size of export/import buffer |
|rsdb/obj/max_objects 20000 Max. number of objects in the buffer |
|rsdb/obj/large_object_size 10000 Bytes Estimation for the size of the
largest object |
|rsdb/obj/mutex_n 1000 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 25000 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 60000 kB Size of field description buffer |
|rsdb/ntab/entrycount 25000 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 25000 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 25000 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 6500000 Byte Roll area per workprocess (total) |
|ztta/roll_first 1024 Byte First amount of roll area used in a dialog WP |
|ztta/short_area 3200000 Byte Short area per workprocess |
|rdisp/ROLL_SHM 7552 8 kB Part of roll file in shared memory |
|rdisp/PG_SHM 4096 8 kB Part of paging file in shared memory |
|rdisp/PG_LOCAL 150 8 kB Paging buffer per workprocess |
|em/initial_size_MB 512 MB Initial size of extended memory |
|em/blocksize_KB 1024 kB Size of one extended memory block |
|em/address_space_MB 512 MB Address space reserved for ext. mem. (NT only)|
|ztta/roll_extension 2000683008 Byte Max. extended mem. per session
(external mode)|
|abap/heap_area_dia 2000683008 Byte Max. heap memory for dialog
workprocesses |
|abap/heap_area_nondia 2000683008 Byte Max. heap memory for non-dialog
workprocesses |
|abap/heap_area_total 2000683008 Byte Max. usable heap memory |
|abap/heaplimit 40894464 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) |
—————————————————————————-
——————-
__.____._

Copyright © 2008 ITtoolbox and message author.
No redistribution.


Leave a Comment so far
Leave a comment



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s



%d bloggers like this: