Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Strange results for Package execution time

Author  Topic 

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-12-03 : 03:35:13
I am currently running some tests on a SSIS package.

When server had only one singlecore processor, the execution time was about 45 minutes.
We then added a second singlecore processor and execution time went up to 60 minutes!

These timings were made using default settings for properties MaxConcurrentExecutables (-1) and EngineThreads (5).

Then we played around with these properties and we found no performance gain at all.
We have also played with IsolationLevel property to no gain.
The packages are real simple. They load a staging area for a datamart. They just transfer data from one source to another with a minimal of transformations.

Has anyone had some experience in performance tuning SSIS packages?
Are there some general rules of thumb?

I have read this information http://msdn.microsoft.com/en-us/library/ms141031(SQL.90).aspx
and this http://msdn.microsoft.com/en-us/library/ms141031.aspx
but it says nothing about the impact the settings have.


E 12°55'05.63"
N 56°04'39.26"

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2008-12-03 : 11:50:34
The following link recommends testing package by executing directly from dtexec
http://www.windows-tech.info/15/c237d59ca2c1aca3.php

Are the processors 32 bit?
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-12-03 : 12:23:18
Yes.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -