Log generation on the primary (node-1) by data disk type, measured before Lab 2 from the bytes written to the log file (sys.dm_io_virtual_file_stats, the counter scripts/20_log_rate_monitor.sql reads) while the bulk and single-row workloads ran. SQL Server vNext CTP 1.2 on Linux. data disk bulk insert (MB/s) single-row inserts (MB/s) log flush per commit (ms) -------------------------------------- ------------------- ------------------------------------- ------------------------- Standard HDD, 256 GB (Lab 1) 25 to 27 7 not measured Premium SSD P30 84 to 92 13 to 15 not measured Premium SSD, P50 performance tier 95 13 to 22 2.4 to 3.0 Ultra Disk, 20,000 IOPS, 500 MB/s 114 to 130 22 to 26 into one table; 0.9 46 to 66 across 16 tables Single-row autocommit inserts wait for the log flush on every commit; Ultra Disk cut that wait to about a third. Into one table, single-row inserts stopped at 22 to 26 MB/s on page latch contention.