performance tuning

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..

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

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