Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance problems BW

Hello everyone,

We are facing with some some performance issues in our BW production system. We don´t know what´s the cause for this, so we request some help of you to support us in way to find the solution! We have the SAP BPC installed (SAP BusinessObjects Planning and Consolidation), the BPC when it do a call to SAP BW is running a chain of processes called ZBPC_AUTOMATISMOS_RH (transaction RSPC), this process chain makes a call to the class method in ZCL_HR_IGIF_UJ_CUSTOM_LOGIC~EXECUTE.

   

For a particular object that runs with a small filter data, between 8.000and 20.000 records, for only a cost center, it performs quickly, nearly 1 minute, but with a greater filter of data it takes much longer (isn´t proporcional!), with 200.000 records it takes something like 40 minutes!

 

Let me put here the values of some parameters that I changed after system installation (the server has 64Gb and 97Gb of Paging file):

- SAP Parameters adjusted:

PHYS_MEMSIZE 39000

abap/buffersize 2000000

rsdb/ntab/entrycount 50000

rsdb/ntab/ftabsize 100000

rsdb/ntab/sntabsize 10000

rsdb/ntab/irbdsize 15000

rsdb/cua/buffersize 15000

zcsa/presentation_buffer_area 15000000

zcsa/table_buffer_area 120000000

zcsa/db_max_buftab 7000

rtbb/buffer_length 30000

rdisp/max_wprun_time 3600

gw/cpic_timeout 60

gw/max_conn 2000

gw/max_overflow_size 25000000

rdisp/max_comm_entries 2000

icm/host_name_full ren-ed-43.ren.pt

icm/keep_alive_timeout 3600

rdisp/plugin_auto_logout 3600

em/global_area_MB 768

- Oracle Parameters adjusted:

alter system set sga_max_size=19G scope=spfile;

alter system set db_cache_size=13G scope=spfile;

alter system set shared_pool_size=3G scope=spfile;

alter system set pga_aggregate_target=3G scope=spfile;

This parameters adjustments are correct?

Can you help us please!?

Kind regards,

samid

Not what you were looking for? View more on this topic or Ask a question