Skip to Content
author's profile photo Former Member
Former Member

performance tuning

Hello gurus

can any one of u please let me know the info regarding

performance tuning concept..

and send me the links for the material..

thanx

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 20, 2006 at 06:35 PM

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/cccad390-0201-0010-5093-fd9ec8157802

    Search for BW performance tuning in search box in SDN ..you should get lot of them..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 20, 2006 at 06:56 PM

    Hello Kiran,

    Here are the few tunings mentioned:

    a) If you have enhanced an extractor, check your code in user exit RSAP0001 for expensive SQL statements, nested selects and rectify them.

    b) Watch out the ABAP code in Transfer and Update Rules, this might slow down performance

    c) If you have several extraction jobs running concurrently, there probably are not enough system resources to dedicate to any single extraction job. Make sure schedule this job judiciously.

    d) If you have multiple application servers, try to do load balancing by distributing the load among different servers.

    e) Build secondary indexes on the under lying tables of a DataSource to correspond to the fields in the selection criteria of the datasource. ( Indexes on Source tables)

    f) Try to increase the number of parallel processes so that packages are extracted parallelly instead of sequentially. (Use PSA and Data Target in parallel option in the info package.)

    g) Buffer the SID number ranges if you load lot of data at once.

    h) Load master data before loading transaction data.

    i) Use SAP Delivered extractors as much as possible.

    j) If your source is not an SAP system but a flat file, make sure that this file is housed on the application server and not on the client machine. Files stored in an ASCII format are faster to load than those stored in a CSV format.

    Check the link also:

    Please assign points if it helps.

    Regards,

    Ashok Saha

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 03:19 PM

    Our book on BW performance tuning has a detailed explanation and recommendations and step by step process of how to do the performance tuning. Pl. refer to the following link to know about the book.

    http://www.amazon.com/SAP-Performance-Tuning-Shreekant-Shiralkar/dp/0977725146/ref=sr_1_1?ie=UTF8&s=books&qid=1196767811&sr=1-1.

    You will notice that the book has screen shots and detailed theory on aspects like indexes like B Tree Index or Bitmap Index to help you identify and improve perfromance of your BW system.

    Thanking you in advance for sharing your feedback on the book and its "reference" value for your work.

    Shreekant

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.