Skip to Content
avatar image
Former Member

Data loading slow in BI server

hi all,

We have installed our BI production server recentlly. while loading data BI functional consultants complain of poor speed. The process which took only few seconds in development and quality system is taking several minutes in the production system even though the production server is a complete dedicated server for the BI production with 32GB RAM. being a basis person Please help us in identifying the issue in the production server which is causing the speed to be so slow in the prod server as the prod server would be used by users who wouldnt like to wait for so long. and what can i do to improve the speed of the servers.

thanks,

Priya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 01, 2010 at 04:48 AM

    Hi,

    you can remove oraarc data from BI server for better speed & if you want to keep backup of this data ,than you can write this data on exteranal drive or any other storage media.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 01, 2010 at 05:17 AM

    Very generalized question .... You need to analyse all in complexe no general answer are awailable in your situation ...

    For example try to analayse are this DB problem, or SAP problem? That are your DB? Are you check the ST03N and ST04 ?

    Any other information ? Are you have BASIS ADMIN for example ? Without basis admin SAP should be stand 😊

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 01, 2010 at 10:45 AM

    a production system usually charge more data than a dev or quality. For a comparison all systems should be aligned.

    However, there are a lot of parameter (db and sap) for improve the performance on BI system.

    But your request is too general to point you to a solution

    So, explain us if the problem is on a process chain, infopackage, hub, data from psa...etcetc..

    ciao,

    Cristian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      loading from PSA takes always less time.

      However, is quite generic a time load issue, certainly the production system will have more data so it is not always possible to use development and test as reference.

      Anyway, i think you should focus on the tuning (using the SBIW)

      For example

      on R3 you have to customize the dat aload.

      on BW for datamart.

      So, in R3

      maximal package size in kB (default 10,000 KB)

      maximum package size in number of records (Maximum memory consumption per data package is around 2Max. lines1000

      Byte)

      Frequency of Info IDocs. Default: 1. Recommended: 5 - 10

      Max proc. (= maximum number of dialog workprocesses which were

      allocated for this dataload for processing extracted data in BW)

      in BW

      values recomended

      Recommended values:

      – max size: 20,000 – 50,000 (kbyte)

      – max lines: 50,000 – 100,000 (Data lines)

      – frequency: 10

      – max proc.: 2 – 5

      there are a lot of parameters to set, but i suggest you to proceed stepbystep.

      ciao