We were having some problem with Delta Queue of 0CRM_SALES_CONTR_I and it was stuck up for around 7 days in SYSFAIL. We have managed to correct the queue and then restarted the delta upload with option "PSA and subsequently into Targets". It completed the pushing from CRM to BW in around 32 hrs with 3.12 lacs records ( in 2634 data pkts).
But the subsequent upload from PSA to Target is running for around 70 hrs now and it has completed 80%.
The point of worry is that the job was initially taking less than a minute for each data pkt, but now it is taking more than 4 mins to update one.
Things we have already checked for:
1. All DB Statistics are current.
2. The PSA table partition for this Request contains only around 4 lacs record. indexes are current.
3. Around 40% of server memory is free. Moreover, no IO contention.
Can you please help me out with ideas to speed up the things.