Description
Accumulates while SQL Server is using the OLE DB (as opposed to ODBC). It is common to see this wait type on instances hosting Linked Servers. OLE DB is also used in Bulk Insert, the Full Text engine and within SQL Server Management Studio
Resolved by
DBAs and Developers
Suggested solutions
- Ensure that Linked Servers are configured as per best practice (see additional research below)
- Optimize queries running over Linked Servers
- Keep transactions over Linked Servers as short as possible
- For bulk loading ensure that files are placed on fast storage
Additional research
Recommendations for Linked Server Performance Improvement
SQL Server OLEDB Wait Type