• Hi , This is a virtual server not sure what difference that will make?

    But in answer to your questions there are no linked servers, so how else would I get OLEDB waits?

    The problem is that during these high usage peeks some queries take a very long time which cause the application which is querying the DB to time out ( As I don’t have any high lock waits I presume there must be a bottle neck) , I will run perfmon counters to see what is happing with the disk ,cpu and memory.

    But I am trying to get more familiar with wait stats to see if I can draw any conclusions from it I see no lock’s CPU or memory pressure. So I just want to see how much I can gain from the wait stats and to figure out why I have OLEDB waits (server was restarted a few days ago)

    Many thanks