Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 2 down vote favorite

Is there any relationship between the OLEDB Wait Type and functions? Trying to troubleshoot why I would have 77% of my waits as OLEDB wait type when we have no linked servers. I have a vendor database with a high number of both Table-valued functions and Scalar-valued functions and was curious if they could at all be related to the OLEDB wait type.

Most of the documentation I have found points to Linked Server queries for this wait type, but that's not the case for us.

share|improve this question

1 Answer

up vote 2 down vote accepted

OLEDB waits cover a variety of states, including (but not limited too) client-side profiler traces, some DBCC commands, materialisation of DMVs, possibly some full-text functions in 2005 (IIRC, most have been split out to FT specific waits in 2008) and also linked server queries as you mentioned.

I'm not aware of UDF functions inherently resulting in OLEDB waits, unless they are performing one of the actions I mentioned above.

Rather than looking at the raw percentage wait time attributed to OLEDB, have you checked the average wait time per wait? It may prove to be so low as to be insignificant.

share|improve this answer
You're exactly right, the average wait time per wait is 5.2 milliseconds - not long at all. Thanks for the additional info on OLEDB, too. – MW_DBA Aug 5 '11 at 17:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.