SQL Server Performance

download data from Oracle

Discussion in 'SQL Server DTS-Related Questions' started by linus516, Jul 24, 2007.

  1. linus516 New Member

    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
    linus516, Jul 24, 2007
    #2

  2. satya Moderator

    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
    http://www.SQL-Server-Performance.Com
    @http://www.askasqlguru.com/

    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.
    satya, Jul 25, 2007
    #2

Share This Page