Hi Experts,
The BW reports on our portal are running dead slow. All other applications on it running pretty quick.
Portal 7.0 NW2004s SP11 (3 BI components patched to 12 as per SAP note). We have two server nodes and there are just 10 to 15 users logged on to it.
OS UNIX AIX 5.3 . JVM 1.4.2 but not IBM J9 .
The backend BW response time is ok ( avg. 800ms).
From Visual Admin Monitoring service for portal
Server1
Avg response time=1598
Component cals =25990
No:of request =7717
Available mem = 2048MB
Used mem = 906MB
Server0
Avg response time = 3524
Component cals =28354
No:of request =8288
Available mem = 2048MB
Used mem = 1471MB
How can we improve it? Is it really the portal running slow or BW backend thats giving the problem ?
Please suggest me ways to improve portal performance and how to troubleshoot it?