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
Perfromance issue while loading into SQL Server 2008
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 5
- Joined: Thu Oct 20, 2011 1:35 am
- Location: Bangalore
Re: Perfromance issue while loading into SQL Server 2008
Find the way to use BCP utility.
DS User
DS User
-
- Premium Member
- Posts: 5
- Joined: Thu Oct 20, 2011 1:35 am
- Location: Bangalore
Re: Perfromance issue while loading into SQL Server 2008
Is any other way around like setting some parameters or Array size in ODBC Connector to increase the performance?
Reddy
Re: Perfromance issue while loading into SQL Server 2008
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
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
rAKESH