cancel
Showing results for 
Search instead for 
Did you mean: 

Webi Performance Issues on XI 4.0

Former Member
0 Kudos

Hello,

We're running XI 4.0 on a VM (Windows 2008 R2) and have serious performance issues opening Webi reports. The java Query Panel takes 30-40 seconds to open. Reports take 15 seconds to open. The same reports displayed no issues whatsoever on XI 3.1 SP 3 FP 3.5.

Could any of the following be the cause?

1. Running it on a VM (VMWare 4.5)

2. Using NAS for FRS?

Also, would it help at all if we were to install the CMS db on the BO server itself ? tnsping to Oracle for the CMS db returns in 0ms right now.

The environment we use is:

Dual Quad-core running at AMD Opetron 2.3Ghz with 32 GB of RAM on 3 servers.

Server 1: BOE full stack

Server 2: BOE full stack

Server 3: Explorer

BO XI 4.0 (build 565)

Windows 2008 R2 on VM

Oracle 11G 64 bit.

Tomcat 6

Java 1.6.29

I'd appreciate any help at all.

Thank you,

Srinivas

Accepted Solutions (1)

Accepted Solutions (1)

denis_konovalov
Active Contributor
0 Kudos

BI4 requires 2+times resources compared to Xi3.1. Have you done a sizing exercise ?

Answers (1)

Answers (1)

Former Member
0 Kudos

How many number of user's ? 32GB RAM Is sufficient for decent amount of users. Did you tune Oracle parameters ?

Apply below parameters in JAVA properties of Tomcat and try again

-Xmx256m

-XX:MaxPermSize=256M

-XX:PermSize=256m

-XX:NewSize=171m

-XX:MaxNewSize=171m

-XX:SurvivorRatio=2

-XX:TargetSurvivorRatio=90

-XX:+DisableExplicitGC

-XX:+UseTLAB

-XX:+UseParallelGC

Former Member
0 Kudos

Denis / Arjun

We are also having smililar issue in our environment. The sizing was done by a consultant as per the sizing guidelines, yet we do not see the performance.

ours is a virtual environment. I tried Arjun's recomendation but of no use. Can you please tell me about the oracle parameters which neeeds to be tuned. Our is issue is of loading the webi applet it takes more than a minute to load.

It would be very helpfull if we could get help in this area.

Thanks

Reddy

denis_konovalov
Active Contributor
0 Kudos

have you tried tracing your network ?

Webi applet is "heavier" in BI4, more files/bigger files are transmitted over the network to your client machines...

Also check this : http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/80476084-ddec-2e10-3c8d-a53ce287f657

If the link doesn't work, just search SDN for "Improving the User Experience in SAP BI Platform 4.0 with Apache and WDeploy"

Former Member
0 Kudos

Hi Dennis,

Thanks for sharing the document it was really helpfull in understanding the new concepts.

Tried tracing network did not find any latency. As we have whole application deployed on tomcat can we deploy the static content to apache or else should we redeploy to tomcat again. My other question is if we deployed in split mode will there be any performance improvement in webi applet load time, is there a way to load java from local machine. In our environment webi applet load time is taking more than two mins. we want to reduce the load time. Upon a friends suggestion we started experimenting on diffrent browsers and found that IE9 was giving approximately the same performance as 3.1, on report opening, the java load is still slow. So is there a way to improve applet load times.

Thanks

Reddy

Edited by: reddygk on Feb 28, 2012 3:25 PM

Former Member
0 Kudos

Hi Denis,

Applets are stand alone java components, i believe that about 70% of its performance related to the actual client(browser).

other 30% can be related to network perfomance (downloading the applet from the server and transactions to the server).

These are the areas you should look into when you search for better applet performance.

hope it helps,

Idan

denis_konovalov
Active Contributor
0 Kudos

Ultimately the applet will be served by the Tomcat, so if tomcat is busy - the time to send all the files applet is requiring will be longer.

Using Fiddler or HTTPWatch, you can see what files, when and where are being loaded and see where the time is being spend.