We are using Business Objects 4.0 SP08 in a virtual Server (Windows Server 2012) with 4cpu and 32 GB. Our users can create ad-hoc reports and the use the web client inside the BI Launch pad.
The performance when trying to access the Web Intelligence report is really bad sometimes, it is not associated to one report, or one user, as different users are having the same problems and with different reports. The same report one time will open very fast and one time will take up to 7 minutes. Even if it is in view mode without refreshing. The same query run on the DB the report access runs immediately.
We have divided our APS in a number of them giving them more ram. We also have two Web Intelligence Processing server running. I have been reading all forums about performance and try to do all the tunning settings I found. Can anyone help us? We don't know what else to look at.