Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to transfer data from one table to another in the same database using SSIS. It seems to go fine (I can see the record count going up) until it gets to about 30 million records, then it starts pausing. It will resume again but there are really long pauses in between. I've made sure to set my initial database size large enough so that it won't have to grow during the process. I am using OLE DB as a source and destination with fast load. Any ideas why it runs great and then slows right down?


migration rejected from Sep 29 '13 at 7:45

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as unclear what you're asking by Max Vernon, Nick Chammas, Paul White, Mat, dezso Sep 29 '13 at 7:45

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

Is there a lot of disk activity during the pauses? – Jon Seigel Apr 21 '13 at 20:42
How do you have your OLE DB Destination configured? What is the commit size? What about transactions, does your package enlist in one? – billinkc Apr 22 '13 at 0:45
Is the size of your log file sufficient as well? Log growths could explain the behavior you're seeing. – StrayCatDBA Apr 22 '13 at 14:48