Is there anyway to speed up queries via LinkedServer?

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  January 13, 2016 at 2:08 pm

  #324023

  In my wait stats report I found that OLEDB is among top 3 counters. Is there anyway the performance can be improved by doing any tweak with LinkedServer? Any suggestion(s)?

  Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738683

  More actions

  January 13, 2016 at 2:22 pm

  #1851741

  Depends on the queries. Multiple things can be done

  https://support.microsoft.com/en-us/kb/2876733

  http://thomaslarock.com/2013/05/top-3-performance-killers-for-linked-server-queries/

  http://stackoverflow.com/questions/10204498/optimizing-sql-query-with-a-linked-server