This website is not affiliated with, sponsored by, or approved by SAP AG.

BW Query Time in "Others/RFC"

Business Warehouse

Moderators: Snowy, thx4allthefish

BW Query Time in "Others/RFC"

Postby QZ » Thu Aug 21, 2014 3:18 pm

Hi,

I am not sure whether this should be posted to Basis or BW.

We are running BW 7.30 using Business Objects as a front-end. There are a lot of performance
issues with queries. In transaction RSRCACHE, I see that the OLAP cache is sized as
default (4MB local and global), a lot less than recommended.

According to ST03N or the Earlywatch BW report, most of the query time is spent
not in the database, OLAP or frontend, but in "Others/RFC". For example, one query's
average runtime was 3300 seconds, with 3000 seconds in "Others/RFC".

What are some of the issues that can cause the queries to be categorized as spending
so much time in "Others/RFC" (According to Earlywatch)?

Also, if the OLAP cache is very small, can that cause queries that would otherwise
use the OLAP cache to spend time in the "others/RFC" category (Perhaps by
needing appl. server time to run or something else).


Thanks,
QZ
QZ
 
Posts: 221
Joined: Wed Nov 14, 2007 11:02 am

Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 2 guests





This website is not affiliated with, sponsored by, or approved by SAP AG.