Poor Performance on BO 3.1 SP2

[Former Member]

Running BO 3.01 and was hoping the SP2 would solve performance issues.

Machine never spikes on CPU or memory, has 2GB memory. Running Webi is slow, very slow. Right now only five developers are using the system and say that it is almost unusable.

I am thinking there is a configuration problem. Anyone have suggestions on how to turn on any debugging or logging that may help identify the issue or at least give me more info to troubleshoot with?

Thank you.

[Former Member · Accepted solution]

Windows 2003 Std SP2.

[Former Member · Accepted solution]

I noticed in the SAP documentation that an underscore, period, or slashes are not to be used in Windows server names on in VMWare names. What about a dash "-"?

This server is horrible even when given three GB of RAM with only five users on it. I can't believe the software is this bad so there has to be something going on with our config.

Any more ideas?

[former_member142702 · Accepted solution]

Hi,

can you please shutdown the Tomcat and try to use eg. the Universe Designer to create and export a universe in your BOBJ repository? What is the performance there?

Regards,

Stratos

[BasicTek · Accepted solution]

I noticed in the SAP documentation that an underscore, period, or slashes are not to be used in Windows server names on in VMWare names. What about a dash "-"?

I have about 50 VM's with -'s so I hope not...

This server is horrible even when given three GB of RAM with only five users on it. I can't believe the software is this bad so there has to be something going on with our config.
Any more ideas? 

Open a case with support (deployment team), we're just guessing here now.

Regards,

Tim

[Former Member]

Gave the machine 3GB of RAM now, performance has actually gotten worse.

Tomcat is chewing through RAM, CPU is at 100% for the first five minutes after boot.

Anyone else seeing this terrible performance on 3.1 or is it just us?

[former_member142702]

Hi,

what OS (incl.version) are you using?

Regards,

Stratos

[Former Member]

Is anyone out there running on a 64 bit OS? I thought about it since I could give it all the RAM it would want since we have 800 users and a large number of scheduled reports that will chew up memory.

[Former Member]

Dumb question but is Tomcat required?

I know the minimum is 2GB and we are running it but there are only a handful of users so I thought it would be OK. The machine is a VM so I can increade the RAM but reporting is showing it doesn't go above 1.5GB as it is.

Need to look into a few things.

[BasicTek]

tomcat is required for infoview/CMC and other web/apps

If memory is difficult to come by I can tell you what I do to save on my test resources, this is not a suggestion for production.

1) change the tomcat min and max memory to 386

2) stop all unused services in the CCM > Servers and remove the auto start check box from each

3) make sure the CMS and reporting DB's are on another server (this is generally the biggest bottleneck)

I run my 3.1 VM's at 768 with no reporting and basically just a CMS and FRS for most cases. For basic stuff this is fine but 1 long running report and it's time to start ending tasks

but for a production server support won't really be able to assist until you are on a supported platform (2Gig and above)

Regards,

Tim

[BasicTek]

2 GIG is the absolute minimum in the supported platforms guide, but still it seems there is another problem unless you are taxing the server with long running reports.

Do you use the PM stuff? If not in the CMC > Servers > you can stop, disable, and uncheck the box that says start service automatically (on each service properties that isn't being used). I do this on my test machine to free up resources.

You may want to check SAP notes(available in the forum sticky post) on tomcat tuning and webi tuning as there are many settings that may help depending on the types of reports you are running. You may also elect to just open a case with support and have an engineer investigate the problem.

Regards,

Tim

[Former Member]

After researching I found something probably related.

When I log into the server I get errors from Business Objects Performance Manager that pop up as fast as you close them. The event viewer shows errors:

Reporting queued error: faulting application AARepoMgt.exe, version 12.2.0.290, faulting module EnterpriseFramework.dll, version 12.2.0.290, fault address 0x00101110.

And...

Reporting queued error: faulting application AASPC.exe, version 12.2.0.290, faulting module EnterpriseFramework.dll, version 12.2.0.290, fault address 0x00101110.

And...

Reporting queued error: faulting application AADMining.exe, version 12.2.0.290, faulting module EnterpriseFramework.dll, version 12.2.0.290, fault address 0x00101110.

Thoughts?

[former_member142702]

Hi Mike,

which OS does your server run? Can you consider increasing the memory (up to at least 4 GB) on this machine?

Regards,

Stratos