dbTalk Databases Forums  

Datapump Freeze

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Datapump Freeze in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Radu Colceriu
 
Posts: n/a

Default Datapump Freeze - 05-19-2006 , 01:04 AM






Config:
dual xeon dualcore x64 2.8
8G Ram
SAN LUN Raid 10 FC
Win 2003 Srv 64
SQL 2005 EE
Developing on the server (Dev srv).

I have 2 packages ( actually more). From Package1 I call Package2. Package 2
has in the control flow :

SQL Task(make clean) -> Dataflow Task -> SQL Task(make something)

The Dataflow Task is quite big but the "flow" is not interrupted (SORT) as
datasources I have some RAW Files and destinations Some SQL2005 Tables (no
table lock).
The package is running fast and OK.

Problem:
If I run the package alone everything is working good after changing the max
thread from 5 to 12.

If I run the package from the other package some strange things happend:
the dataflow is starting after the "make clean" and after approx 2.5M
records is freezing (4M in total). The next SQL package (make something) is
starting even the dataflow is not finished. The Dataflow is never finishing.
I must stop it manually.

Freezing: 0 disk activities, 0 CPU act, some tasks in the dataflow remains
yellow or white. The max records on the buffers is set to 10000(def.) and
buff size to (10M def.)
The package is not using more than 500-600M RAM.
There are no locking issues.

Anyone have some ideeas?

Thankx in advance,
Radu



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.