There was a lot of response on the ETL performance test that was published last week so I have published the source code for all the tests at the below link.
Happy testing, also please feel free to share any interesting finds. I have highlighted the first DFT to show the impact of not pre sizing the database files when performing ETL.
30 min ETL brought down to 1 min just by preventing auto growth.
Source code
Database backup File
https://s3-ap-southeast-1.amazonaws.com/sourcecode.enabledbusiness.com/SSiS+ETL+performance/etl
Actual data (BIG FILE)
Please Consider Subscribing