August 5, 2025 at 9:25 am
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
August 6, 2025 at 10:10 am
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