从第二个SQL Server实例中选择数据的最有效方法是什么?

We have an app that uses ASP.NET MVC3 and SQL Server 2008 that works fine. We need to retrieve data from a SQL 2000 database for use in the MVC app. We have linked the SQL 2000 to SQL 2008 and created views on the SQL 2008 machine to read data, however performance is horrible. We even tested putting the two databases on the same machine and using views to read form one to the other, but the results were similar. It seems using views to read from a second datasource is simply not an option. We have an app that uses ASP.NET MVC3 and SQL S