BI Portal 7.0 Performance issues. Overall system slowness during busy times

[Former Member]

I am looking at a BI Portal 7.0 performance issue. The portal is very slow at times on production. the same bi reports are much faster on QA. Backend processess are not experiencing performance issues. I only have 1 server per instance and two instances. How do I determine the need to create a second or third server?. Is there a key metric I should look at to determine the need for 2nd or 3rd server processes? I have recently installed wily/smd and now have this data available.

Thanks for your suggestions on identifying the issue and when to add server1, server2 etc

[former_member197561 · Accepted solution]

Hi,

to identify the issue use SAP JVM Profiler http://www.sdn.sap.com/irj/scn/downloads?rid=/library/uuid/a0a67d7d-36e9-2a10-3a99-94fc8caaea0e

To decide if additional server node would be helpful look at the gc activities - if they are more frequent than 1 second for small gc and 10 minutes for full gc, consider additional server node.

Make sure that there is enough free RAM, i.e. the java server would fit into RAM without pushing other processors out of RAM.

Best Regards,

Sylvia

[Former Member]

As you do not provide any other features you should execute a sizing for your system.

Like: http://www.sap-press.com/product.cfm?account=&product=H2904

This may provide any other requirements your system needs.

[Former Member]

Hi Patt,

I would suggest to run the same query in RSRT with debug mode to check how it runs in ABAP stack and if it runs within the expected time then we go and check the Java Portal part.

Please let me know your feedback on this. I will happy to help you.

Thank you,

Tilak