Post reply

SQL 32 bit to 64 bit linked server performance issue

  • November 12, 2009 at 4:22 am

    #136125

    Hi,

    I have created a linked server using ODBC driver to add 64-bit SQL server instance to my machine where im running SQL-server 32bit version.

    I ran a query which pulls records from my machine (32-bit) and inerts into 64-bit sql server.

    When i run same query in between both 32-bit instances it took only 90 seconds to complete the process of inserting 210500 records.

    But when inserting to 64-bit version, it takes 60 Minutes to do the same process.

    Stragne??? Any help?

    SET @sqlS1 = 'INSERT OPENQUERY (NexusDev, ''SELECT intCustomer_ID, intEmplID, dtModified, dtCreated_At, intSched_ID, dtDate, intStartMinute, intDuration, intException_Code, intStatus FROM tbl_NX_Temp_SchedHeader'') SELECT intCustomer_ID, intEmplID, dtModified, dtCreated_At, intSched_ID, dtDate, intStartMinute, intDuration, intException_Code, intStatus FROM tbl_NX_Temp_SchedHeader'

    print @sqlS1

    EXEC(@sqlS1)

  • August 18, 2010 at 9:41 am

    #1208577

    Were you able to find a fix ..?

    I have the same problem.

    Thanks .

  • August 19, 2010 at 10:41 am

    #1209245

    Have you tried just using a linked server instead of openquery? They are handled differently by the engine.

  • August 19, 2010 at 11:15 am

    #1209267

    I found a Solution to my problem.

    It was caused for and index using the wrong data type in a pivot table, in 32 Bits worked fine, but in 64 Bits seems like it was converting the Column each time.

    Also I granted the right permissions to sp_tables_info_rowset_64.

    And enable RPC in the Linked Server, used for remote execution of stored procedures .

    Hope this helps to anyone with a similar problem.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply