Skip to Content
0
Sep 07, 2007 at 03:00 PM

Extraction gets too slow at nights (finding the bottleneck)

26 Views

Hi all,

i'm loading historic data from R/3 to BW. The extraction process usually takes 15 minutes per data package, but at nights some packages takes like 1 hr.

Can you helpme to understand in which step of the extraction the gap is ?

Here is a piece of the extraction log form R/3, where you can see the 1hr gap:

05:19:12 Call up of customer enhancement BW_BTE_CALL_BW2

05:19:12 Result of customer enhancement: 100.000 records

05:19:12 Call up of customer enhancement EXIT_SAPLRSAP_0

05:19:12 Result of customer enhancement: 100.000 records

05:19:14 Asynchronous sending of data package 88 in task

05:19:16 tRFC: Data package 87, TID = AC14030C07D946E10C

05:19:16 tRFC: Begin 07.09.2007 04:29:35, end 07.09.2007

-


06:46:15 Call up of customer enhancement BW_BTE_CALL_BW2

06:46:15 Result of customer enhancement: 100.000 records

06:46:15 Call up of customer enhancement EXIT_SAPLRSAP_0

06:46:15 Result of customer enhancement: 100.000 records

06:46:17 Asynchronous sending of data package 89 in task

06:46:21 tRFC: Data package 88, TID = AC14030C07D846E118

06:46:21 tRFC: Begin 07.09.2007 05:19:30, end 07.09.2007

The dotted line is the gap, i need to know what process of the extraction

is running in there.

Thanks a lot in advance !!