Skip to Content
author's profile photo Former Member
Former Member

How To check bottlenecks in SAP

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2014 at 01:02 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 07, 2014 at 01:23 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2014 at 03:59 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2014 at 06:20 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.