December 8, 2008 at 7:39 am
I have query which i have been running since a while which does inserts into a table where it doesnt have any type of indexes. Last week when i ran it it took 2 hrs to insert 12million records and surpriseingly this week when i ran it it took me 10hrs to insert 11million records. What are the things i need to check for boosting performance.
December 8, 2008 at 7:47 am
What other activity is on the server? What is the size of the database and the log and is there free space before you start the insert? Typically you can get better performance in large modifications if you batch it into multiple smaller transactions.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 8, 2008 at 9:49 am
Is that 11 million on top of the 12 million? You could be looking at more and page splits and index reorgs on top of the stuff that Jack mentioned.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 8, 2008 at 10:46 am
11 million is not on top of 12 million, last week was 12 and now its just 11 million. I do not have any type of indexes on any tables.
thanks
December 8, 2008 at 11:42 am
I think what someone is asking is how many rows are in the table when you start (last week and this week).
Are you adding indexes later?
Could you be adding enough data that the data files have to grow in the middle?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply