on 06-29-2010 6:14 PM
Hi Everybody,
Some moments during the day we are having a performance problem in our PRD environment. The system get slow.
The CPU get 100% of his usage.
The most used process are:
oracle.exe - 35%
disp+work - 30%
disp+work - 11%
disp+work - 05%
disp+work - 05%
In SM50 we have the programs running.
In ST03N we can see the most sequential reads and DB time problems.
If we do a performance tunning of the programs identified we can reduce the performance problem?
Anybody know another solution or where can i get more information to see where exactly the problem is?More transactions
maybe?
Best Regards,
Fábio Karnik Tchobnian
This is a case for SAP course ADM315.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In SM50 we have the programs running.
At what staus they are like commit , read etc; you also need to check for active JOBs get the details.
In ST03N we can see the most sequential reads and DB time problems.
Check for poorest SQL statement from ST04 => SQL cache => remove * => check for total execution time (descending order) => check for latest 3-4 SQL statement with your'e developer to fine tune the programe
This is just for analysis if this is happening every time then above solution for upgrading CPU is worth than tuning
Regards;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> The CPU get 100% of his usage.
>
> The most used process are:
>
> oracle.exe - 35%
> disp+work - 30%
> disp+work - 11%
> disp+work - 05%
> disp+work - 05%
>
> In SM50 we have the programs running.
So I'd say your machine is not sized appropriately (too small, too few CPUs to handle the load).
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.