April 10, 2013 at 6:12 pm
Hi All,
I am loading a table of data(1TB) from one server to other, I am loading it through SSIS using execution utility. Initially when i started the process i noticed that the load take 60 Secs to load 100K records, gradually the time keep on increases to load same 100K records. Now it is taking 560 Secs(and still increasing....) to load 100K records. Can you Please let me know how can i make it to run fast. without stop and start the process or restart the windows server.
Can i run DBCC DROPCLEANBUFFERS command is it is advisable ?
Thanks in advance!
April 10, 2013 at 6:29 pm
Couple of things that would help here, the DDL for the tables and the indexes defined on the tables also, the query being used to pull the data (I know you said you are using SSIS, but how are you selecting the records from the source table is what I'm interested in here).
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply