SqlBulkCopy approximate performance

c# http sqlbulkcopy sql-server

Question

I want to write a web api which should receive Excel / csv files with around 10 columns and parse and insert into a normalized SQL Server database using SqlBulkCopy (4 foreign key constraints, 2 non-clustered indexes).

What will be approximate achievable TPS (transaction per second) within default timeouts and with 8GB memory?

The upload operation will happen once in a while with approx 1 million records.

1
0
10/19/2014 10:22:58 AM

Accepted Answer

I have tried this scenario and able to achieve 6000 TPS without timeouts and memory overload.

0
10/19/2014 8:32:12 AM


Related Questions





Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow