Help Troubleshooting Linked Server Speed

Last Post 23 Feb 2005 08:27 AM by fcoulter. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
fcoulter
New Member
New Member

--
22 Feb 2005 01:25 PM
I have a SQL 2000 Server(S1) and I've setup a Linked Server to another SQL 2000 Server(S2). On S1 I have a view that issues a query against S2. It takes 20 seconds to return the result set. However if I setup the same Linked Server on a third SQL 2000 Server(S3), and create the same view, the query returns the result set in 1 second. I've tried running profiles and checked Client/Network Utility settings and server settings, and all appear to be identical. I'm at a loss to this point on how to further troubleshoot this problem. Additionally, one strange item that I've noticed is when I SET STATISTICS PROFILE ON before I run the query to query the view I get different results on S1 as I do on S3. It appears that S1 is doing more work than S3. I get 10 rows return on S1 and only 2 Rows returned on S3. I feel like there is a setting somewhere that I just can't find. Any help would be greatly appreciated.

Frank

The
fcoulter
New Member
New Member

--
23 Feb 2005 08:27 AM
No. Any other server I setup to link to Server2 runs just fine.


Acceptable Use Policy
---