Table 4. ETL parallel bulk loads into FACT_SHIPMENT, clustered index, no secondary indexes, partitioned across 27 disks.
Bold highlights the configuration with best performance.
# of parallel loads
The charts below summarize the data from previous tables in a graphical form, showing performance
in records inserted per minute for varying number of parallel loads. For partitioned tables the best
performance occurs at 16 parallel loads (equal to 1/4 of the available CPU cores) and for non-
partitioned tables at 64 parallel loads (equal to all available CPU cores).