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.
Operating System Language
Steps to Reproduce