Load performance Write-Optimized DSO

[Former Member]

Dear all,

I'm looking for some practical tips concerning improving load performance from the PSA to a write-optimized DSO (41M records) via a DTP.

All parameters that could be tweaked have been checked (e.g. packet size, batch jobs, uniqueness of data flag, etc.) and optimized.

However this load stays extremely slow (init load from source to BW is faster).

The BW system runs on SP18.

Please share all your tips our recommendations for us to solve this major issue.

Your help is much appreciated!

Thanks

JvB

[Former Member · Accepted solution]

Hi JvB,

Here are some options I can think of and let you know if I remember something:

1) Increase number of prallel processes in DTP i.e. DTP->GOTO->Settings for bacth monitor->Number of prallel process to 4 or 5.

2) Note 409641 - Examples of packet size dependency on ROIDOCPRMS

The general formula for data transfer is:

packet size = MAXSIZE * 1000 \ transfer structure size

but not more than MAXLINES.

eg. if MAXLINES < than the result of the formula, MAXLINES size is transferred into BW.

3) you should check if there are any locks or deadlocks in ST04 and also System Analysis SM21....it will show u all the details,,, and Short dump in ST22.....there may be some ..

4) Check and Analyze DSO in RSRV. If there are any issues repair it.

5) If you are loading huge volumes of data split the records by Filters in DTP ex. Plant, calendar year or calendar month selections.

And also Try

Try partioning,craeting indexes/secondary indexes or archiving old data.

Check these links for furtehr reference:

/people/martin.mouilpadeti/blog/2007/08/24/sap-netweaver-70-bi-new-datastore-write-optimized-dso

/message/2987899#2987899 [original link is broken]

Good Luck.

Regards

Satish Arra

Edited by: Satish Arra on Feb 7, 2009 9:28 PM

[Former Member · Accepted solution]

Hi ,

the batch process avilable and try to laod the data for some selection based on like like calender year ..

check this link ..

/people/rohit.kamath/blog/2008/03/17/bi-performance-improvements-in-70

Regards,

shikha

[Former Member]

Hi,

Do you have a large no of routines as part of the update? Can these be optimized

[Former Member]

No no routines at all in the transformations, just 1 on 1.