Performance Tuning for ECC 6.0

[Former Member]

Hi All,

I have an ECC 6.0EP 7.0(ABAPJAVA). My system is very slow. I have Oracle 10.2.0.1.

Can you please guide me how to do these steps in the sytem

1) Reorganization should be done at least for the top 10 huge tables

and their indexes

2) Unaccessed data can be taken out by SAP Archiving

3)Apply the relevant corrections for top sap standard objects

4) CBO update statistics must be latest for all SAP and customer objects

I have never done performance tuning and want to do it on this system.

Regards,

Jitender

[Former Member · Accepted solution]

Hi

Performance tuning is quite simple in theory:

A - determine why the system is slow (hardware to small, bad configuration, unefficient application)

B - try to fix it

C - test if your problem is gone, if not then go back to A or B

Specifically to your input: 10.2.0.1 is not a supported release, i suggest considering to upgrade to 10.2.0.4.

1. as long as you don't delete large amounts of a table reorganisation will not improve performance

2. ok, but archiving data usually puts quite a load on a system too

3. just applying patches might help, but without knowing why the system is slow, your chances are small

4. yes, but stats don't have to be new, they have to be correct, so if the data does not change your stats are still perfect after years

I suggest you start to dig a bit and look out for specific performance issues. Tell what is slow, and we can give you specific hints.

Best regards, MIchael

[Former Member · Accepted solution]

Hi,

Below are the details of ST06. Please suggest me what should I do. the system performance is very bad.

I require your inputs for performance tuning

CPU

Utilization user % 3 Count 2

system % 3 Load average 1min 0.11

idle % 1 5 min 0.21

io wait % 93 15 min 0.22

System calls/s 982 Context switches/s 1752

Interrupts/s 4528

Memory

Physical mem avail Kb 6291456 Physical mem free Kb 93992

Pages in/s 473 Kb paged in/s 3784

Pages out/s 211 Kb paged out/s 1688

Pool

Configured swap Kb 26869896 Maximum swap-space Kb 26869896

Free in swap-space Kb 21631032 Actual swap-space Kb 26869896

Disk with highest response time

Name md3 Response time ms 51

Utilization 2 Queue 0

Avg wait time ms 0 Avg service time ms 51

Kb transfered/s 2 Operations/s 0

Current parameters in the system

System: sapretail_RET_01 Profile Parameters for SAP Buffers

Date and Time: 08.01.2009 13:27:54

-

---

Buffer Name Comment

Profile Parameter Value Unit Comment

-

---

Program buffer PXA

abap/buffersize 450000 kB Size of program buffer

abap/pxa shared Program buffer mode

-

---

|

CUA buffer CUA

rsdb/cua/buffersize 3000 kB Size of CUA buffer

-

---

The number of max. buffered CUA objects is always: size / (2 kB)

|

Screen buffer PRES

zcsa/presentation_buffer_area 4400000 Byte Size of screen buffer

sap/bufdir_entries 2000 Max. number of buffered screens

-

---

|

Generic key table buffer TABL

zcsa/table_buffer_area 30000000 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 10000 kB Size of single record table buffer

rtbb/max_tables 500 Max. number of buffered tables

-

---

|

Export/import buffer EIBUF

rsdb/obj/buffersize 4096 kB Size of export/import buffer

rsdb/obj/max_objects 2000 Max. number of objects in the buffer

rsdb/obj/large_object_size 8192 Bytes Estimation for the size of the largest object

rsdb/obj/mutex_n 0 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 20000 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 30000 kB Size of field description buffer

rsdb/ntab/entrycount 20000 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 20000 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 20000 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 3000000 Byte Roll area per workprocess (total)

ztta/roll_first 1 Byte First amount of roll area used in a dialog WP

ztta/short_area 3200000 Byte Short area per workprocess

rdisp/ROLL_SHM 16384 8 kB Part of roll file in shared memory

rdisp/PG_SHM 8192 8 kB Part of paging file in shared memory

rdisp/PG_LOCAL 150 8 kB Paging buffer per workprocess

em/initial_size_MB 4092 MB Initial size of extended memory

em/blocksize_KB 4096 kB Size of one extended memory block

em/address_space_MB 4092 MB Address space reserved for ext. mem. (NT only)

ztta/roll_extension 2000000000 Byte Max. extended mem. per session (external mode)

abap/heap_area_dia 2000000000 Byte Max. heap memory for dialog workprocesses

abap/heap_area_nondia 2000000000 Byte Max. heap memory for non-dialog workprocesses

abap/heap_area_total 2000000000 Byte Max. usable heap memory

abap/heaplimit 40000000 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)

-

---

Regards,

Jitender

[Former Member]

thanks

[JPReyes]

I have Oracle 10.2.0.1.

Agree with Michael, you need to upgrade at least to 10.2.0.2 or to 10.2.0.4 in the best case scenario.

Regards

Juan

[Former Member]

Hi Juan,

Do you think there is memory bottle neck in the system. See the I/O wait % and Idle %.

More background on the server

Two instance are there (sharing the same hardware)

1) ECC+ EP 7.0 (EP is installaed as add-on on top of ECC), Oracle 10.2.0.1

2) SCM 5.0+ BI 7.0 (BI is installed as add-on on top of SCM), 10.2.0.2

Server details

sun v240 2 CPU (1.5 GHz)

RAM- 6 GB (Earlier 8 GB was there, but suddenly 2 GB RAM stopped functioning)

Both the Instance are slow. The SCM 5.0 which has 10.2.0.2 is also slow.

I believe i have to change some memory parameters

Please suggest

Regards,

Jitender

[JPReyes]

Two instance are there (sharing the same hardware) 
1) ECC+ EP 7.0 (EP is installaed as add-on on top of ECC), Oracle 10.2.0.1
2) SCM 5.0+ BI 7.0 (BI is installed as add-on on top of SCM), 10.2.0.2

So you have ECCEPSCM+BI in a single box with 2 processors and 6Gb of RAM?...

WOW... how did you managed to get them all running?... I think this is far too much for a small box like that.

You need to think on getting at least one more box... but first check the SAP quicksizer in order to get an idea of what sort of hardware you should be aiming for.

http://service.sap.com/quicksizer

I think your main issue here is memory and even to you might be able to twick a bit the parameters I can't see it impoving much with the huge load.

Regards

Juan

[Former Member]

Hi,

>but suddenly 2 GB RAM stopped functioning

And what did you do ?

If you have tons of SAP software on a single server with a hardware problem and very limited memory, it is no surprise that you get very bad performance....

Regards,

Olivier

[Former Member]

Thanks Juan & Thanks Oliver,

The system performance started detoriating steadly from the last couple of months. but we don't know the timing when the 2 GB stopped functioning. Just 1 month back we found out that 6 GB is currently functioning.

So didn't wanted to blame everything on the 2 GB RAM. There were number of new solution deployed on the system with number of trainees working. So can't single out the exact reason.

Thanks, but my manager gets very annoyed when I talk about the 2 GB RAM and wants me to do performance tuning on the system.

Thanks a lot for your input. Believe 2 Gb should solve the problem and restore the system back to its initial performance.

Regards,

Jitender

[JPReyes]

If you are planning to keep all those system in that box... don't buy just 2Gigs... I will be aiming to fill all the banks.

Also if your question is been answered please close the thread.

Regards

Juan