August 16, 2012 at 8:00 pm
I have upgraded my Production database from sql server 2005 to SQL 2008 with same configured Windows server. After upgraded to SQl 2008 R2 bulk insert is taking longer time. We update stats and rebuild index every day on this specific table.
From application in 2005 it was taking 22 mins to bulkinsert 10,000 Items, but in 2008 its taking 39 mins. While insert is running I am not able to select anything from the database.
Thanks
Dev.
August 16, 2012 at 8:21 pm
Please send more detail.
I can say please check or compare with temp space and memory there will be a diffrence .
August 16, 2012 at 8:59 pm
Sandeep,
what details you need let me know? We did an in-place upgrade. Run time comparison is from the application log.
August 17, 2012 at 3:54 am
Plz send bcp query
August 17, 2012 at 8:13 am
Dev-812464 (8/16/2012)
From application in 2005 it was taking 22 mins to bulkinsert 10,000 Items, but in 2008 its taking 39 mins. While insert is running I am not able to select anything from the database.
10,000 rows is not that many. 22 minutes seems like a long time for this many rows. (I bulk insert millions of rows and rebuild indexes in less than 5 minutes) How many columns and what data types are there? What batch size are your using and what about the recovery mode of the database? (are your using a staging database?)
What kind of indexes are on the table? are you bulk inserting into stage table or the actual table?
So many things can affect bulk insert performance, we would need to know all of the details.
The probability of survival is inversely proportional to the angle of arrival.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply