Poor Performance

[Former Member]

Hi All,

We have DEV and QAS on one server. Now the performance of the system is poor.

Given below is the stats of ST02.

Nametab (NTAB)

Table definition 99,15 4.768 811 22,09

Field description 99,45 31.563 3.665 12,22

Short NTAB 99,56 3.625 2.362 78,73

Initial records 98,14 6.625 222 3,70

Program 99,26 500.000 1.994 0,41 1

CUA 99,77 12.000 3.905 38,23

Screen 99,70 30.000 12.569 42,06

Calendar 100,00 488 408 85,36

OTR 86,67 4.096 3.500 100,00

Tables

Generic key 99,63 80.000 47.863 60,69

Single record 96,31 20.000 3.133 15,78

Export/import 67,19 50.000 45.799 92,70

Exp./Imp. SHM 0,00 4.096 3.500 100,00

SAP memory Current use Max. use In memory On disk

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

Roll area 0,12 325 11.704 131.072 131.072

Paging area 0,03 67 53.360 65.536 196.608

Extended Memory 4,94 151.552 1.548.288 3.067.904

Heap Memory 0 117.489

Pls help me to tune the performance of the system.

Regards,

Kris

Edited by: raama krishna on Mar 18, 2008 10:21 PM

[Former Member]

It depends on your server. what the server capacity and configuration?

Did you check if you are using to much memory, i.e., more than you have configured?

In my case I have for instance one server running 3 or 4 SAP and ORACLE instances and both are running fine. I advise you to restrict DB memory allocation and to start the databases first to avoid swap allocation by tge database engine.

FF

[Former Member]

Hi,

provide the result of WRKSHRPOOL

login through telnet with qsecofr and execute wrkshrpool

regards,

kaushal

[Former Member]

Hi kaushal malavia ,

Thanx for the reply.

Where can I see the data you mentioned in SAP. Pls let me know.

Regards,

Kris

[Former Member]

Hi,

i told you run that command on AS400 host of you sap system.

login on to AS400 host using telnet. ( qsecofr user)

and run wrkshrpool and provide the result.

regards,

kaushal

[Former Member]

Hi Kaushal,

Thanx for the response. Our systems are sun solaris. can you pls tell me how to trouble shoot the problem.

Regards,

Kris

[JanStallkamp]

Hi Kris.

>

> Thanx for the response. Our systems are sun solaris. can you pls tell me how to trouble shoot the problem.
> Kris

In this case you are in the not in the right forum. I will move this thread to the SAP on Unix forum. In this forum we are dealing with DB2 for i5/OS only.

Best regards,

Jan Stallkamp