on 04-07-2014 8:33 AM
Dear gurus,
According ADM315:"Processing time more than twice CPU time: CPU bottlenecks". Where in the system i can find information about CPU bottleneck?
Value of "processing time" from st03n:
Task Type Name | Number of Dialog Steps | Average response Time/Dialog Step (ms) | Avg. Processing Time | Average CPU Time (ms) | Ø DB Time (ms) | Ø Time/DB Procedure Call (ms) | Average Wait Time per Dialog Step (ms) | Average Roll In Time (ms) | Average Roll Wait Time (ms) | Average Load and Generation Time (ms) | Average Lock Time per Dialog Step (ms) | Average RFC Interface Time (ms) | Average Frontend Network Time (ms) | Average GUI Time per Dialog Step (ms) | Number of Round Trips | Requested Data (KB) | Number of VMC Calls | Total VMC CPU Time (ms) | Totla VMC Elapsed Time (s) | Average VMC CPU Time (ms) | Average VMC Elapsed Time (ms) |
BACKGROUND | 19 311 | 8 175,6 | 4 602,7 | 2 173,1 | 3 542,1 | 6,9 | 0,2 | 1,8 | 0,0 | 6,2 | 15,7 | 11,7 | 0,0 | 0,0 | 0 | 38 282 613 | 0 | 0 | 0 | 0,0 | 0,0 |
DIALOG | 1 509 | 8 107,3 | 7 766,9 | 169,5 | 80,9 | 0,0 | 4,2 | 5,1 | 243,6 | 2,2 | 4,5 | 29,0 | 95,4 | 227,1 | 6 038 | 904 030 | 0 | 0 | 0 | 0,0 | 0,0 |
RFC | 17 976 | 5 282,7 | 4 862,0 | 173,9 | 92,1 | 1,7 | 0,9 | 0,7 | 321,9 | 2,7 | 0,8 | 95,3 | 1,0 | 1,0 | 978 | 6 710 812 | 0 | 0 | 0 | 0,0 | 0,0 |
Dear colleguaes,
What mean high "Processing time", where should i find bottleneck?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Albert,
As per definition
Processing time = response time -( wait time + database request time + load time +roll time + enqueue time )
If the processing time is high implies response time is higher. Potential issue could be network bottleneck or DB bottleneck.
Refer SAP Note 500235 - Network Diagnosis with NIPING
To identify issues with network.
Hope this helps.
Regards,
Deepak Kori
Albert Samigullin wrote:
Dear colleguaes,
What mean high "Processing time", where should i find bottleneck?
Read this SAP note
8963 - Definition of SAP response time/processing time/CPU time
Regards
RB
Ok, thanks! Please, dont forget about me, I will look at notes and ask tomorrow!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Albert
1 What is OS / DB Version?
2. SAP System version?
BR
SS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Operating system | Linux |
Machine type | x86_64 |
Database system | ORACLE |
Release | 11.2.0.3.0 |
SAP System: BW
Kernel release | 720 |
SAP_BASIS 730 0009
SAP_ABA 730 0009
PI_BASIS 730 0009
ST-PI 2008_1_710 0009
SAP_BS_FND 730 0003
SAP_BW 730 0009
WEBCUIF 730 0003
FINBASIS 634 0003
BI_CONT 736 0003
CPMBPC 800 0009
POASBC 100_730 0009
SEM-BW 634 0003
ST-A/PI 01Q_710 0002
I hope it will help you.
Hi Albert,
To identify system resource problems you may follow the guideline on hardware bottleneck from SAP note 618868
Use transaction ST06 or OS07 to check whether there are sufficient CPU and memory resources on the database server.
The CPU IDLE time should usually appear on the hour average at 30% or more. In this case, you must note that, in certain cases, we seek an optimal load of the CPU for certain tasks and this results in significantly lower IDLE times, without this being critical.
If possible, this should result in minimum paging or in no paging at all. Whilst the page-out rates are pertinent on UNIX, you must give priority to checking the page-in on Windows.
The page-in on Windows also contains accesses to normal files (for example, during backups that do not work with fread/fwrite, see Note 689818). This means that increased page-in values cannot automatically be rated as critical here.
However, in certain circumstances, increased page-out on Windows may lead to problems (for example, due to the problems regarding Windows 2003 that are described in Note 1009297).
As of Oracle 10g, you can also read important operating system information (CPU number, CPU load, physical memory, paging) from V$OSSTAT. You can take details about the CPU (CPUs, CPU cores, CPU sockets) from DBA_CPU_USAGE_STATISTICS.
Secondly for BI systems refer 1013912 - FAQ: Oracle BW performance
Thirdly do some basis activities on your systems like
1) Update database statistics
2) Ensure Oracle database parameters are set as per SAP recommendation.1171650 - Automated Oracle DB parameter check
Hope this helps.
Regards,
Deepak Kori
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
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.