Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 22, 2012 at 03:01 AM

    What is the value for following:

    abap/heap_area_total

    abap/heap_area_nondia

    abap/heap_area_dia

    and Oracle parameter sga_target .


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Premlesh Sharma,

      Here you have it:

      abap/heap_area_total = 40894464000

      abap/heap_area_nondia = 0

      abap/heap_area_dia = 2000000000

      and Oracle parameter sga_target = 0

      Kind regards,

      samid

  • Oct 22, 2012 at 06:19 AM

    Dear Samir,

    As I can see there is a Z program involved kindly ask the author of this program to check Please inform the author and check with trace SE30.

    Thanks

    Tabrayz

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Samid,

      Firstly, ST05 should capture trace details while you set it with that user. Did you set the trace in the same application server where the job/processes are running ?

      One more thing - try these, you should get some data

      1. While you set in ST05, enable Buffer trace as well.
      2. Also set an ABAP trace in SE30

      Usually parallel processing consuming multiple CPU for a particular job depends on application logic, not a basis task. And it is quite complex, mostly they do serial processing.

      However, we should again try to trace and find the root cause.

      Thanks,

      Samik