Reg : Poor BEx Query Performance.

[Former Member]

Hello All,

We recently upgraded to EHP 2 SPS 8.

Once we upgraded, we see all the BEx queries on the system taking 3 or 4 times the time that it took previously before the upgrade.

We found that the Data manager time is not affected. We see 90% of the time being spent in OLAP.

Could someone give us directions to find the issue that is causing this performance problem and get it sorted ?

Regards,

Selva.

[michael_devine · Accepted solution]

Hello,

FIrstly please ensure that you are using the SAP GUI 7.20 front end with latest patches for the GUI and BEx.

Then please follow all of the recommendations in these 2 comprehensive WIKI articles for BEx performance.

http://wiki.sdn.sap.com/wiki/display/BI/OptimizingBI7.0BExAnalyzerPerformance2012-Part1%28in+process%29

http://wiki.sdn.sap.com/wiki/display/BI/OptimizingBI7.0BExAnalyzerPerformance-2012-Part2-Statistic+Workbook

Regards,

Michael