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.
| 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).aspxand this http://msdn.microsoft.com/en-us/library/ms141031.aspxbut 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 |
|
|
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" |
 |
|
|
|
|
|
Strange results for Package execution time