SQL WAIT TYPE – OLEDB and how to reduce it

15 October,2011 by Tom Collins

SQL Server Books online defines the OLEDB wait stat type as “Occurs when SQL Server calls the SQL Server Native Client OLE DB Provider. This wait type is not used for synchronization. Instead, it indicates the duration of calls to the OLE DB provider”

Examples of where OLEDB wait type may occur is on an application replication. An application may connect to the SQL Server database – and issue a client side replication whereby millions of rows are replicated row by row.   The client may have to traverse a  below par performing network path.  

Other examples include: BULK INSERT, search queries, queries using linked servers.

OLEDB is an API that extends the data store into the application. Data source, rowsets, commands and session are abstracted. The application provides data and is consumed by the database , without the application having to deal with technology platform specifics.

 Troubleshooting the OLEDB wait type

1)  OLEDB wait type suggests SQL Server is waiting for a resource outside of SQL Server.  For example , an Excel spreadsheet on a desktop. Identify the application and focus on tuning the application.

2)      Locate the client application . Is it following a low performing network path?

3)      Analyse the other wait types , such as RESOURCE SEMAPHORE .

 


Author: Tom Collins (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on SQL WAIT TYPE – OLEDB and how to reduce it


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer