Post reply

Linked Server Performance

  • July 16, 2009 at 3:42 pm

    #208356

    I have a SQL2000 Instance that is performing queries against another SQL2000 "linked server". I'm not familiar with how LINKED Servers are supposed to perform. Are they inherently slow? Is there a better or more efficient method of connecting/gathering data from one server in order to update the original server?

  • July 16, 2009 at 4:27 pm

    #1025944

    i believe i saw thread which stated that openquery against a linked server was faster for a linked server vs a query on your server using 4 partnaming conventions;

    for example, select * from LinkedServer.Databasename.dbo.MillionRowTable where something=somethingelse

    vs

    SELECT *

    FROM OPENQUERY(LinkedServer, 'select * from MillionRowTable where something=somethingelse');

    the reason: the first query gets the million rows locally into temp, then does the filtering, where the openquery does the work on the linkedserver, and returns just the results.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 16, 2009 at 4:29 pm

    #1025945

    Thanks Lowell. I shall try that!

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

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