August 16, 2006 at 12:03 am
Hi all,
I am running DTS package for loading data to the database, this is the part of the application. The package runs in 4 hours in one server and the same data load takes more than 20 hours in another server. We couldn't find the cause for this performance degradation.
Do anyone have any idea of what might be the cause for this performance degradation.
Thanks in advance
Meena
August 16, 2006 at 4:02 am
Meena
Look at the differences between the two servers - memory, disk, processor. Does the log file continually grow during the import on the second server? Do you have the same indexes with the same fill factors on both databases? Monitor the second server while you run the import and look for things like blocking, locks, page splits and so on.
John
August 17, 2006 at 10:45 am
I had this problem awhile back, and one of the ideas that was given was to make absolutely sure there were no indexes,etc on the databases that was being imported into and then to actually recreate the indexes afterwards. By removing the indexes that I had, I was able to take a job that was 20+ hours down to under 2 hours (20 minutes to import all the information and roughly another 90 to massage the data into the format I needed as well as have the indexes recreated).
Terry
August 19, 2006 at 3:09 pm
you mite as well need to check the logs on both the server and see if you can hit something there...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply