opendatasource slow

[Oh]

Hi. my problem is: I have 2 sql servers. One is production server,other one is only running a big history database and only used for query. I created a view at production server use opendatasource method.

create view ABC as select *
from opendatasource(
'sqloledb',
'data source=sr01;user ID=sa;password=admin'
).MyDB.dbo.ABC

At first every thing is ok. but from last sunday the query is very slow. I test the history DB, speed is very fast.

On that sunday some guy dis a reboot, is it caused the problem? How can I fix the problem? Help me please!

 

[nigelrivett]

Bit surprised this was evver fast if it is transfering a large table.

Try using the profiler to see what it is sending - this should also highlight what is taking a long time. Could just be that the network has reduced bandwidth for the query.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[Oh]

the history DB server is running on a SQL server which install with MSDN version (and Win2k as so on). Is this cause the problem?