High processing time

[Former Member]

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

[Former Member]

Dear colleguaes,

What mean high "Processing time", where should i find bottleneck?

[former_member188883]

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

[Reagan]

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

[Former Member]

Ok, thanks! Please, dont forget about me, I will look at notes and ask tomorrow!

[Sriram2009]

Hi Albert

1  What is OS / DB Version?

2. SAP System version?

BR

SS

[Former Member]

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.

[Former Member]

I want to add some information. Consultant start a background job, as i understand It adds some data to the system and it can affect to the system perfomance.

[Sriram2009]

Hi Albert

Yes, during the any major data load on the BI system over all the system performance degraded.better you can inform them to hold the data load for some time and then check the overall performance

Regards

Sriram

[former_member188883]

Hi Albert,

To identify system resource problems you may follow the guideline on hardware bottleneck from SAP note 618868

• Hardware Bottlenecks

           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