download data from Oracle | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

download data from Oracle

Hi, I have a problem as below: everyday, our SQL Server need to download about 2M records from a Oracle Server. Therefore, I have built a DTS to schedule the job everyday. However, it takes about 3 hours to do that. Any method to speed up the process? Linus
You have to see what other scheduled jobs and processes running during this import scheduled job. Based on the overview you have given it is by default, using PERFMON & server side trace you could get more assessment to review the process. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
@ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.