How To check bottlenecks in SAP

[Former Member]

Hi Experts,

What are the parameters we need to monitor at the time of slow experience of the performance of the system , we are having two IBM power 4, AIX 6.1 , systems with Oracle 10.2.0.4 systems.

One is  System is central instance and another is application instance, and we are having 330 users in SAP.

Please suggest us.

Regards

Rj

[Former Member]

 at the time of slow experience of the performance

So this behaviour is not always!

Just check what are active during the slowness of system?

Check ST06 for utilization, Check SM66 for active jobs/sessions, Check ST04 for expensive SQL statements, Check DB12 for active DB schedule jobs.

Once you got the clue, further investigation/tuning can be done.

Most of the times, I observe such slowness due to some high expensive SQL statements/bad program!

Regards,

Nick Loy

[Former Member]

Hi Rajat

When you say performance is slow on the system ,

I assume that you are meaning the overall SAP Performance.

There are several reasons for the same as mentioned above also in the replies :

a) At OS Level   -  as pointed out in the above replies

b) DB Level - during the time of the performance degradation - please check AWR / ADDM reports which will tell on its own several recommendations.

c) Application level issues - if you see long running queries in the system , then you need to go for Performance tuning

618868     FAQ: Oracle performance

In short , it requires a holistic approach for performance tuning of the overall system - unless you have some specific observations of performance degradation.

Thanks

Rishi

[Reagan]

Hello

First analyse the topas command output.

Check the memory assigned for SAP and Oracle on the CI node and memory assigned for SAP (AS) on the second node.

Check whether the memory assignment is within the available memory.

Also check the swap space configuration.

You should also check the available CPU on the servers.

Regards

RB

[Former Member]

Hi,

Please check ST02 and see what are the details in there.

How much is the box utilized (CPU and the memory). Use TOP or glance to see the memory and the CPU.

How much do you see the work processes are busy.

How much memory is allocated to the database....Can you please also check the database performance in db02.

Thanks

Rishi Abrol