Hi
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
Bluesky
