How fast can SQL Server write to disk, and why am I not reaching those speeds? Speed test results
In my previous blog post I set up an experiment to figure out what is the fastest setup for SQL Server and SSIS to extract and load a file into a table. In this post I will be discussing the results of this experiment. The experiment The experiment considered a simple two step ELT process: The different variables that were tested: Total performance Taking the best performing scenario it looks like we can extract and…