Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2004
    Haaksbergen, Netherlands

    Unanswered: Slow ODBC datatransfer between Oracle database en SQL Server


    Try to upgrade my current SQL2000 database running on (32-bit) Windows 2003 SP2.
    The SQL database is used as a data warehouse and extracts data from an Oracle 11gR2 database.
    Large tables with millions of records can be extracted in a couple of minutes.

    I did some tests with SQL2008R2, SQL2012 and SQL2014CTP2 all installed on Windows 2012.
    The strange thing is, that I cannot get the performance back on downloading as I had before.
    It takes almost 2.5-3.0 times longer to extract the same tables.
    If I download files from the Oracle server, I can do this with the maximum network speed (1Gbps).

    In both situations I use a linked-server to import the data from Oracle to SQL server.
    I tried several Oracle clients (10g, 11g and 12c) without any difference.
    Tried different MTU settings on the network, no result.
    I also tried faster disks (Enterprise SSD's). This makes a huge difference in query performance, but the "download speed" remains the same.
    Hardware from both old and new SQL Server installations is the same (DL380G6 dual X5660, 16GB RAM).
    Oracle server is an IBM AIX7.1 machine with Power7 CPU's.

    Anyone an idea how I can make the "download" speed better?


    Wim Venema
    Last edited by Wim Venema; 11-15-13 at 10:56.

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 12
    Different ODBC driver/version?

    P.S. I think this might be better suited to the SQL Server Topic, so I'm going to pop in over there
    Home | Blog

  3. #3
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >Try to upgrade my current SQL2000 database running on (32-bit) Windows 2003 SP2.
    It is not clear to me what exactly got upgraded.

    In any case you changed something & then performance was worse than before.
    It seems to the root cause of the slowness is whatever got changed.
    Since Oracle did not change, why are you posting this Microsoft problem on Oracle forum?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Jun 2004
    Haaksbergen, Netherlands
    Yep, you are right...

    Of coarse the ODBC driver is different! 32/64 bits.

  5. #5
    Join Date
    Jan 2003
    Provided Answers: 17
    ODBC does a number of extra things for compatibility reasons that may not go very well with whatever you are doing. Any chance of moving to the .NET providers?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts