Welcome to Qi-U Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
158 views
in Technique[技术] by (71.8m points)

sql server - SSIS going in sleep mood with parallel execution of a one of the package

I have a SSIS package. In the package there are several packages. In one package the task is to execute around 25 stored procedures. I have divided those 25 stored procedures in 8 block. 8 blocks run in parallelly. I found that while executing those stored procedures at random time the SSIS goes in sleep mood without giving any error. Sometimes its in sleep mood for 1 hour, sometime it is in sleep mood for more then 12 hours.

I tried multiple things like instead of 8 blocks i tried 4 blocks, the result is same. But when i run all the 25 stored procedures 1 by 1, the ssis does not goes into sleep mood. it completes all the task including executing 25 stored procedures within 4 min.

SSIS was in sleep mood from 10th jan 10.38 pm. Finished on 11th jan 3.13 pm

SSIS was in sleep mood from 10th jan 10.38 pm. Finished on 11th jan 3.13 pm.

This is the Main SSIS Package

This is the Main SSIS Package.

This is the inner package at step 6 where 25 SP run

This is the inner package at step 6 where 25 SP run. Currently it is designed in 8 block. In each block 3 SP's , runs 1 by 1. Each blocks run separately

I need some help regarding why it is going in sleep mood. What i need to do to prevent this.

Thanks MD. Atibur Rahman


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

Please log in or register to answer this question.

1 Answer

0 votes
by (71.8m points)
等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to Qi-U Community for programmer and developer-Open, Learning and Share
...