We have a 8 core system with hyperthreading on. An old application using SQLOLEDB protocol version: 1895825409 connects all the time to sql server.
Users get timeout while we see 10% cpu load od sql server. Seen in CPU usage it looks like the sql is primarily using 1 core that is maxed out to 100% , this changes but most of the time only 1 cpu is reallt active.
Users run very small queries for which the application always creates a new connection.
So as it seems the bottleneck is the SQLOLEDB provider that's using just 1 core.
This way uses see very poor performance of SQL Server while I don't see any running queries.
Is this normal behaviour or shoudl the SQLOLEDB provider run multithreaded?
Since cpu usage is on average 10%.. users should not notice such a slow performance when connecting to the server.