Info: It is not recommended to use Standard SSDs for Log Files!
In my tests a Standard SSD averages to only 1,1 MB/s when writing a huge amount of data to the Log File of a constant size. This seams to be caused by throtteling of IOs, as sometimes the writing speed goes up to 60 MB/s.
In my scenario I’ve been updating ~1 Mio Rows within in a 4.8 Mio Rows Clustered ColumstoreFact Table and it took 3.5 Hours!
Following a speed test when copying a 14GB file from a Standard SSD to a Premium SSD (L: to M:). You may notice the throttling…:
