Post reply

Linked Servers And Views

  • July 24, 2003 at 11:11 am

    #162109

    We have our SQL Server 7.0 linked to a SQL Server 2000 and have created views on our server selecting * from the linked server's tables. Which server is taking the performance "hit" when our view is queried?

    David Nilsson

  • July 25, 2003 at 7:22 am

    #467035

    If you fire up profiler you will see that the query is passed through to the other server to execute a rowset object is created on the server with the data. You will still have network issues as the data is passed back to the calling machine and other task performed by the calling server. So, both take a hit but the one with the data takes the biggest hit.

    Wes

  • July 25, 2003 at 12:21 pm

    #467129

    Wes,

    Thanks for the input.

    David Nilsson

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

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