Perfromance issue while loading into SQL Server 2008

[Narayan Reddy]

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

[SURA]

Find the way to use BCP utility.

DS User

[Narayan Reddy]

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

[Rakesh311]

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

[chulett]

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.