Direct Connection running Fast,Linked Server running Slow

  • Scenario 1 (Direct Connection - Fast):

    On Server B, when using SQL Server Management Studio (SSMS) to connect directly to Server A by specifying its IP address and using a valid SQL Server login and password, executing the view vwA in database DB01 completes in approximately 1 second.

    Scenario 2 (Linked Server - Slow):

    A linked server named LS01 has been created on Server B, pointing to Server A. However, when the query SELECT * FROM LS01.DB01.dbo.vwA is executed directly on Server B (targeting the linked server), the same operation takes approximately 50 seconds to complete.

    Environment: Both Server A and Server B are running SQL Server 2008 R2 standard edition

    I have finished doing a test using linked server and direct connection to query 100000 pieces of record from one table, direct connection taking about 1 second but linked server taking about 30 seconds, my question is how to improve the performance while using linked server to execute select statement. thanks

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

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

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