topic Re: Very High processing time in STAD in Application Development and Automation Discussions

Very High processing time in STAD

Former Member — Wed, 14 Nov 2007 11:15:55 GMT

I have a problem in my NW04 BI system.

Users are occasionally experiencing high responsetimes while using the HTTP interface to work with BI reports.

If I display the statistical records STAD I can see that while using the SAPMHTTP program the "processing time" and therefor "Total time in workprocs" are very high but other times in the record are very low. CPU time is very low. Below is the detailed analysis.

CPU time 94 ms

RFC+CPIC time 0 ms

Total time in workprocs 481.566 ms

Response time 481.566 ms

Wait for work process 0 ms

Processing time 481.093 ms

Load time 1 ms

Generating time 0 ms

Roll (in+wait) time 0 ms

Database request time 226 ms

Enqueue time 0 ms

DB procedure call time 246 ms

Number Roll ins 1

Roll outs 1

Enqueues 8

Load time Program 1 ms

Screen 0 ms

CUA interf. 0 ms

Roll time Out 0 ms

In 0 ms

Wait 0 ms

Frontend No.roundtrips 0

GUI time 0 ms

Net time 0 ms

No. of DB procedure calls 1

Can anyone tell me what is going on in the system or how I can go further to analyze this. You might assume that this is a CPU bottleneck but it is not, I am using 4 x 64bit processors and 12Gb memory with load of 5-10% when this problem occurs.

Best Regards

Sindri

Re: Very High processing time in STAD

Former Member — Tue, 18 Dec 2007 09:21:49 GMT

hi,

it seems that the database is the bottleneck...

please check detailed infos on:

[http://help.sap.com/saphelp_nw70/helpdata/en/44/c84e12c84b5478e10000000a422035/frameset.htm]

Re: Very High processing time in STAD

Former Member — Tue, 18 Dec 2007 10:08:37 GMT

why should the database be a problem, it is

> Database request time 226 ms

Go to the details (double click) of the line with problems. In the details you should have a button 'http' in the action line. There you can chewck the http details which should tell you where the time was spend.

As always, repeat your measurements a few times to see whether the behaviour is reproducible.

Siegfried