Slow query between linked servers
Posted on 2011-10-31
In my test environment I have a query that crosses two linked servers. They are both under that same instance of SQL 2005. When I run the query in the test environment, it returns results in about 10 seconds. When I deployed it into production, the exact same query takes 2 1/2 minutes. The biggest difference I see is that in production one database is SQL 2005 and the other is SQL 2000. There are separate instances for both on the same server. Could this be the reason for the slow response time and is there anything, short of dumping SQL 2000, to help speed this up?