SSIS 6 million rows in 60 seconds on standard laptop

Here you can leave a comment related to SSIS 6 Million rows in 60 seconds on standard laptop that we published on SQLServerCentral.com
SHARE:

Name: goran
Comment:

i'd like to see the perf if recovery model was FULL or BULK ... it would be interesting to see across all 3.
Date Posted: 09/02/2013 12:06:23 AM

Name: Emil
Comment:

Hi

There are many combination which is why I want to build a framework so anyone can set different settings and test it out. Changing FULL to Simple had considerable and I suspect BULK will behave in a similar way as Simple (minimal logging) but obviously running it would be best.

Regards

Emil
Date Posted: 10/02/2013 10:57:50 AM




Disclaimer: While every caution has been taken to provide our readers with most accurate information and honest analysis, please use your discretion before taking any decisions based on the information in this blog. Author will not compensate you in any way whatsoever if you ever happen to suffer a loss/inconvenience/damage because of/while making use of information in this blog.