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

Duration

(min:sec)

Records/min

Total records

inserted

1

4:12

1M

4.2M

2

4:14

2M

8.4M

4

4:25

3.9M

16.8M

8

4:45

7M

33.6M

16

5:22

12.9M

67.2M

32

29:50

4.5

134.4M

64

68:18

3.9M

268.8M

 

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).

6