I've got two machines:
Server A: SQL 2008: contains the database on which the query is executed.
Server B: SQL 2005: the server from which the query is executed,
When I execute the query directly on Server A, it takes 7 seconds to complete.
Executed on Server B, it will complete in 2,5 minutes.
When I monitored it simply in the activity monitor (on server B), I saw a lot of PREEMPTIVE_OLEDBOPS waits alternating ODBC waits.
Does anyone know where to look for the bottleneck?
I presume it's got something to do with the connection between server B to Server A.