Home Forums SQL Server 2008 SQL Server 2008 - General PREEMPTIVE_OLEDBOPS cause of slow down remote query RE: PREEMPTIVE_OLEDBOPS cause of slow down remote query

  • January 26, 2011 at 8:45 am

    #1278519

    spidey73 (1/26/2011)

    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.

    You are probably using the four part naming convention to run the remote query. This will pull back all the data from Server A and filter it on Server B. You should use OPENQUERY() as this will filter on Server A and only return the results.