SqlBulkCopy tests with SqlBulkCopyOptions.TableLock and UseInternalTransaction

// 1,000,000 rows with 10 workers

Creating datatable                                                                   
Filling datatable with 1000000 rows...                                               
Datatable filled.                                                                    
Starting non-indexed runs                                                            
[0] Performing bulk insert on Guids...                                               
[2] Performing bulk insert on Guids...                                               
[4] Performing bulk insert on Guids...                                               
[6] Performing bulk insert on Guids...                                               
[8] Performing bulk insert on Guids...                                               
[1] Performing bulk insert on Guids...                                               
[3] Performing bulk insert on Guids...                                               
[5] Performing bulk insert on Guids...                                               
[7] Performing bulk insert on Guids...                                               
[9] Performing bulk insert on Guids...                                               
[6] Guids insert done in 46601ms.                                                    
[8] Guids insert done in 46891ms.                                                    
[2] Guids insert done in 47691ms.                                                    
[0] Guids insert done in 47789ms.                                                    
[4] Guids insert done in 47931ms.                                                    
[1] Guids insert done in 49729ms.                                                    
[7] Guids insert done in 47245ms.                                                    
[5] Guids insert done in 48717ms.                                                    
[3] Guids insert done in 49910ms.                                                    
[9] Guids insert done in 47903ms.                                                    
Completed in 52915ms                                                                 
Starting indexed runs                                                                
[4] Performing bulk insert on Guids_IDX...                                           
[8] Performing bulk insert on Guids_IDX...                                           
[0] Performing bulk insert on Guids_IDX...                                           
[2] Performing bulk insert on Guids_IDX...                                           
[6] Performing bulk insert on Guids_IDX...                                           
[1] Performing bulk insert on Guids_IDX...                                           
[3] Performing bulk insert on Guids_IDX...                                           
[5] Performing bulk insert on Guids_IDX...                                           
[7] Performing bulk insert on Guids_IDX...                                           
[9] Performing bulk insert on Guids_IDX...                                           
[5] Guids_IDX insert done in 144841ms.                                               
[4] Guids_IDX insert done in 144941ms.                                               
[0] Guids_IDX insert done in 144974ms.                                               
[8] Guids_IDX insert done in 144989ms.                                               
[7] Guids_IDX insert done in 145041ms.                                               
[6] Guids_IDX insert done in 145131ms.                                               
[9] Guids_IDX insert done in 145187ms.                                               
[3] Guids_IDX insert done in 145431ms.                                               
[2] Guids_IDX insert done in 145516ms.                                               
[1] Guids_IDX insert done in 145529ms.                                               
Completed in 145532ms                                                                


// 100,000 rows with 100 workers

Creating datatable
Filling datatable with 100000 rows...
Datatable filled.
Starting non-indexed runs
[0] Performing bulk insert on Guids...
[25] Performing bulk insert on Guids...
[1] Performing bulk insert on Guids...
[75] Performing bulk insert on Guids...
[50] Performing bulk insert on Guids...
[26] Performing bulk insert on Guids...
[51] Performing bulk insert on Guids...
[0] Guids insert done in 2059ms.
[2] Performing bulk insert on Guids...
[75] Guids insert done in 2479ms.
[76] Performing bulk insert on Guids...
[50] Guids insert done in 2695ms.
[52] Performing bulk insert on Guids...
[1] Guids insert done in 2932ms.
[4] Performing bulk insert on Guids...
[25] Guids insert done in 2982ms.
[27] Performing bulk insert on Guids...
[78] Performing bulk insert on Guids...
[6] Performing bulk insert on Guids...
[26] Guids insert done in 3553ms.
[29] Performing bulk insert on Guids...
[31] Performing bulk insert on Guids...
[54] Performing bulk insert on Guids...
[76] Guids insert done in 4054ms.
[77] Performing bulk insert on Guids...
[51] Guids insert done in 4690ms.
[55] Performing bulk insert on Guids...
[2] Guids insert done in 4629ms.
[3] Performing bulk insert on Guids...
[79] Performing bulk insert on Guids...
[4] Guids insert done in 4631ms.
[5] Performing bulk insert on Guids...
[52] Guids insert done in 4996ms.
[53] Performing bulk insert on Guids...
[27] Guids insert done in 4923ms.
[28] Performing bulk insert on Guids...
[7] Performing bulk insert on Guids...
[6] Guids insert done in 4425ms.
[8] Performing bulk insert on Guids...
[29] Guids insert done in 4622ms.
[30] Performing bulk insert on Guids...
[32] Performing bulk insert on Guids...
[31] Guids insert done in 4003ms.
[33] Performing bulk insert on Guids...
[57] Performing bulk insert on Guids...
[78] Guids insert done in 7049ms.
[80] Performing bulk insert on Guids...
[3] Guids insert done in 4676ms.
[10] Performing bulk insert on Guids...
[82] Performing bulk insert on Guids...
[79] Guids insert done in 4676ms.
[83] Performing bulk insert on Guids...
[55] Guids insert done in 6121ms.
[56] Performing bulk insert on Guids...
[14] Performing bulk insert on Guids...
[77] Guids insert done in 6885ms.
[85] Performing bulk insert on Guids...
[5] Guids insert done in 5881ms.
[15] Performing bulk insert on Guids...
[35] Performing bulk insert on Guids...
[54] Guids insert done in 7823ms.
[58] Performing bulk insert on Guids...
[60] Performing bulk insert on Guids...
[30] Guids insert done in 6655ms.
[36] Performing bulk insert on Guids...
[89] Performing bulk insert on Guids...
[8] Guids insert done in 7641ms.
[9] Performing bulk insert on Guids...
[53] Guids insert done in 9689ms.
[61] Performing bulk insert on Guids...
[33] Guids insert done in 7891ms.
[34] Performing bulk insert on Guids...
[19] Performing bulk insert on Guids...
[40] Performing bulk insert on Guids...
[80] Guids insert done in 9079ms.
[81] Performing bulk insert on Guids...
[32] Guids insert done in 10363ms.
[41] Performing bulk insert on Guids...
[57] Guids insert done in 9393ms.
[65] Performing bulk insert on Guids...
[67] Performing bulk insert on Guids...
[7] Guids insert done in 12086ms.
[20] Performing bulk insert on Guids...
[28] Guids insert done in 12695ms.
[43] Performing bulk insert on Guids...
[10] Guids insert done in 9915ms.
[11] Performing bulk insert on Guids...
[90] Performing bulk insert on Guids...
[22] Performing bulk insert on Guids...
[15] Guids insert done in 9230ms.
[16] Performing bulk insert on Guids...
[47] Performing bulk insert on Guids...
[68] Performing bulk insert on Guids...
[91] Performing bulk insert on Guids...
[23] Performing bulk insert on Guids...
[48] Performing bulk insert on Guids...
[82] Guids insert done in 16244ms.
[92] Performing bulk insert on Guids...
[69] Performing bulk insert on Guids...
[35] Guids insert done in 14865ms.
[49] Performing bulk insert on Guids...
[94] Performing bulk insert on Guids...
[83] Guids insert done in 18033ms.
[84] Performing bulk insert on Guids...
[24] Performing bulk insert on Guids...
[70] Performing bulk insert on Guids...
[36] Guids insert done in 17331ms.
[37] Performing bulk insert on Guids...
[71] Performing bulk insert on Guids...
[95] Performing bulk insert on Guids...
[14] Guids insert done in 21840ms.
[72] Performing bulk insert on Guids...
[89] Guids insert done in 18580ms.
[96] Performing bulk insert on Guids...
[61] Guids insert done in 18358ms.
[62] Performing bulk insert on Guids...
[85] Guids insert done in 22444ms.
[86] Performing bulk insert on Guids...
[74] Performing bulk insert on Guids...
[34] Guids insert done in 19093ms.
[60] Guids insert done in 21515ms.
[98] Performing bulk insert on Guids...
[58] Guids insert done in 24050ms.
[59] Performing bulk insert on Guids...
[56] Guids insert done in 25622ms.
[9] Guids insert done in 23228ms.
[81] Guids insert done in 20305ms.
[20] Guids insert done in 21206ms.
[21] Performing bulk insert on Guids...
[19] Guids insert done in 26775ms.
[47] Guids insert done in 21680ms.
[65] Guids insert done in 25793ms.
[66] Performing bulk insert on Guids...
[23] Guids insert done in 19787ms.
[90] Guids insert done in 24791ms.
[40] Guids insert done in 27291ms.
[43] Guids insert done in 26167ms.
[44] Performing bulk insert on Guids...
[67] Guids insert done in 26999ms.
[11] Guids insert done in 26357ms.
[12] Performing bulk insert on Guids...
[48] Guids insert done in 20368ms.
[94] Guids insert done in 18612ms.
[92] Guids insert done in 20663ms.
[93] Performing bulk insert on Guids...
[41] Guids insert done in 29258ms.
[42] Performing bulk insert on Guids...
[68] Guids insert done in 24807ms.
[84] Guids insert done in 19163ms.
[22] Guids insert done in 26881ms.
[70] Guids insert done in 17819ms.
[16] Guids insert done in 27887ms.
[17] Performing bulk insert on Guids...
[91] Guids insert done in 25503ms.
[69] Guids insert done in 23031ms.
[24] Guids insert done in 20165ms.
[86] Guids insert done in 15959ms.
[87] Performing bulk insert on Guids...
[49] Guids insert done in 23829ms.
[96] Guids insert done in 18137ms.
[97] Performing bulk insert on Guids...
[71] Guids insert done in 20087ms.
[37] Guids insert done in 20565ms.
[38] Performing bulk insert on Guids...
[72] Guids insert done in 19263ms.
[73] Performing bulk insert on Guids...
[21] Guids insert done in 12527ms.
[98] Guids insert done in 17807ms.
[99] Performing bulk insert on Guids...
[62] Guids insert done in 18565ms.
[63] Performing bulk insert on Guids...
[74] Guids insert done in 18583ms.
[59] Guids insert done in 16427ms.
[95] Guids insert done in 20316ms.
[12] Guids insert done in 9852ms.
[13] Performing bulk insert on Guids...
[93] Guids insert done in 10198ms.
[66] Guids insert done in 13271ms.
[44] Guids insert done in 12772ms.
[45] Performing bulk insert on Guids...
[42] Guids insert done in 10428ms.
[87] Guids insert done in 7975ms.
[88] Performing bulk insert on Guids...
[99] Guids insert done in 5958ms.
[17] Guids insert done in 10303ms.
[18] Performing bulk insert on Guids...
[63] Guids insert done in 6532ms.
[64] Performing bulk insert on Guids...
[97] Guids insert done in 7661ms.
[73] Guids insert done in 7491ms.
[38] Guids insert done in 7856ms.
[39] Performing bulk insert on Guids...
[13] Guids insert done in 5646ms.
[88] Guids insert done in 3481ms.
[45] Guids insert done in 3887ms.
[46] Performing bulk insert on Guids...
[64] Guids insert done in 3964ms.
[18] Guids insert done in 3965ms.
[39] Guids insert done in 3283ms.
[46] Guids insert done in 1666ms.
Completed in 65127ms
Starting indexed runs
[1] Performing bulk insert on Guids_IDX...
[26] Performing bulk insert on Guids_IDX...
[25] Performing bulk insert on Guids_IDX...
[50] Performing bulk insert on Guids_IDX...
[0] Performing bulk insert on Guids_IDX...
[51] Performing bulk insert on Guids_IDX...
[75] Performing bulk insert on Guids_IDX...
[76] Performing bulk insert on Guids_IDX...
[2] Performing bulk insert on Guids_IDX...
[27] Performing bulk insert on Guids_IDX...
[52] Performing bulk insert on Guids_IDX...
[77] Performing bulk insert on Guids_IDX...
[3] Performing bulk insert on Guids_IDX...
[53] Performing bulk insert on Guids_IDX...
[28] Performing bulk insert on Guids_IDX...
[78] Performing bulk insert on Guids_IDX...
[4] Performing bulk insert on Guids_IDX...
[29] Performing bulk insert on Guids_IDX...
[54] Performing bulk insert on Guids_IDX...
[79] Performing bulk insert on Guids_IDX...
[5] Performing bulk insert on Guids_IDX...
[30] Performing bulk insert on Guids_IDX...
[55] Performing bulk insert on Guids_IDX...
[80] Performing bulk insert on Guids_IDX...
[6] Performing bulk insert on Guids_IDX...
[31] Performing bulk insert on Guids_IDX...
[56] Performing bulk insert on Guids_IDX...
[81] Performing bulk insert on Guids_IDX...
[7] Performing bulk insert on Guids_IDX...
[32] Performing bulk insert on Guids_IDX...
[57] Performing bulk insert on Guids_IDX...
[82] Performing bulk insert on Guids_IDX...
[8] Performing bulk insert on Guids_IDX...
[33] Performing bulk insert on Guids_IDX...
[58] Performing bulk insert on Guids_IDX...
[83] Performing bulk insert on Guids_IDX...
[9] Performing bulk insert on Guids_IDX...
[34] Performing bulk insert on Guids_IDX...
[59] Performing bulk insert on Guids_IDX...
[84] Performing bulk insert on Guids_IDX...
[10] Performing bulk insert on Guids_IDX...
[35] Performing bulk insert on Guids_IDX...
[60] Performing bulk insert on Guids_IDX...
[85] Performing bulk insert on Guids_IDX...
[11] Performing bulk insert on Guids_IDX...
[36] Performing bulk insert on Guids_IDX...
[61] Performing bulk insert on Guids_IDX...
[86] Performing bulk insert on Guids_IDX...
[12] Performing bulk insert on Guids_IDX...
[37] Performing bulk insert on Guids_IDX...
[62] Performing bulk insert on Guids_IDX...
[87] Performing bulk insert on Guids_IDX...
[13] Performing bulk insert on Guids_IDX...
[38] Performing bulk insert on Guids_IDX...
[63] Performing bulk insert on Guids_IDX...
[88] Performing bulk insert on Guids_IDX...
[14] Performing bulk insert on Guids_IDX...
[39] Performing bulk insert on Guids_IDX...
[64] Performing bulk insert on Guids_IDX...
[89] Performing bulk insert on Guids_IDX...
[15] Performing bulk insert on Guids_IDX...
[40] Performing bulk insert on Guids_IDX...
[65] Performing bulk insert on Guids_IDX...
[90] Performing bulk insert on Guids_IDX...
[16] Performing bulk insert on Guids_IDX...
[41] Performing bulk insert on Guids_IDX...
[66] Performing bulk insert on Guids_IDX...
[91] Performing bulk insert on Guids_IDX...
[17] Performing bulk insert on Guids_IDX...
[42] Performing bulk insert on Guids_IDX...
[67] Performing bulk insert on Guids_IDX...
[92] Performing bulk insert on Guids_IDX...
[18] Performing bulk insert on Guids_IDX...
[43] Performing bulk insert on Guids_IDX...
[68] Performing bulk insert on Guids_IDX...
[93] Performing bulk insert on Guids_IDX...
[19] Performing bulk insert on Guids_IDX...
[44] Performing bulk insert on Guids_IDX...
[69] Performing bulk insert on Guids_IDX...
[94] Performing bulk insert on Guids_IDX...
[20] Performing bulk insert on Guids_IDX...
[45] Performing bulk insert on Guids_IDX...
[70] Performing bulk insert on Guids_IDX...
[95] Performing bulk insert on Guids_IDX...
[21] Performing bulk insert on Guids_IDX...
[46] Performing bulk insert on Guids_IDX...
[71] Performing bulk insert on Guids_IDX...
[96] Performing bulk insert on Guids_IDX...
[22] Performing bulk insert on Guids_IDX...
[47] Performing bulk insert on Guids_IDX...
[72] Performing bulk insert on Guids_IDX...
[97] Performing bulk insert on Guids_IDX...
[23] Performing bulk insert on Guids_IDX...
[48] Performing bulk insert on Guids_IDX...
[73] Performing bulk insert on Guids_IDX...
[26] Guids_IDX insert done in 61663ms.
[49] Performing bulk insert on Guids_IDX...
[98] Performing bulk insert on Guids_IDX...
[24] Performing bulk insert on Guids_IDX...
[1] Guids_IDX insert done in 63356ms.
[74] Performing bulk insert on Guids_IDX...
[0] Guids_IDX insert done in 63431ms.
[99] Performing bulk insert on Guids_IDX...
[25] Guids_IDX insert done in 63460ms.
[50] Guids_IDX insert done in 63797ms.
[2] Guids_IDX insert done in 64115ms.
[75] Guids_IDX insert done in 69171ms.
[27] Guids_IDX insert done in 69217ms.
[3] Guids_IDX insert done in 69263ms.
[53] Guids_IDX insert done in 69303ms.
[78] Guids_IDX insert done in 69684ms.
[77] Guids_IDX insert done in 69907ms.
[54] Guids_IDX insert done in 70954ms.
[51] Guids_IDX insert done in 71258ms.
[29] Guids_IDX insert done in 71319ms.
[52] Guids_IDX insert done in 71694ms.
[28] Guids_IDX insert done in 71742ms.
[76] Guids_IDX insert done in 72036ms.
[79] Guids_IDX insert done in 72079ms.
[4] Guids_IDX insert done in 72259ms.
[30] Guids_IDX insert done in 72284ms.
[55] Guids_IDX insert done in 72380ms.
[80] Guids_IDX insert done in 72846ms.
[5] Guids_IDX insert done in 73471ms.
[31] Guids_IDX insert done in 73791ms.
[6] Guids_IDX insert done in 73826ms.
[81] Guids_IDX insert done in 74471ms.
[56] Guids_IDX insert done in 74972ms.
[57] Guids_IDX insert done in 75126ms.
[82] Guids_IDX insert done in 75169ms.
[58] Guids_IDX insert done in 75224ms.
[32] Guids_IDX insert done in 75441ms.
[7] Guids_IDX insert done in 75608ms.
[8] Guids_IDX insert done in 75652ms.
[33] Guids_IDX insert done in 76124ms.
[83] Guids_IDX insert done in 77888ms.
[9] Guids_IDX insert done in 79688ms.
[34] Guids_IDX insert done in 81493ms.
[59] Guids_IDX insert done in 82380ms.
[84] Guids_IDX insert done in 84889ms.
[10] Guids_IDX insert done in 85126ms.
[35] Guids_IDX insert done in 84863ms.
[60] Guids_IDX insert done in 84719ms.
[85] Guids_IDX insert done in 84652ms.
[11] Guids_IDX insert done in 85039ms.
[36] Guids_IDX insert done in 85116ms.
[61] Guids_IDX insert done in 85512ms.
[86] Guids_IDX insert done in 85843ms.
[12] Guids_IDX insert done in 86230ms.
[37] Guids_IDX insert done in 86064ms.
[62] Guids_IDX insert done in 86396ms.
[87] Guids_IDX insert done in 86281ms.
[13] Guids_IDX insert done in 86472ms.
[38] Guids_IDX insert done in 86436ms.
[63] Guids_IDX insert done in 86358ms.
[88] Guids_IDX insert done in 86071ms.
[14] Guids_IDX insert done in 85790ms.
[39] Guids_IDX insert done in 85877ms.
[64] Guids_IDX insert done in 85615ms.
[89] Guids_IDX insert done in 85621ms.
[15] Guids_IDX insert done in 85521ms.
[40] Guids_IDX insert done in 85060ms.
[65] Guids_IDX insert done in 84649ms.
[90] Guids_IDX insert done in 84121ms.
[16] Guids_IDX insert done in 83832ms.
[41] Guids_IDX insert done in 83501ms.
[66] Guids_IDX insert done in 82961ms.
[91] Guids_IDX insert done in 82535ms.
[17] Guids_IDX insert done in 82269ms.
[42] Guids_IDX insert done in 81631ms.
[67] Guids_IDX insert done in 81168ms.
[92] Guids_IDX insert done in 80570ms.
[18] Guids_IDX insert done in 80059ms.
[43] Guids_IDX insert done in 79343ms.
[68] Guids_IDX insert done in 78662ms.
[93] Guids_IDX insert done in 78258ms.
[19] Guids_IDX insert done in 77551ms.
[44] Guids_IDX insert done in 76995ms.
[69] Guids_IDX insert done in 76295ms.
[94] Guids_IDX insert done in 75759ms.
[20] Guids_IDX insert done in 74984ms.
[45] Guids_IDX insert done in 74270ms.
[70] Guids_IDX insert done in 73402ms.
[95] Guids_IDX insert done in 72772ms.
[21] Guids_IDX insert done in 71826ms.
[46] Guids_IDX insert done in 70943ms.
[71] Guids_IDX insert done in 70300ms.
[72] Guids_IDX insert done in 66330ms.
[22] Guids_IDX insert done in 68450ms.
[47] Guids_IDX insert done in 67484ms.
[96] Guids_IDX insert done in 69521ms.
[23] Guids_IDX insert done in 64551ms.
[97] Guids_IDX insert done in 65595ms.
[48] Guids_IDX insert done in 63723ms.
[73] Guids_IDX insert done in 62813ms.
[49] Guids_IDX insert done in 62423ms.
[98] Guids_IDX insert done in 61883ms.
[24] Guids_IDX insert done in 60939ms.
[74] Guids_IDX insert done in 60831ms.
[99] Guids_IDX insert done in 60800ms.
Completed in 124236ms