Performance problems on NW04S/BI 7.0 after the upgrade

[Former Member]

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.

Regards,

Balkrishna Kute

The Coca-Cola Company

[former_member194892 · Accepted solution]

Hello Balkrishna,

We experienced the same thing (slower response time after the upgrade). We are running on HP-UX, BI7.0 SP7 and Oracle 10.1.

Our BASIS guy found out that the CBO in 10g was not producing the same explain plan (maybe this is not an issue but I'm not a BASIS so I can't comment...). We have a HIGH message opened and SAP is looking into it. They've checked our Oracle settings and everything was ok.

I'll let you know as soon as they get back to us.

Thanks,

David Theroux.

[Former Member · Accepted solution]

Thanks David for your response. Please keep us posted if SAP comes back with some resolution. We have also reported this problem to SAP.

[Former Member · Accepted solution]

Can any one from the SAP NetWeaver 2004s Ramp-Up BI Back Office Team respond please? Have any other customers other than (David) reported this problem. This will become a hot issue for us as we get closer to go live date (July 06). Thanks!

[former_member192700 · Accepted solution]

Hi Kute,

we have actually no reported issues in this respect, rather in the other way around (improved performance).

Sorry,

SAP NetWeaver 2004s Ramp-Up BI Back Office Team

[former_member194892]

Hello Balkrishna,

Some news on our Oracle performance issue in 10g. Here is the explanation in BASIS words : RBO is not supposed to be supported officially in 10g but it is still used in some places in the Oracle layer which seems to cause the problems that we (BASIS) are experiencing.

This said, it should be impacting some BASIS transactions only and SAP and Oracle are about to fix it as we speak (an Oracle message has been opened). I'll keep you posted once they get back to us.

We've had the chance to do a test with 3.5 on 10g during the upgrade. Performance for loading was ok. We are now upgrading it to 2004s on 10g so I'll let you know once we do the same tests again.

Best regards,

D.

[Former Member]

Balkrishna,

One of the recommendation from SAP is you need to increase your hardware by 25% as the software is much bigger and requires more memory and if you are running with the same configuration it could slow the system down.

Hope this helps,

BP

[Former Member]

BP,

Thanks for sharing this advise. We did not receive this advise before from SAP. I observed that the new upgraded software required more memory which may have contributed to slow performance.

Regards,

Balkrishna.

[former_member192700]

This is correct for the BI JAVA part. Add 25 %.

This is also stated in thread

<a href="https://forums.sdn.sap.com/thread.jspa?forumID=154&threadID=112947&messageID=1262940#1262940">https://forums.sdn.sap.com/thread.jspa?forumID=154&threadID=112947&messageID=1262940#1262940</a>

Cheers

SAP NetWeaver 2004s Ramp-Up BI Back Office Team

[Former Member]

Hi Blkrishna,

we have the same enviroment and we have big performance issues, but we changed from BW 3.5 (non-unicode) to BI 7.0 Unicode.

Now we change the 'current-IO' parameter for AIX also in the development enviroment, so hopefully we receive more effective memory.

Regards,

Adrian Bourcevet

VW Bank

[Former Member]

Hi Adrian,

Thank you for sharing your experience. We had already activated CIO prior to upgrade and had performance improvements in i/o area. However, we wanted benchmark just the upgrade keeping every thing else the same and were disappointed by slow performance.

Regards,

Balkrishna.