Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-31 : 08:16:16
|
| Anoop writes "I hope you will be able to guide me in my problem.I am trying to BCP-out & BCP-in a big table (In order to change the collation of the table). To improve the performance of the script, I was trying parallel BCP -out operations.ie If the table is having 100 records, I try to perform 10 BCP -out operations parallely, by specifying the start record number & end record number for each BCP-out operation. But what I have observed is that though I can see all BCP processes in the task manager, only one BCP-out opeartion is active at a time. The next one starts only after the first one completes. The server where I am running this has got 2 processors & more than 2 GB RAM. Could you please tell me why this is happening ? Can I get arround this problem by any means.The BCP-In operation is taking much lesser time compared to the BCP-out, After setting the 'select into\bulk copy' property on. I am trying to bring the time taken for BCP-out also less. Any suggestions would be of great help.Many Thanks.My email id is anoopis@coolgoose.com." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-01-31 : 12:42:35
|
| How are you running the bcp's?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
rishimainidba
Starting Member
30 Posts |
Posted - 2005-01-31 : 22:45:20
|
| Hi Anoop...Can u tell me whether u r running ur BCP from command shell or through query analyser...???Furthermore can I c ur BCP command to know further about it???As per ur description I think there is some kind of locking going on with ur table.Run the bcp command and while it is running, execute "sp_lock" under master database to find out what kind of lock is held by your table while the bcp on it is running in the background.Waiting 4 ur reply.RegardsRishi |
|
|
|
|
|
|
Parallel BCP -out operation.