PREEMPTIVE_OLEDBOPS

PREEMPTIVE_OLEDBOPS Wait Type

This is related to the OLE DB Provider, which can apply to linked server connections.

Added in SQL Server 2008.

Linked servers can be extremely inefficient on some joins.

One option to help this is to change the query to use OPENQUERY function and you may see a drastic improvement. I have seen linked server joins where it pulls all rows across the linked server from two tables then does the join. Using OPENQUERY can help force the JOIN work to be done on the other side rather than pulling back all the data.

Related Links:

• Database Health Monitor Wait Monitoring: http://databasehealth.com/historic-db-reporting/