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/
Enroll Today!
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!
Contact Info
Stedman Solutions, LLC.PO Box 3175
Ferndale WA 98248
Phone: (360)610-7833
Download this page in PDF format