DSXchange

Hi,

We have ~12 million(1.8 GB) of records which need to be loaded into MS SQL Server 2008.

While loading initially(say for 2 million records) it will load with 10000 rows/sec but gradually it will reduce to few hundreds. We think it can be Network or buffer related issue.Network speed is 100 Mbps.

Please guide us in increasing the performance.

Thanks,
Reddy

Find the way to use BCP utility.

DS User

Is any other way around like setting some parameters or Array size in ODBC Connector to increase the performance?

Hi guys,

Is there any settings(tuning) to be done for increasing number of rows inserted per second while directly loading to the SQL SERVER database.

Thanks
Rakesh

The "normal" ones are there - Array Size, Autocommit Mode / Record count, etc. What settings are you using? I'd also be curious what "Write Mode" you are using.