SQL 32 bit to 64 bit linked server performance issue

Last Post 04 Feb 2010 03:35 PM by J013-B. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
mukahmed20
New Member
New Member

--
12 Nov 2009 01:27 AM
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)
SQLUSA
New Member
New Member

--
04 Feb 2010 01:15 PM
Can you repeat the test with SSIS?

Thanks.

Kalman Toth, SQL Server 2008 Training
http://www.sqlusa.com
J013-B
New Member
New Member

--
04 Feb 2010 03:35 PM
I think Andrew is onto something. How is the 64-bit machine configured? When you are running the query against the 64-bit machine, can you view the resources on it to get an idea if there is any bottlenecks, contention, high processor usage, etc.?
You are not authorized to post a reply.

Acceptable Use Policy