Performance problems on NW04S/BI 7.0 after the upgrade
We have upgraded our development environment from BW 3.1 to BI 7.0. We took some benchmarks before and after the upgrade to measure the impact on performance.
We ran some dataloads and few queries for this measurements.
We were expecting significant performance improvement right out of box after the upgrade. However, we saw about 20% slower performance.
Here is the background info:
1. Running IBM AIX 5.3 and hardware is P570
2. BI 7.0 with SP7
3. Oracle 10.1
Question for all you performance Guru:
Are there any specific turning recommendations for BI 7.0 and Oracle 10G? We are not using new functionality at all. All we want to accomplish is to ensure that existing 3.x applications do not get impacted by the upgrade.
Any help, pointers, tips you can provide are all appreciated.
The Coca-Cola Company