BO 4 Performance (network band width impact)

[former_member251899]

Hi there, we are in process to deploy Web Intelligence reports and Dashboards (using dashboard designer) at 3 sites/ofices (CA, TX, NY) in US for the same company. The BO server is located in CT which hosts the application server, databases (cms and audit) and web server (tomcat). We are using a Windows 2008 Enterprise server and BO version is BO 4.0 sp6.  What we are noticing is that the reports and dashboards are performing great in CA however TX and NY offices are experiencing performance issues and the reports and dashboards take longer to load. My question to you is, how can I measure network bandwidth and prove to the management that TX and NY offices have network issues rather than BO issues. Because the users are pointing fingers saying that BO is slow. the users access reports through launchpad. Regards, samique

[Former Member]

Hi Samique,

If you use tools like wireshark and fiddler you should be able to see the time each packet takes to get to the respective locations.

I would suggest you do the following

1) Choose 1 Webi Report, 1 Dashboard, 1 Crystal etc.

2) Make sure you have access to a desktop pc at each location

3) Use the above mentioned tools to monitor the execution of each one of the objects. Record this and then compare the packet header traffic times etc.

4) Get the network teams at each end to also monitor the traffic to those specific PC's and also from the server.

This is the only way that I have found that one can prove to Business and IT that this is the problem. Make sure that you use an administrator type of user to execute and also that the JAVA and PC specs are the same for each site.

Let me know if this won't work for you then I can maybe suggest another approach.

Regards

Jaco

[former_member251899]

Thanks Jaco and everyone else. I will try the method you suggested Jaco, and get back to you. Regards, samique

[Former Member]

Good luck. The uphill battle is usually to get IT to participate in this process. Will wait your feedback to know that this issue is solved.

Regards, Jaco

[former_member191664]

Have you run tracert (Windows) or traceroute (Unix/Linux) from TX and NY to CT to find out where the network bottleneck is? Hope this helps, Jin-Chong

[former_member207735]

Refer below links, see section wireshark

BI Platform Root Cause Analysis Wiki - Business Intelligence (BusinessObjects) - SCN Wiki

Also see

http://scn.sap.com/community/bi-platform/blog/2013/01/14/how-to-troubleshoot-any-issue-in-your-sap-b...

Cheers

Pa1