on 02-07-2009 12:27 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Do you have a large no of routines as part of the update? Can these be optimized
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
73 | |
9 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.