Linked Server Perfomance Issue

• Clive Strong

  SSChampion

  Points: 11222

  More actions

  June 21, 2004 at 5:36 am

  #82999

  Hello All,

  I am experiencing an issue with a Linked Server query which I don't quite understand.  The Linked Server is in SQL Server 7 and is being queried from a SQL Server 2000 box.

  Here is the query...

  SELECT SDDCO, SDDCT

  FROM <SERVER>.<DB>.dbo.SalesHist

  WHERE SDDCO = 5000129 AND SDDCT = 'RI'

  The table contains approximately 2.5 million rows.  If I run the query on the local box, the row is returned instantly, which is what I expect.

  Now for the fun part.  When I run this query above, it completes in about 1m 30 seconds.  If I execute the query using only WHERE SDDCO = 5000129 then it completes instantly.

  Also, if I use SELECT * and run the statement with both clauses in the WHERE, it executes for some 15 minutes without anything being returned.

  Any idea's as to what the issue could be.  The SalesHist table has 21 columns.

  Cheers,

  Clive

• vbenus

  Ten Centuries

  Points: 1053

  More actions

  June 21, 2004 at 6:35 am

  #511199

  hi,

  try to set "Use Remote Collation" property of your linked server.

   

   

   

  ---

  Kindest Regards,

  vbenus

• Clive Strong

  SSChampion

  Points: 11222

  More actions

  June 21, 2004 at 6:51 am

  #511202

  Nice one...That worked!

  Thanks,

  Clive