OLEDB

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

  1. Ensure that Linked Servers are configured as per best practice (see additional research below)
  2. Optimize queries running over Linked Servers
  3. Keep transactions over Linked Servers as short as possible
  4. For bulk loading ensure that files are placed on fast storage

Additional research

Recommendations for Linked Server Performance Improvement
SQL Server OLEDB Wait Type

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index